Changeset: 8e75b50c48c1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8e75b50c48c1 Modified Files: sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.test sql/test/sys-schema/Tests/check_Not_Nullable_columns.test Branch: nested Log Message:
approved output diffs (142 lines): 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 @@ -30,27 +30,27 @@ query ITITIIII rowsort SELECT * FROM tmp._tables WHERE type NOT IN (SELECT table_type_id FROM sys.table_types) ---- -query ITTIIITIITI rowsort +query ITTIIITIITII rowsort SELECT * FROM sys.columns WHERE table_id NOT IN (SELECT id FROM sys.tables) ---- -query ITTIIITIITI rowsort +query ITTIIITIITII rowsort SELECT * FROM sys._columns WHERE table_id NOT IN (SELECT id FROM sys._tables) ---- -query ITTIIITIITI rowsort +query ITTIIITIITII rowsort SELECT * FROM tmp._columns WHERE table_id NOT IN (SELECT id FROM tmp._tables) ---- -query ITTIIITIITI rowsort +query ITTIIITIITII rowsort SELECT * FROM sys.columns WHERE type NOT IN (SELECT sqlname FROM sys.types) ---- -query ITTIIITIITI rowsort +query ITTIIITIITII rowsort SELECT * FROM sys._columns WHERE type NOT IN (SELECT sqlname FROM sys.types) ---- -query ITTIIITIITI rowsort +query ITTIIITIITII rowsort SELECT * FROM tmp._columns WHERE type NOT IN (SELECT sqlname FROM sys.types) ---- @@ -70,11 +70,11 @@ query ITTTIIIIIIIII rowsort SELECT * FROM sys.functions WHERE system AND schema_id NOT IN (SELECT id FROM sys.schemas WHERE system) ---- -query IITTIIII rowsort +query IITTIIIII rowsort SELECT * FROM sys.args WHERE func_id NOT IN (SELECT id FROM sys.functions) ---- -query IITTIIII rowsort +query IITTIIIII rowsort SELECT * FROM sys.args WHERE type NOT IN (SELECT sqlname FROM sys.types) ---- 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 @@ -110,35 +110,35 @@ query TIT rowsort SELECT "table_type_name", * FROM "sys"."table_types" WHERE "table_type_name" IS NULL OR "table_type_name" = '' ---- -query IITTIIITIITI rowsort +query IITTIIITIITII rowsort SELECT "id", * FROM "sys"."_columns" WHERE "id" IS NULL ---- -query TITTIIITIITI rowsort +query TITTIIITIITII rowsort SELECT "name", * FROM "sys"."_columns" WHERE "name" IS NULL OR "name" = '' ---- -query TITTIIITIITI rowsort +query TITTIIITIITII rowsort SELECT "type", * FROM "sys"."_columns" WHERE "type" IS NULL OR "type" = '' ---- -query IITTIIITIITI rowsort +query IITTIIITIITII rowsort SELECT "type_digits", * FROM "sys"."_columns" WHERE "type_digits" IS NULL ---- -query IITTIIITIITI rowsort +query IITTIIITIITII rowsort SELECT "type_scale", * FROM "sys"."_columns" WHERE "type_scale" IS NULL ---- -query IITTIIITIITI rowsort +query IITTIIITIITII rowsort SELECT "table_id", * FROM "sys"."_columns" WHERE "table_id" IS NULL ---- -query IITTIIITIITI rowsort +query IITTIIITIITII rowsort SELECT "null", * FROM "sys"."_columns" WHERE "null" IS NULL ---- -query IITTIIITIITI rowsort +query IITTIIITIITII rowsort SELECT "number", * FROM "sys"."_columns" WHERE "number" IS NULL ---- @@ -170,35 +170,35 @@ query IITITIIII rowsort SELECT "access", * FROM "sys"."_tables" WHERE "access" IS NULL ---- -query IIITTIIII rowsort +query IIITTIIIII rowsort SELECT "id", * FROM "sys"."args" WHERE "id" IS NULL ---- -query IIITTIIII rowsort +query IIITTIIIII rowsort SELECT "func_id", * FROM "sys"."args" WHERE "func_id" IS NULL ---- -query TIITTIIII rowsort +query TIITTIIIII rowsort SELECT "name", * FROM "sys"."args" WHERE "name" IS NULL OR "name" = '' ---- -query TIITTIIII rowsort +query TIITTIIIII rowsort SELECT "type", * FROM "sys"."args" WHERE "type" IS NULL OR "type" = '' ---- -query IIITTIIII rowsort +query IIITTIIIII rowsort SELECT "type_digits", * FROM "sys"."args" WHERE "type_digits" IS NULL ---- -query IIITTIIII rowsort +query IIITTIIIII rowsort SELECT "type_scale", * FROM "sys"."args" WHERE "type_scale" IS NULL ---- -query IIITTIIII rowsort +query IIITTIIIII rowsort SELECT "inout", * FROM "sys"."args" WHERE "inout" IS NULL ---- -query IIITTIIII rowsort +query IIITTIIIII rowsort SELECT "number", * FROM "sys"."args" WHERE "number" IS NULL ---- _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
