Changeset: 2efcd378f394 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2efcd378f394
Modified Files:
sql/test/pg_regress/Tests/alter_table.stable.err
sql/test/pg_regress/Tests/insert.stable.err
Branch: default
Log Message:
Approve err output
diffs (96 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
@@ -252,8 +252,8 @@ MAPI = (monetdb) /var/tmp/mtest-22572/.
QUERY = create rule def_view_test_ins as
on insert to def_view_test
do instead insert into def_test select new.*;
-
-MAPI = (monetdb) /var/tmp/mtest-4014/.s.monetdb.32482
+ERROR = !syntax error, unexpected IDENT in: "create rule"
+MAPI = (monetdb) /var/tmp/mtest-20834/.s.monetdb.33894
QUERY = insert into def_view_test default values;
ERROR = !INSERT INTO: cannot insert into view 'def_view_test'
MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
@@ -333,32 +333,32 @@ QUERY = insert into atacc1 values (10, 1
ERROR = !INSERT INTO: number of values doesn't match number of columns of
table 'atacc1'
MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
QUERY = insert into atacc1 values (default, 11, 12, 13);
-
-MAPI = (monetdb) /var/tmp/mtest-4014/.s.monetdb.32482
+ERROR = !INSERT INTO: number of values doesn't match number of columns of
table 'atacc1'
+MAPI = (monetdb) /var/tmp/mtest-20834/.s.monetdb.33894
QUERY = insert into atacc1 (a) values (10);
ERROR = !INSERT INTO: no such column 'atacc1.a'
MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
QUERY = insert into atacc1 (a) values (default);
-
-MAPI = (monetdb) /var/tmp/mtest-4014/.s.monetdb.32482
+ERROR = !INSERT INTO: no such column 'atacc1.a'
+MAPI = (monetdb) /var/tmp/mtest-20834/.s.monetdb.33894
QUERY = insert into atacc1 (a,b,c,d) values (10,11,12,13);
ERROR = !INSERT INTO: no such column 'atacc1.a'
MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
QUERY = insert into atacc1 (a,b,c,d) values (default,11,12,13);
-
-MAPI = (monetdb) /var/tmp/mtest-4014/.s.monetdb.32482
+ERROR = !INSERT INTO: no such column 'atacc1.a'
+MAPI = (monetdb) /var/tmp/mtest-20834/.s.monetdb.33894
QUERY = insert into atacc1 ("........pg.dropped.1........") values (10);
ERROR = !INSERT INTO: no such column 'atacc1.........pg.dropped.1........'
MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
QUERY = insert into atacc1 ("........pg.dropped.1........") values (default);
-
-MAPI = (monetdb) /var/tmp/mtest-4014/.s.monetdb.32482
+ERROR = !INSERT INTO: no such column 'atacc1.........pg.dropped.1........'
+MAPI = (monetdb) /var/tmp/mtest-20834/.s.monetdb.33894
QUERY = insert into atacc1 ("........pg.dropped.1........",b,c,d) values
(10,11,12,13);
ERROR = !INSERT INTO: no such column 'atacc1.........pg.dropped.1........'
MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
QUERY = insert into atacc1 ("........pg.dropped.1........",b,c,d) values
(default,11,12,13);
-
-MAPI = (monetdb) /var/tmp/mtest-4014/.s.monetdb.32482
+ERROR = !INSERT INTO: no such column 'atacc1.........pg.dropped.1........'
+MAPI = (monetdb) /var/tmp/mtest-20834/.s.monetdb.33894
QUERY = delete from atacc1 where a = 3;
ERROR = !SELECT: identifier 'a' unknown
MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
@@ -588,8 +588,8 @@ QUERY = insert into c1 values(11,'xyz',3
ERROR = !INSERT INTO: number of values doesn't match number of columns of
table 'c1'
MAPI = (monetdb) /var/tmp/mtest-22572/.s.monetdb.35667
QUERY = create domain mytype as text;
-
-MAPI = (monetdb) /var/tmp/mtest-4014/.s.monetdb.32482
+ERROR = !syntax error, unexpected IDENT in: "create domain"
+MAPI = (monetdb) /var/tmp/mtest-20834/.s.monetdb.33894
QUERY = create temp table foo (f1 text, f2 mytype, f3 text);
ERROR = !type (mytype) unknown in: "create temp table foo (f1 text, f2 mytype,"
!syntax error, unexpected IDENT in: "f3"
diff --git a/sql/test/pg_regress/Tests/insert.stable.err
b/sql/test/pg_regress/Tests/insert.stable.err
--- a/sql/test/pg_regress/Tests/insert.stable.err
+++ b/sql/test/pg_regress/Tests/insert.stable.err
@@ -31,11 +31,11 @@ stderr of test 'insert` in directory 'sq
MAPI = (monetdb) /var/tmp/mtest-27483/.s.monetdb.35395
QUERY = insert into inserttest (col1, col2, col3) values (DEFAULT, DEFAULT,
DEFAULT);
-
-MAPI = (monetdb) /var/tmp/mtest-4014/.s.monetdb.32482
+ERROR = !INSERT INTO: column 'col1' has no valid default value
+MAPI = (monetdb) /var/tmp/mtest-20834/.s.monetdb.33894
QUERY = insert into inserttest (col1, col2, col3) values (DEFAULT, DEFAULT);
-
-MAPI = (monetdb) /var/tmp/mtest-4014/.s.monetdb.32482
+ERROR = !INSERT INTO: number of values doesn't match number of columns of
table 'inserttest'
+MAPI = (monetdb) /var/tmp/mtest-20834/.s.monetdb.33894
QUERY = insert into inserttest (col1, col2, col3) values (1, 2);
ERROR = !INSERT INTO: number of values doesn't match number of columns of
table 'inserttest'
MAPI = (monetdb) /var/tmp/mtest-27483/.s.monetdb.35395
@@ -43,6 +43,8 @@ QUERY = insert into inserttest (col1) va
ERROR = !INSERT INTO: number of values doesn't match number of columns of
table 'inserttest'
MAPI = (monetdb) /var/tmp/mtest-27483/.s.monetdb.35395
QUERY = insert into inserttest (col1) values (DEFAULT, DEFAULT);
+ERROR = !INSERT INTO: number of values doesn't match number of columns of
table 'inserttest'
+
# 17:11:19 >
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
