Changeset: 36c068e73053 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=36c068e73053
Modified Files:
sql/test/SQLancer/Tests/sqlancer04.stable.err
sql/test/pg_regress/Tests/alter_table.stable.err
Branch: default
Log Message:
Approved output
diffs (49 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer04.stable.err
b/sql/test/SQLancer/Tests/sqlancer04.stable.err
--- a/sql/test/SQLancer/Tests/sqlancer04.stable.err
+++ b/sql/test/SQLancer/Tests/sqlancer04.stable.err
@@ -28,7 +28,7 @@ ERROR = !CONSTRAINT FOREIGN KEY: the typ
CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-32314/.s.monetdb.31414
QUERY = CREATE TABLE t1(c0 int, FOREIGN KEY (c0) REFERENCES t0(c0) MATCH FULL,
PRIMARY KEY(c0)); --error, foreign key from int to time not allowed
-ERROR = !CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'c0'
int(32) is not compatible with the referenced UNIQUE KEY column type time(1)
+ERROR = !CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'c0' int
is not compatible with the referenced UNIQUE KEY column type time(1)
CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-42538/.s.monetdb.31166
QUERY = CREATE TABLE t1(c2 BLOB, FOREIGN KEY (c2) REFERENCES t0(c0) MATCH
FULL, PRIMARY KEY(c2)); --error, foreign key from blob to interval second not
allowed
diff --git a/sql/test/pg_regress/Tests/alter_table.stable.err
b/sql/test/pg_regress/Tests/alter_table.stable.err
--- a/sql/test/pg_regress/Tests/alter_table.stable.err
+++ b/sql/test/pg_regress/Tests/alter_table.stable.err
@@ -84,20 +84,20 @@ ERROR = !ALTER TABLE: can't alter tempor
CODE = 42S02
MAPI = (monetdb) /var/tmp/mtest-56887/.s.monetdb.37895
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable;
-ERROR = !CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'ftest1'
varchar(10) is not compatible with the referenced PRIMARY KEY column type
int(32)
+ERROR = !CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'ftest1'
varchar(10) is not compatible with the referenced PRIMARY KEY column type int
CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-56887/.s.monetdb.37895
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable(ptest1);
-ERROR = !CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'ftest1'
varchar(10) is not compatible with the referenced PRIMARY KEY column type
int(32)
+ERROR = !CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'ftest1'
varchar(10) is not compatible with the referenced PRIMARY KEY column type int
CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2) references pktable;
-ERROR = !CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'ftest1'
inet is not compatible with the referenced PRIMARY KEY column type int(32)
+ERROR = !CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'ftest1'
inet is not compatible with the referenced PRIMARY KEY column type int
CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2)
references pktable(ptest1, ptest2);
-ERROR = !CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'ftest1'
inet is not compatible with the referenced PRIMARY KEY column type int(32)
+ERROR = !CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'ftest1'
inet is not compatible with the referenced PRIMARY KEY column type int
CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2)
@@ -107,7 +107,7 @@ CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest2, ftest1)
references pktable(ptest1, ptest2);
-ERROR = !CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'ftest2'
inet is not compatible with the referenced PRIMARY KEY column type int(32)
+ERROR = !CONSTRAINT FOREIGN KEY: the type of the FOREIGN KEY column 'ftest2'
inet is not compatible with the referenced PRIMARY KEY column type int
CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = alter table atacc1 add constraint atacc_test1 check (test>3);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
