Changeset: 15e88c3d5c7d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=15e88c3d5c7d
Modified Files:
sql/test/pg_regress/Tests/alter_table.stable.err
sql/test/pg_regress/Tests/arrays.stable.err
sql/test/pg_regress/Tests/drop.stable.err
sql/test/pg_regress/Tests/horology.stable.err
sql/test/pg_regress/Tests/inet.stable.err
sql/test/pg_regress/Tests/insert.stable.err
Branch: malerrors
Log Message:
approved output
diffs (truncated from 1265 to 300 lines):
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
@@ -28,616 +28,615 @@ stderr of test 'alter_table` in director
MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
QUERY = ALTER TABLE tmp RENAME TO tmp_new;
-ERROR = !syntax error, unexpected RENAME, expecting DROP or SET or ALTER or
ADD in: "alter table tmp rename"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
RENAME, expecting DROP or SET or ALTER or ADD in: "alter table tmp rename"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = SELECT * FROM tmp_new;
-ERROR = !SELECT: no such table 'tmp_new'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42S02 !SELECT: no such table
'tmp_new'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER TABLE tmp RENAME TO tmp_new2;
-ERROR = !syntax error, unexpected RENAME, expecting DROP or SET or ALTER or
ADD in: "alter table tmp rename"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
RENAME, expecting DROP or SET or ALTER or ADD in: "alter table tmp rename"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = SELECT * FROM tmp_new;
-ERROR = !SELECT: no such table 'tmp_new'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42S02 !SELECT: no such table
'tmp_new'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = SELECT * FROM tmp_new2;
-ERROR = !SELECT: no such table 'tmp_new2'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42S02 !SELECT: no such table
'tmp_new2'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = DROP TABLE tmp_new;
-ERROR = !DROP TABLE: no such table 'tmp_new'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:sql.droptable:SQLSTATE 42S02 !DROP TABLE: no such table
'tmp_new'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = DROP TABLE tmp_new2;
-ERROR = !DROP TABLE: no such table 'tmp_new2'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:sql.droptable:SQLSTATE 42S02 !DROP TABLE: no such table
'tmp_new2'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER INDEX onek_unique1 RENAME TO tmp_onek_unique1;
-ERROR = !syntax error, unexpected INDEX, expecting USER or SEQUENCE or TABLE
in: "alter index"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
INDEX, expecting USER or SEQUENCE or TABLE in: "alter index"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER INDEX tmp_onek_unique1 RENAME TO onek_unique1;
-ERROR = !syntax error, unexpected INDEX, expecting USER or SEQUENCE or TABLE
in: "alter index"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
INDEX, expecting USER or SEQUENCE or TABLE in: "alter index"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER TABLE tmp_view RENAME TO tmp_view_new;
-ERROR = !syntax error, unexpected RENAME, expecting DROP or SET or ALTER or
ADD in: "alter table tmp_view rename"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
RENAME, expecting DROP or SET or ALTER or ADD in: "alter table tmp_view rename"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ANALYZE tenk1;
-ERROR = !Schema 'tenk1' does not exist
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:analyze:SQLSTATE 3F000 !Schema 'tenk1' does not exist
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = DROP VIEW tmp_view_new;
-ERROR = !DROP VIEW: unknown view 'tmp_view_new'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:sql.drop_view:SQLSTATE 42S02 !DROP VIEW: unknown view
'tmp_view_new'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table stud_emp rename to pg_toast_stud_emp;
-ERROR = !syntax error, unexpected RENAME, expecting DROP or SET or ALTER or
ADD in: "alter table stud_emp rename"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
RENAME, expecting DROP or SET or ALTER or ADD in: "alter table stud_emp rename"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table pg_toast_stud_emp rename to stud_emp;
-ERROR = !syntax error, unexpected RENAME, expecting DROP or SET or ALTER or
ADD in: "alter table pg_toast_stud_emp rename"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
RENAME, expecting DROP or SET or ALTER or ADD in: "alter table
pg_toast_stud_emp rename"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER TABLE tmp3 add constraint tmpconstr foreign key(c) references
tmp2 match full;
-ERROR = !CONSTRAINT FOREIGN KEY: no such column 'c' in table 'tmp3'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42S22 !CONSTRAINT FOREIGN KEY: no
such column 'c' in table 'tmp3'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER TABLE tmp3 add constraint tmpconstr foreign key(a) references
tmp2(b) match full;
-ERROR = !CONSTRAINT FOREIGN KEY: could not find referenced PRIMARY KEY in
table 'tmp2'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !CONSTRAINT FOREIGN KEY:
could not find referenced PRIMARY KEY in table 'tmp2'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER TABLE tmp3 add constraint tmpconstr foreign key (a) references
tmp2 match full;
-ERROR = !UPDATE: FOREIGN KEY constraint 'tmp3.tmpconstr' violated
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:assert:SQLSTATE M0M29 !UPDATE: FOREIGN KEY constraint
'tmp3.tmpconstr' violated
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER TABLE tmp5 add constraint tmpconstr foreign key(a) references
tmp4(a) match full;
-ERROR = !Create Key failed, key 'tmpconstr' already exists
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !Create Key failed, key
'tmpconstr' already exists
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable;
-ERROR = !ALTER TABLE: not supported on TEMPORARY table 'fktable'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42S02 !ALTER TABLE: not supported
on TEMPORARY table 'fktable'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable(ptest1);
-ERROR = !ALTER TABLE: not supported on TEMPORARY table 'fktable'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42S02 !ALTER TABLE: not supported
on TEMPORARY table 'fktable'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable(ptest1);
-ERROR = !Create Key failed, key 'fktable_ftest1_fkey' already exists
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !Create Key failed, key
'fktable_ftest1_fkey' already exists
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2) references pktable;
-ERROR = !types int(32,0) and inet(0,0) are not equal for column 'ptest1'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !types int(32,0) and
inet(0,0) are not equal for column 'ptest1'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2)
references pktable(ptest1, ptest2);
-ERROR = !types int(32,0) and inet(0,0) are not equal for column 'ptest1'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !types int(32,0) and
inet(0,0) are not equal for column 'ptest1'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2)
references pktable(ptest2, ptest1);
-ERROR = !CONSTRAINT FOREIGN KEY: could not find referenced PRIMARY KEY in
table 'pktable'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !CONSTRAINT FOREIGN KEY:
could not find referenced PRIMARY KEY in table 'pktable'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest2, ftest1)
references pktable(ptest1, ptest2);
-ERROR = !types int(32,0) and inet(0,0) are not equal for column 'ptest1'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
-QUERY = alter table atacc1 add constraint atacc_test1 check (test>3);
-ERROR = !syntax error, unexpected CHECK, expecting FOREIGN or PRIMARY or
UNIQUE in: "alter table atacc1 add constraint atacc_test1 check"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !types int(32,0) and
inet(0,0) are not equal for column 'ptest1'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc1 add constraint atacc_test1 check (test>3);
-ERROR = !syntax error, unexpected CHECK, expecting FOREIGN or PRIMARY or
UNIQUE in: "alter table atacc1 add constraint atacc_test1 check"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
CHECK, expecting FOREIGN or PRIMARY or UNIQUE in: "alter table atacc1 add
constraint atacc_test1 check"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
+QUERY = alter table atacc1 add constraint atacc_test1 check (test>3);
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
CHECK, expecting FOREIGN or PRIMARY or UNIQUE in: "alter table atacc1 add
constraint atacc_test1 check"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc1 add constraint atacc_test1 check (test1>3);
-ERROR = !syntax error, unexpected CHECK, expecting FOREIGN or PRIMARY or
UNIQUE in: "alter table atacc1 add constraint atacc_test1 check"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
CHECK, expecting FOREIGN or PRIMARY or UNIQUE in: "alter table atacc1 add
constraint atacc_test1 check"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc1 add constraint atacc_test1 check
(test+test2<test3*4);
-ERROR = !syntax error, unexpected CHECK, expecting FOREIGN or PRIMARY or
UNIQUE in: "alter table atacc1 add constraint atacc_test1 check"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
CHECK, expecting FOREIGN or PRIMARY or UNIQUE in: "alter table atacc1 add
constraint atacc_test1 check"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc1 add check (test2>test);
-ERROR = !syntax error, unexpected CHECK, expecting FOREIGN or PRIMARY or
UNIQUE in: "alter table atacc1 add check"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
CHECK, expecting FOREIGN or PRIMARY or UNIQUE in: "alter table atacc1 add check"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc2 add constraint foo check (test2>0);
-ERROR = !syntax error, unexpected CHECK, expecting FOREIGN or PRIMARY or
UNIQUE in: "alter table atacc2 add constraint foo check"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
CHECK, expecting FOREIGN or PRIMARY or UNIQUE in: "alter table atacc2 add
constraint foo check"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table /* only */ atacc2 add constraint foo check (test2>0);
-ERROR = !syntax error, unexpected CHECK, expecting FOREIGN or PRIMARY or
UNIQUE in: "alter table /* only */ atacc2 add constraint foo check"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
CHECK, expecting FOREIGN or PRIMARY or UNIQUE in: "alter table /* only */
atacc2 add constraint foo check"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = insert into atacc1 (test) values (2);
-ERROR = !INSERT INTO: UNIQUE constraint 'atacc1.atacc_test1' violated
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:assert:SQLSTATE M0M29 !INSERT INTO: UNIQUE constraint
'atacc1.atacc_test1' violated
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc1 add constraint atacc_oid1 unique(oid);
-ERROR = !CONSTRAINT UNIQUE: no such column 'oid' for table 'atacc1'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42S22 !CONSTRAINT UNIQUE: no such
column 'oid' for table 'atacc1'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc1 add constraint atacc_test1 unique (test);
-ERROR = !UPDATE: UNIQUE constraint 'atacc1.atacc_test1' violated
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:assert:SQLSTATE M0M29 !UPDATE: UNIQUE constraint
'atacc1.atacc_test1' violated
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc1 add constraint atacc_test1 unique (test1);
-ERROR = !CONSTRAINT UNIQUE: no such column 'test1' for table 'atacc1'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42S22 !CONSTRAINT UNIQUE: no such
column 'test1' for table 'atacc1'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = insert into atacc1 (test,test2) values (4,4);
-ERROR = !INSERT INTO: UNIQUE constraint 'atacc1.atacc_test1' violated
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:assert:SQLSTATE M0M29 !INSERT INTO: UNIQUE constraint
'atacc1.atacc_test1' violated
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = insert into atacc1 (test2, test) values (2, 3);
-ERROR = !INSERT INTO: UNIQUE constraint 'atacc1.atacc1_test_unique' violated
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:assert:SQLSTATE M0M29 !INSERT INTO: UNIQUE constraint
'atacc1.atacc1_test_unique' violated
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = insert into atacc1 (test) values (2);
-ERROR = !INSERT INTO: PRIMARY KEY constraint 'atacc1.atacc_test1' violated
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:assert:SQLSTATE M0M29 !INSERT INTO: PRIMARY KEY
constraint 'atacc1.atacc_test1' violated
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = insert into atacc1 (test) values(NULL);
-ERROR = !INSERT INTO: NOT NULL constraint violated for column atacc1.test
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
-QUERY = alter table atacc1 add constraint atacc_oid1 primary key(oid);
-ERROR = !CONSTRAINT PRIMARY KEY: no such column 'oid' for table 'atacc1'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:assert:SQLSTATE M0M29 !INSERT INTO: NOT NULL constraint
violated for column atacc1.test
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc1 add constraint atacc_oid1 primary key(oid);
-ERROR = !CONSTRAINT PRIMARY KEY: no such column 'oid' for table 'atacc1'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42S22 !CONSTRAINT PRIMARY KEY: no
such column 'oid' for table 'atacc1'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
+QUERY = alter table atacc1 add constraint atacc_oid1 primary key(oid);
+ERROR = !ParseException:SQLparser:SQLSTATE 42S22 !CONSTRAINT PRIMARY KEY: no
such column 'oid' for table 'atacc1'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc1 add constraint atacc_test1 primary key (test);
-ERROR = !UPDATE: PRIMARY KEY constraint 'atacc1.atacc_test1' violated
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:assert:SQLSTATE M0M29 !UPDATE: PRIMARY KEY constraint
'atacc1.atacc_test1' violated
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc1 add constraint atacc_test1 primary key (test);
-ERROR = !ALTER TABLE: NOT NULL constraint violated for column atacc1.test
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:sql.alter_table:SQLSTATE 40002 !ALTER TABLE: NOT NULL
constraint violated for column atacc1.test
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc1 add constraint atacc_test1 primary key (test1);
-ERROR = !CONSTRAINT PRIMARY KEY: no such column 'test1' for table 'atacc1'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42S22 !CONSTRAINT PRIMARY KEY: no
such column 'test1' for table 'atacc1'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc1 add constraint atacc_test2 primary key (test);
-ERROR = !CONSTRAINT PRIMARY KEY: a table can have only one PRIMARY KEY
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:sql.alter_table:SQLSTATE 40000 !CONSTRAINT PRIMARY KEY:
a table can have only one PRIMARY KEY
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = insert into atacc1 (test,test2) values (4,4);
-ERROR = !INSERT INTO: PRIMARY KEY constraint 'atacc1.atacc_test1' violated
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:assert:SQLSTATE M0M29 !INSERT INTO: PRIMARY KEY
constraint 'atacc1.atacc_test1' violated
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = insert into atacc1 (test,test2) values (NULL,3);
-ERROR = !INSERT INTO: NOT NULL constraint violated for column atacc1.test
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:assert:SQLSTATE M0M29 !INSERT INTO: NOT NULL constraint
violated for column atacc1.test
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = insert into atacc1 (test,test2) values (3, NULL);
-ERROR = !INSERT INTO: NOT NULL constraint violated for column atacc1.test2
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:assert:SQLSTATE M0M29 !INSERT INTO: NOT NULL constraint
violated for column atacc1.test2
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = insert into atacc1 (test,test2) values (NULL,NULL);
-ERROR = !INSERT INTO: NOT NULL constraint violated for column atacc1.test
-MAPI = (monetdb) /var/tmp/mtest-8483/.s.monetdb.32551
+ERROR = !SQLException:assert:SQLSTATE M0M29 !INSERT INTO: NOT NULL constraint
violated for column atacc1.test
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = insert into atacc1 (test2, test) values (2, 3);
-ERROR = !INSERT INTO: PRIMARY KEY constraint 'atacc1.atacc1_test_pkey' violated
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:assert:SQLSTATE M0M29 !INSERT INTO: PRIMARY KEY
constraint 'atacc1.atacc1_test_pkey' violated
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = insert into atacc1 (test2, test) values (1, NULL);
-ERROR = !INSERT INTO: NOT NULL constraint violated for column atacc1.test
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !SQLException:assert:SQLSTATE M0M29 !INSERT INTO: NOT NULL constraint
violated for column atacc1.test
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table pg_class alter column relname drop not null;
-ERROR = !syntax error, unexpected NOT, expecting DEFAULT in: "alter table
pg_class alter column relname drop not null"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
NOT, expecting DEFAULT in: "alter table pg_class alter column relname drop not
null"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table pg_class alter relname set not null;
-ERROR = !ALTER TABLE: no such table 'pg_class' in schema 'sys'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42S02 !ALTER TABLE: no such table
'pg_class' in schema 'sys'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table non_existent alter column bar set not null;
-ERROR = !ALTER TABLE: no such table 'non_existent' in schema 'sys'
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42S02 !ALTER TABLE: no such table
'non_existent' in schema 'sys'
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table non_existent alter column bar drop not null;
-ERROR = !syntax error, unexpected NOT, expecting DEFAULT in: "alter table
non_existent alter column bar drop not null"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
NOT, expecting DEFAULT in: "alter table non_existent alter column bar drop not
null"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc1 alter column test drop not null;
-ERROR = !syntax error, unexpected NOT, expecting DEFAULT in: "alter table
atacc1 alter column test drop not null"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
NOT, expecting DEFAULT in: "alter table atacc1 alter column test drop not null"
+MAPI = (monetdb) /var/tmp/mtest-26073/.s.monetdb.33079
QUERY = alter table atacc1 alter column test drop not null;
-ERROR = !syntax error, unexpected NOT, expecting DEFAULT in: "alter table
atacc1 alter column test drop not null"
-MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
+ERROR = !ParseException:SQLparser:SQLSTATE 42000 !syntax error, unexpected
NOT, expecting DEFAULT in: "alter table atacc1 alter column test drop not null"
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
