Changeset: 21984a3aa0b2 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=21984a3aa0b2
Modified Files:
sql/test/pg_regress/Tests/alter_table.stable.err
sql/test/pg_regress/Tests/arrays.stable.err
sql/test/pg_regress/Tests/boolean.stable.err
sql/test/pg_regress/Tests/case.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.err
sql/test/pg_regress/Tests/create_operator.stable.err
sql/test/pg_regress/Tests/date.sql
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/horology.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/limit.stable.err
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/oid.stable.err
sql/test/pg_regress/Tests/reltime.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_concat.stable.err
sql/test/pg_regress/Tests/time.sql
sql/test/pg_regress/Tests/time.stable.err
sql/test/pg_regress/Tests/time.stable.out
sql/test/pg_regress/Tests/timestamp.sql
sql/test/pg_regress/Tests/timestamp.stable.err
sql/test/pg_regress/Tests/timestamp.stable.out
sql/test/pg_regress/Tests/timestamptz.sql
sql/test/pg_regress/Tests/timestamptz.stable.err
sql/test/pg_regress/Tests/timestamptz.stable.out
sql/test/pg_regress/Tests/timetz.sql
sql/test/pg_regress/Tests/timetz.stable.err
sql/test/pg_regress/Tests/timetz.stable.out
sql/test/pg_regress/Tests/varchar.stable.err
sql/test/pg_regress/Tests/without_oid.stable.err
Branch: default
Log Message:
Added more scalar function tests to date.sql, time.sql, timetz.sql,
timestamp.sql and timestamptz.sql
Updated stable.out and stable.err after fix for 3640
diffs (truncated from 8701 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,613 +26,613 @@ stderr of test 'alter_table` in director
# cmdline opt gdk_debug = 536870922
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = SELECT * FROM tmp_new;
ERROR = !SELECT: no such table 'tmp_new'
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = SELECT * FROM tmp_new;
ERROR = !SELECT: no such table 'tmp_new'
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = SELECT * FROM tmp_new2;
ERROR = !SELECT: no such table 'tmp_new2'
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = DROP TABLE tmp_new;
ERROR = !DROP TABLE: no such table 'tmp_new'
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = DROP TABLE tmp_new2;
ERROR = !DROP TABLE: no such table 'tmp_new2'
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = DROP VIEW tmp_view_new;
ERROR = !DROP VIEW: unknown view 'tmp_view_new'
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references pktable;
ERROR = !ALTER TABLE: not supported on TEMPORARY table 'fktable'
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = insert into atacc1 (test) values (2);
ERROR = !INSERT INTO: UNIQUE constraint 'atacc1.atacc_test1' violated
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = alter table atacc1 add constraint atacc_test1 unique (test);
ERROR = !UPDATE: UNIQUE constraint 'atacc1.atacc_test1' violated
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = insert into atacc1 (test,test2) values (4,4);
ERROR = !INSERT INTO: UNIQUE constraint 'atacc1.atacc_test1' violated
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = insert into atacc1 (test2, test) values (2, 3);
ERROR = !INSERT INTO: UNIQUE constraint 'atacc1.atacc1_test_unique' violated
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = insert into atacc1 (test) values (2);
ERROR = !INSERT INTO: PRIMARY KEY constraint 'atacc1.atacc_test1' violated
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = insert into atacc1 (test) values(NULL);
ERROR = !INSERT INTO: NOT NULL constraint violated for column atacc1.test
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = insert into atacc1 (test,test2) values (4,4);
ERROR = !INSERT INTO: PRIMARY KEY constraint 'atacc1.atacc_test1' violated
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = insert into atacc1 (test,test2) values (NULL,NULL);
ERROR = !INSERT INTO: NOT NULL constraint violated for column atacc1.test2
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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"
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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"
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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"
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
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"
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = alter table atacc1 alter test set not null;
ERROR = !ALTER TABLE: NOT NULL constraint violated for column atacc1.test
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = alter table atacc1 alter bar set not null;
ERROR = !ALTER TABLE: no such column 'bar'
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = alter table atacc1 alter bar drop not null;
ERROR = !syntax error, unexpected NOT, expecting DEFAULT in: "alter table
atacc1 alter bar drop not"
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = alter table atacc1 alter oid set not null;
ERROR = !ALTER TABLE: no such column 'oid'
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = alter table atacc1 alter oid drop not null;
ERROR = !syntax error, unexpected NOT, expecting DEFAULT in: "alter table
atacc1 alter oid drop not"
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = alter table myview alter column test drop not null;
ERROR = !syntax error, unexpected NOT, expecting DEFAULT in: "alter table
myview alter column test drop not"
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = alter table myview alter column test set not null;
ERROR = !ALTER TABLE: cannot set column options for VIEW 'myview'
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = insert into parent values (NULL);
ERROR = !INSERT INTO: NOT NULL constraint violated for column parent.a
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = alter table parent alter a drop not null;
ERROR = !syntax error, unexpected NOT, expecting DEFAULT in: "alter table
parent alter a drop not"
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = insert into parent values (NULL);
ERROR = !INSERT INTO: NOT NULL constraint violated for column parent.a
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = alter table child alter a set not null;
ERROR = !ALTER TABLE: NOT NULL constraint violated for column child.a
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = insert into parent values (NULL);
ERROR = !INSERT INTO: NOT NULL constraint violated for column parent.a
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = alter table child alter a set not null;
ERROR = !ALTER TABLE: NOT NULL constraint violated for column child.a
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = insert into child (a, b) values (NULL, 'foo');
ERROR = !INSERT INTO: NOT NULL constraint violated for column child.a
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
QUERY = alter table def_test alter column c3 set default 30;
ERROR = !ALTER TABLE: no such column 'c3'
-MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
+MAPI = (monetdb) /var/tmp/mtest-26307/.s.monetdb.38565
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
