Changeset: 2465353cc327 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2465353cc327
Modified Files:
sql/test/pg_regress/Tests/alter_table.stable.err
sql/test/pg_regress/Tests/alter_table.stable.out
Branch: default
Log Message:
Updated alter_table.stable.*
diffs (truncated from 1245 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
@@ -26,592 +26,689 @@ stderr of test 'alter_table` in director
# cmdline opt gdk_debug = 536870922
-
-# 18:47:58 >
-# 18:47:58 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-9408" "--port=33074"
-# 18:47:58 >
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER TABLE tmp RENAME TO tmp_new;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !syntax error, unexpected RENAME, expecting DROP or SET or ALTER or
ADD in: "alter table tmp rename"
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = SELECT * FROM tmp_new;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !SELECT: no such table 'tmp_new'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER TABLE tmp RENAME TO tmp_new2;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !syntax error, unexpected RENAME, expecting DROP or SET or ALTER or
ADD in: "alter table tmp rename"
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = SELECT * FROM tmp_new;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !SELECT: no such table 'tmp_new'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = SELECT * FROM tmp_new2;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !SELECT: no such table 'tmp_new2'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = DROP TABLE tmp_new;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !DROP TABLE: no such table 'tmp_new'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = DROP TABLE tmp_new2;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !DROP TABLE: no such table 'tmp_new2'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER INDEX onek_unique1 RENAME TO tmp_onek_unique1;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !syntax error, unexpected INDEX, expecting USER or SEQUENCE or TABLE
in: "alter index"
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER INDEX tmp_onek_unique1 RENAME TO onek_unique1;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !syntax error, unexpected INDEX, expecting USER or SEQUENCE or TABLE
in: "alter index"
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = CREATE VIEW tmp_view (unique1) AS SELECT unique1 FROM tenk1;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !SELECT: no such table 'tenk1'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER TABLE tmp_view RENAME TO tmp_view_new;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !syntax error, unexpected RENAME, expecting DROP or SET or ALTER or
ADD in: "alter table tmp_view rename"
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = SELECT unique1 FROM tenk1 WHERE unique1 < 5;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !SELECT: no such table 'tenk1'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = DROP VIEW tmp_view_new;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !DROP VIEW: unknown view 'tmp_view_new'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table stud_emp rename to pg_toast_stud_emp;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !syntax error, unexpected RENAME, expecting DROP or SET or ALTER or
ADD in: "alter table stud_emp rename"
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table pg_toast_stud_emp rename to stud_emp;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+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-20575/.s.monetdb.33011
QUERY = ALTER TABLE tmp3 add constraint tmpconstr foreign key(c) references
tmp2 match full;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !CONSTRAINT FOREIGN KEY: no such column 'c' in table 'tmp3'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER TABLE tmp3 add constraint tmpconstr foreign key(a) references
tmp2(b) match full;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !CONSTRAINT FOREIGN KEY: could not find referenced PRIMARY KEY in
table 'tmp2'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER TABLE tmp3 add constraint tmpconstr foreign key (a) references
tmp2 match full;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !UPDATE: FOREIGN KEY constraint 'tmp3.tmpconstr' violated
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER TABLE tmp5 add constraint tmpconstr foreign key(a) references
tmp4(a) match full;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !Create Key failed, key 'tmpconstr' already exists
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !ALTER TABLE: not supported on TEMPORARY table 'fktable'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable(ptest1);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !ALTER TABLE: not supported on TEMPORARY table 'fktable'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable(ptest1);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !Create Key failed, key 'fktable_ftest1_fkey' already exists
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2) references pktable;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !types int(32,0) and inet(0,0) are not equal for column 'ptest1'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2)
references pktable(ptest1, ptest2);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !types int(32,0) and inet(0,0) are not equal for column 'ptest1'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1, ftest2)
references pktable(ptest2, ptest1);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !CONSTRAINT FOREIGN KEY: could not find referenced PRIMARY KEY in
table 'pktable'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest2, ftest1)
references pktable(ptest1, ptest2);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !types int(32,0) and inet(0,0) are not equal for column 'ptest1'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table atacc1 add constraint atacc_test1 check (test>3);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+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-20575/.s.monetdb.33011
QUERY = alter table atacc1 add constraint atacc_test1 check (test>3);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+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-20575/.s.monetdb.33011
QUERY = alter table atacc1 add constraint atacc_test1 check (test1>3);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+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-20575/.s.monetdb.33011
QUERY = alter table atacc1 add constraint atacc_test1 check
(test+test2<test3*4);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+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-20575/.s.monetdb.33011
QUERY = alter table atacc1 add check (test2>test);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !syntax error, unexpected CHECK, expecting FOREIGN or PRIMARY or
UNIQUE in: "alter table atacc1 add check"
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table atacc2 add constraint foo check (test2>0);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !syntax error, unexpected CHECK, expecting FOREIGN or PRIMARY or
UNIQUE in: "alter table atacc2 add constraint foo check"
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table only atacc2 add constraint foo check (test2>0);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !syntax error, unexpected ONLY in: "alter table only"
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = insert into atacc1 (test) values (2);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !INSERT INTO: UNIQUE constraint 'atacc1.atacc_test1' violated
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table atacc1 add constraint atacc_oid1 unique(oid);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !CONSTRAINT UNIQUE: no such column 'oid' for table 'atacc1'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table atacc1 add constraint atacc_test1 unique (test);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !UPDATE: UNIQUE constraint 'atacc1.atacc_test1' violated
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table atacc1 add constraint atacc_test1 unique (test1);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !CONSTRAINT UNIQUE: no such column 'test1' for table 'atacc1'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = insert into atacc1 (test,test2) values (4,4);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !INSERT INTO: UNIQUE constraint 'atacc1.atacc_test1' violated
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = insert into atacc1 (test2, test) values (2, 3);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !INSERT INTO: UNIQUE constraint 'atacc1.atacc1_test_unique' violated
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = insert into atacc1 (test) values (2);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !INSERT INTO: PRIMARY KEY constraint 'atacc1.atacc_test1' violated
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = insert into atacc1 (test) values(NULL);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !INSERT INTO: NOT NULL constraint violated for column atacc1.test
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table atacc1 add constraint atacc_oid1 primary key(oid);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !CONSTRAINT PRIMARY KEY: no such column 'oid' for table 'atacc1'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table atacc1 add constraint atacc_oid1 primary key(oid);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !CONSTRAINT PRIMARY KEY: no such column 'oid' for table 'atacc1'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table atacc1 add constraint atacc_test1 primary key (test);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !UPDATE: PRIMARY KEY constraint 'atacc1.atacc_test1' violated
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table atacc1 add constraint atacc_test1 primary key (test);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !ALTER TABLE: NOT NULL constraint violated for column atacc1.test
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table atacc1 add constraint atacc_test1 primary key (test1);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !CONSTRAINT PRIMARY KEY: no such column 'test1' for table 'atacc1'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table atacc1 add constraint atacc_test2 primary key (test);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !CONSTRAINT PRIMARY KEY: a table can have only one PRIMARY KEY
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = insert into atacc1 (test,test2) values (4,4);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !INSERT INTO: PRIMARY KEY constraint 'atacc1.atacc_test1' violated
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = insert into atacc1 (test,test2) values (NULL,3);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !INSERT INTO: NOT NULL constraint violated for column atacc1.test
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = insert into atacc1 (test,test2) values (3, NULL);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !INSERT INTO: NOT NULL constraint violated for column atacc1.test2
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = insert into atacc1 (test,test2) values (NULL,NULL);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !INSERT INTO: NOT NULL constraint violated for column atacc1.test2
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = insert into atacc1 (test2, test) values (2, 3);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !INSERT INTO: PRIMARY KEY constraint 'atacc1.atacc1_test_pkey' violated
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = insert into atacc1 (test2, test) values (1, NULL);
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !INSERT INTO: NOT NULL constraint violated for column atacc1.test
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table pg_class alter column relname drop not null;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !syntax error, unexpected NOT, expecting DEFAULT in: "alter table
pg_class alter column relname drop not"
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table pg_class alter relname set not null;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !ALTER TABLE: no such table 'pg_class' in schema 'sys'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table non_existent alter column bar set not null;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
+ERROR = !ALTER TABLE: no such table 'non_existent' in schema 'sys'
+MAPI = (monetdb) /var/tmp/mtest-20575/.s.monetdb.33011
QUERY = alter table non_existent alter column bar drop not null;
-
-MAPI = (monetdb) /var/tmp/mtest-9408/.s.monetdb.33074
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
