Changeset: 8f41e6d99b7e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/8f41e6d99b7e
Modified Files:
sql/test/BugTracker-2018/Tests/groupby_having_orderby_count.Bug-6624.test
sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.test
sql/test/bugs/Tests/groupby_having-bug-sf-947600.test
sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.test
sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.test
sql/test/pg_regress/Tests/alter_table.test
sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.test
sql/test/sys-schema/Tests/check_Not_Nullable_columns.test
Branch: check
Log Message:
approve new test output
diffs (277 lines):
diff --git
a/sql/test/BugTracker-2018/Tests/groupby_having_orderby_count.Bug-6624.test
b/sql/test/BugTracker-2018/Tests/groupby_having_orderby_count.Bug-6624.test
--- a/sql/test/BugTracker-2018/Tests/groupby_having_orderby_count.Bug-6624.test
+++ b/sql/test/BugTracker-2018/Tests/groupby_having_orderby_count.Bug-6624.test
@@ -10,7 +10,7 @@ 20
smallint
6
varchar
-14
+15
query TI rowsort
SELECT type,COUNT(id) FROM cols_6624 GROUP BY type HAVING COUNT(id)>5 ORDER BY
2 DESC
@@ -20,7 +20,7 @@ 20
smallint
6
varchar
-14
+15
query TI rowsort
SELECT type,COUNT(id) as cnt FROM cols_6624 GROUP BY type HAVING COUNT(id)>5
ORDER BY cnt DESC
@@ -30,7 +30,7 @@ 20
smallint
6
varchar
-14
+15
statement ok
DROP TABLE cols_6624
diff --git
a/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.test
b/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.test
--- a/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.test
+++ b/sql/test/BugTracker-2019/Tests/alter_table_set_schema.Bug-6701.test
@@ -6,7 +6,7 @@ query ITTIIITIIT rowsort
SELECT * FROM sys._columns WHERE table_id NOT IN (SELECT id FROM sys._tables)
----
-query IIITII rowsort
+query IIITIIT rowsort
SELECT * FROM sys.keys WHERE table_id NOT IN (SELECT id FROM sys.tables)
----
@@ -106,7 +106,7 @@ query ITTIIITIIT rowsort
SELECT * FROM sys._columns WHERE table_id NOT IN (SELECT id FROM sys._tables)
----
-query IIITII rowsort
+query IIITIIT rowsort
SELECT * FROM sys.keys WHERE table_id NOT IN (SELECT id FROM sys.tables)
----
@@ -137,7 +137,7 @@ query ITTIIITIIT rowsort
SELECT * FROM sys._columns WHERE table_id NOT IN (SELECT id FROM sys._tables)
----
-query IIITII rowsort
+query IIITIIT rowsort
SELECT * FROM sys.keys WHERE table_id NOT IN (SELECT id FROM sys.tables)
----
diff --git a/sql/test/bugs/Tests/groupby_having-bug-sf-947600.test
b/sql/test/bugs/Tests/groupby_having-bug-sf-947600.test
--- a/sql/test/bugs/Tests/groupby_having-bug-sf-947600.test
+++ b/sql/test/bugs/Tests/groupby_having-bug-sf-947600.test
@@ -75,7 +75,7 @@ idxs
12
keys
keys
-6
+7
keys
objects
6
diff --git a/sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.test
b/sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.test
--- a/sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.test
+++ b/sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.test
@@ -11,7 +11,7 @@ select schemas.name, tables.name, column
'objects', 'keys', 'modules', 'sequences')
order by schemas.name, tables.name, columns.name
----
-429 values hashing to 6d7dbf36ca46001022af9219632baa04
+435 values hashing to bb81bada51b1bbe50f43e6f3cc184250
query TTT rowsort
select s.name, t.name, c.name from
@@ -26,5 +26,5 @@ select s.name, t.name, c.name from
'objects', 'keys', 'modules', 'sequences')
order by s.name, t.name, c.name
----
-429 values hashing to 6d7dbf36ca46001022af9219632baa04
+435 values hashing to bb81bada51b1bbe50f43e6f3cc184250
diff --git a/sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.test
b/sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.test
--- a/sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.test
+++ b/sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.test
@@ -1,4 +1,4 @@
-query IIITIIITIIITITIIIIIITIII rowsort
+query IIITIITITIIITITIIIIIITIII rowsort
SELECT * FROM "sys"."keys" AS "keys", "sys"."objects" AS
"objects", "sys"."tables" AS "tables",
"sys"."schemas" AS "schemas" WHERE "keys"."id" =
@@ -8,7 +8,7 @@ AND "tables"."schema_id" = "schemas"."id
"tables"."name" LIKE 'x'
----
-query IIITIIITIIITITIIIIIITIII rowsort
+query IIITIITITIIITITIIIIIITIII rowsort
SELECT * FROM "sys"."keys" AS "keys", "sys"."objects" AS
"objects", "sys"."tables" AS "tables",
"sys"."schemas" AS "schemas" WHERE "keys"."id" =
diff --git a/sql/test/pg_regress/Tests/alter_table.test
b/sql/test/pg_regress/Tests/alter_table.test
--- a/sql/test/pg_regress/Tests/alter_table.test
+++ b/sql/test/pg_regress/Tests/alter_table.test
@@ -451,10 +451,10 @@ DROP TABLE PKTABLE cascade
statement ok
create table atacc1 ( test int )
-statement error
+statement ok
alter table atacc1 add constraint atacc_test1 check (test>3)
-statement ok
+statement error
insert into atacc1 (test) values (2)
statement ok
@@ -469,7 +469,7 @@ create table atacc1 ( test int )
statement ok
insert into atacc1 (test) values (2)
-statement error
+statement ok
alter table atacc1 add constraint atacc_test1 check (test>3)
statement ok
@@ -490,10 +490,10 @@ drop table atacc1
statement ok
create table atacc1 ( test int, test2 int, test3 int)
-statement error
+statement ok
alter table atacc1 add constraint atacc_test1 check (test+test2<test3*4)
-statement ok
+statement error
insert into atacc1 (test,test2,test3) values (4,4,2)
statement ok
@@ -502,16 +502,16 @@ insert into atacc1 (test,test2,test3) va
statement ok
drop table atacc1
-statement error
+statement ok
create table atacc1 (test int check (test>3), test2 int)
-statement error
+statement ok
alter table atacc1 add check (test2>test)
statement error
insert into atacc1 (test2, test) values (3, 4)
-statement error
+statement ok
drop table atacc1
statement ok
@@ -523,10 +523,10 @@ create table atacc2 (test2 int)
statement ok
create table atacc3 (test int, test2 int, test3 int)
-statement error
+statement ok
alter table atacc2 add constraint foo check (test2>0)
-statement ok
+statement error
insert into atacc2 (test2) values (-3)
statement ok
@@ -556,10 +556,10 @@ create table atacc2 (test2 int)
statement ok
create table atacc3 (test int, test2 int, test3 int)
-statement error
+statement ok
alter table atacc2 add constraint foo check (test2>0)
-statement ok
+statement error
insert into atacc2 (test2) values (-3)
statement ok
diff --git
a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.test
b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.test
--- a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.test
+++ b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.test
@@ -94,35 +94,35 @@ query ITIITTTI rowsort
SELECT * FROM sys.ids WHERE obj_type IN ('key', 'index') AND id NOT IN (SELECT
id FROM sys.objects)
----
-query IIITII rowsort
+query IIITIIT rowsort
SELECT * FROM sys.keys WHERE id NOT IN (SELECT id FROM sys.objects)
----
-query IIITII rowsort
+query IIITIIT rowsort
SELECT * FROM sys.keys WHERE table_id NOT IN (SELECT id FROM sys.tables)
----
-query IIITII rowsort
+query IIITIIT rowsort
SELECT * FROM sys.keys WHERE table_id NOT IN (SELECT id FROM sys._tables)
----
-query IIITII rowsort
+query IIITIIT rowsort
SELECT * FROM tmp.keys WHERE table_id NOT IN (SELECT id FROM tmp._tables)
----
-query IIITII rowsort
+query IIITIIT rowsort
SELECT * FROM sys.keys WHERE type NOT IN (SELECT key_type_id FROM
sys.key_types)
----
-query IIITII rowsort
+query IIITIIT rowsort
SELECT * FROM tmp.keys WHERE type NOT IN (SELECT key_type_id FROM
sys.key_types)
----
-query IIITII rowsort
+query IIITIIT rowsort
SELECT * FROM sys.keys WHERE rkey <> -1 AND rkey NOT IN (SELECT id FROM
sys.keys)
----
-query IIITII rowsort
+query IIITIIT rowsort
SELECT * FROM tmp.keys WHERE rkey <> -1 AND rkey NOT IN (SELECT id FROM
tmp.keys)
----
diff --git a/sql/test/sys-schema/Tests/check_Not_Nullable_columns.test
b/sql/test/sys-schema/Tests/check_Not_Nullable_columns.test
--- a/sql/test/sys-schema/Tests/check_Not_Nullable_columns.test
+++ b/sql/test/sys-schema/Tests/check_Not_Nullable_columns.test
@@ -298,27 +298,27 @@ query TIIIT rowsort
SELECT "name", * FROM "sys"."idxs" WHERE "name" IS NULL OR "name" = ''
----
-query IIIITII rowsort
+query IIIITIIT rowsort
SELECT "id", * FROM "sys"."keys" WHERE "id" IS NULL
----
-query IIIITII rowsort
+query IIIITIIT rowsort
SELECT "table_id", * FROM "sys"."keys" WHERE "table_id" IS NULL
----
-query IIIITII rowsort
+query IIIITIIT rowsort
SELECT "type", * FROM "sys"."keys" WHERE "type" IS NULL
----
-query TIIITII rowsort
+query TIIITIIT rowsort
SELECT "name", * FROM "sys"."keys" WHERE "name" IS NULL OR "name" = ''
----
-query IIIITII rowsort
+query IIIITIIT rowsort
SELECT "rkey", * FROM "sys"."keys" WHERE "rkey" IS NULL
----
-query IIIITII rowsort
+query IIIITIIT rowsort
SELECT "action", * FROM "sys"."keys" WHERE "action" IS NULL
----
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
