Changeset: 65ce118f27bb for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=65ce118f27bb Modified Files: sql/test/pg_regress/Tests/All sql/test/pg_regress/Tests/alter_table.sql sql/test/pg_regress/Tests/alter_table.stable.err sql/test/pg_regress/Tests/alter_table.stable.out sql/test/pg_regress/Tests/arrays.stable.err sql/test/pg_regress/Tests/boolean.stable.err sql/test/pg_regress/Tests/char.stable.err sql/test/pg_regress/Tests/comments.stable.err sql/test/pg_regress/Tests/create_aggregate.stable.err sql/test/pg_regress/Tests/create_misc.stable.out sql/test/pg_regress/Tests/create_operator.stable.err sql/test/pg_regress/Tests/date.stable.err sql/test/pg_regress/Tests/date.stable.out sql/test/pg_regress/Tests/drop.stable.err sql/test/pg_regress/Tests/float4.stable.err sql/test/pg_regress/Tests/float8.stable.err sql/test/pg_regress/Tests/inet.stable.err sql/test/pg_regress/Tests/insert.stable.err sql/test/pg_regress/Tests/int2.stable.err sql/test/pg_regress/Tests/int4.stable.err sql/test/pg_regress/Tests/int8.stable.err sql/test/pg_regress/Tests/interval.stable.err sql/test/pg_regress/Tests/interval.stable.out sql/test/pg_regress/Tests/numeric.stable.err sql/test/pg_regress/Tests/numeric_big.stable.err sql/test/pg_regress/Tests/numerology.stable.err sql/test/pg_regress/Tests/numerology.stable.out sql/test/pg_regress/Tests/oid.stable.err sql/test/pg_regress/Tests/select_into.stable.err sql/test/pg_regress/Tests/strings.stable.err sql/test/pg_regress/Tests/strings_cast.stable.err sql/test/pg_regress/Tests/strings_cast.stable.out sql/test/pg_regress/Tests/strings_concat.stable.err sql/test/pg_regress/Tests/timestamp.stable.err sql/test/pg_regress/Tests/timestamp.stable.out sql/test/pg_regress/Tests/timestamptz.stable.err sql/test/pg_regress/Tests/timestamptz.stable.out sql/test/pg_regress/Tests/timetz.stable.out sql/test/pg_regress/Tests/vacuum.stable.out sql/test/pg_regress/Tests/varchar.stable.err sql/test/pg_regress/Tests/without_oid.stable.err sql/test/pg_regress/Tests/without_oid.stable.out Branch: default Log Message:
Updated All to reflect tests which have been worked on sofar. Also regenerated stable.out and stable.err diffs (truncated from 7123 to 300 lines): diff --git a/sql/test/pg_regress/Tests/All b/sql/test/pg_regress/Tests/All --- a/sql/test/pg_regress/Tests/All +++ b/sql/test/pg_regress/Tests/All @@ -1,4 +1,4 @@ -load +#ToDo load # pgregress set; in order as given by # http://git.postgresql.org/gitweb/?p=postgresql.git;a=blob_plain;f=src/test/regress/serial_schedule;hb=HEAD @@ -27,12 +27,12 @@ float8 numeric strings numerology -HAVE_GEOM?point -HAVE_GEOM?lseg -HAVE_GEOM?box -HAVE_GEOM?path -HAVE_GEOM?polygon -HAVE_GEOM?circle +#ToDo HAVE_GEOM?point +#ToDo HAVE_GEOM?lseg +#ToDo HAVE_GEOM?box +#ToDo HAVE_GEOM?path +#ToDo HAVE_GEOM?polygon +#ToDo HAVE_GEOM?circle date time timetz @@ -44,69 +44,69 @@ reltime # tinterval NOT supported in MonetDB, deprecated in Postgresql and is also not standard SQL so exclude this test inet comments -HAVE_GEOM?geometry -horology -oidjoins -type_sanity -opr_sanity +#ToDo HAVE_GEOM?geometry +#ToDo horology +#ToDo oidjoins +#ToDo type_sanity +#ToDo opr_sanity insert -create_type +#ToDo create_type create_table create_misc create_operator -create_index -create_view +#ToDo create_index +#ToDo create_view create_aggregate -triggers -inherit +#ToDo triggers +#ToDo inherit vacuum -sanity_check -errors -select +#ToDo sanity_check +#ToDo errors +#ToDo select select_into -select_distinct -select_distinct_on -select_implicit -select_having -subselect -union -case -join -aggregates -transactions -random -portals +#ToDo select_distinct +#ToDo select_distinct_on +#ToDo select_implicit +#ToDo select_having +#ToDo subselect +#ToDo union +#ToDo case +#ToDo join +#ToDo aggregates +#ToDo transactions +#ToDo random +#ToDo portals arrays -btree_index -hash_index -update -namespace -privileges -rules -select_views -portals_p2 -foreign_key -cluster -limit -plpgsql -copy2 -temp -domain -rangefuncs -prepare +#ToDo btree_index +#ToDo hash_index +#ToDo update +#ToDo namespace +#ToDo privileges +#ToDo rules +#ToDo select_views +#ToDo portals_p2 +#ToDo foreign_key +#ToDo cluster +#ToDo limit +#ToDo plpgsql +#ToDo copy2 +#ToDo temp +#ToDo domain +#ToDo rangefuncs +#ToDo prepare without_oid -conversion -truncate +#ToDo conversion +#ToDo truncate alter_table -sequence -polymorphism -rowtypes -stats +#ToDo sequence +#ToDo polymorphism +#ToDo rowtypes +#ToDo stats # these four were in a 2005 pgregress set, but are no longer # in the 2014 v9.3.4 pgregress set; not sure when/where they # should be run; keep them for last for now drop -mule_internal +#ToDo mule_internal numeric_big -sql_ascii +#ToDo sql_ascii diff --git a/sql/test/pg_regress/Tests/alter_table.sql b/sql/test/pg_regress/Tests/alter_table.sql --- a/sql/test/pg_regress/Tests/alter_table.sql +++ b/sql/test/pg_regress/Tests/alter_table.sql @@ -945,7 +945,7 @@ drop table p1 cascade; create domain mytype as text; create temp table foo (f1 text, f2 mytype, f3 text); -create temp table foo (f1 text, f2 text, f3 text); +create temp table foo (f1 text, f2 text, f3 text) on commit preserve rows; insert into foo values('aa','bb','cc'); select * from foo; 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,619 +26,613 @@ stderr of test 'alter_table` in director # cmdline opt gdk_debug = 536870922 -MAPI = (monetdb) /var/tmp/mtest-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 QUERY = SELECT * FROM tmp_new; ERROR = !SELECT: no such table 'tmp_new' -MAPI = (monetdb) /var/tmp/mtest-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 QUERY = SELECT * FROM tmp_new; ERROR = !SELECT: no such table 'tmp_new' -MAPI = (monetdb) /var/tmp/mtest-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 QUERY = SELECT * FROM tmp_new2; ERROR = !SELECT: no such table 'tmp_new2' -MAPI = (monetdb) /var/tmp/mtest-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 QUERY = DROP TABLE tmp_new; ERROR = !DROP TABLE: no such table 'tmp_new' -MAPI = (monetdb) /var/tmp/mtest-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 QUERY = DROP TABLE tmp_new2; ERROR = !DROP TABLE: no such table 'tmp_new2' -MAPI = (monetdb) /var/tmp/mtest-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 -QUERY = CREATE VIEW tmp_view (unique1) AS SELECT unique1 FROM tenk1; -ERROR = !SELECT: no such table 'tenk1' -MAPI = (monetdb) /var/tmp/mtest-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 -QUERY = SELECT unique1 FROM tenk1 WHERE unique1 < 5; -ERROR = !SELECT: no such table 'tenk1' -MAPI = (monetdb) /var/tmp/mtest-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 QUERY = DROP VIEW tmp_view_new; ERROR = !DROP VIEW: unknown view 'tmp_view_new' -MAPI = (monetdb) /var/tmp/mtest-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable; ERROR = !ALTER TABLE: not supported on TEMPORARY table 'fktable' -MAPI = (monetdb) /var/tmp/mtest-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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-10941/.s.monetdb.35814 +MAPI = (monetdb) /var/tmp/mtest-6793/.s.monetdb.30280 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" _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
