Changeset: fb00db546999 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fb00db546999 Modified Files: sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out Branch: mosaic Log Message:
Approve test. diffs (106 lines): diff --git a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out --- a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out +++ b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out @@ -393,62 +393,62 @@ Ready. % .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage # table_name % schema, table, column, type, mode, location, count, typewidth, columnsize, heapsize, hashes, phash, imprints, sorted, revsorted, unique, orderidx, compressed # name % varchar, varchar, varchar, varchar, varchar, varchar, bigint, int, bigint, bigint, bigint, boolean, bigint, boolean, boolean, boolean, bigint, boolean # type -% 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 5, 1, 5, 5, 5, 1 # length +% 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 5, 1, 5, 5, 5, 1, 5 # length #SELECT * FROM sys.storage WHERE table NOT IN (SELECT name FROM sys._tables UNION ALL SELECT name FROM tmp._tables); -% .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage # table_name +% .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage # table_name % schema, table, column, type, mode, location, count, typewidth, columnsize, heapsize, hashes, phash, imprints, sorted, revsorted, unique, orderidx, compressed # name % varchar, varchar, varchar, varchar, varchar, varchar, bigint, int, bigint, bigint, bigint, boolean, bigint, boolean, boolean, boolean, bigint, boolean # type -% 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 5, 1, 5, 5, 5, 1 # length +% 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 5, 1, 5, 5, 5, 1, 5 # length #SELECT * FROM sys.storage WHERE column NOT IN (SELECT name FROM sys._columns UNION ALL SELECT name FROM tmp._columns UNION ALL SELECT name FROM sys.keys UNION ALL SELECT name FROM tmp.keys UNION ALL SELECT name FROM sys.idxs UNION ALL SELECT name FROM tmp.idxs); -% .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage # table_name +% .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage # table_name % schema, table, column, type, mode, location, count, typewidth, columnsize, heapsize, hashes, phash, imprints, sorted, revsorted, unique, orderidx, compressed # name -% varchar, varchar, varchar, varchar, varchar, varchar, bigint, int, bigint, bigint, bigint, boolean, bigint, boolean, boolean, boolean, bigint, boolean # type # type -% 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 5, 1, 5, 5, 5, 1 # length +% varchar, varchar, varchar, varchar, varchar, varchar, bigint, int, bigint, bigint, bigint, boolean, bigint, boolean, boolean, boolean, bigint, boolean # type +% 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 5, 1, 5, 5, 5, 1, 5 # length #SELECT * FROM sys.storage WHERE type NOT IN (SELECT sqlname FROM sys.types); -% .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage # table_name +% .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage, .storage # table_name % schema, table, column, type, mode, location, count, typewidth, columnsize, heapsize, hashes, phash, imprints, sorted, revsorted, unique, orderidx, compressed # name % varchar, varchar, varchar, varchar, varchar, varchar, bigint, int, bigint, bigint, bigint, boolean, bigint, boolean, boolean, boolean, bigint, boolean # type -% 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 5, 1, 5, 5, 5, 1 # length +% 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 5, 1, 5, 5, 5, 1, 5 # length #SELECT * FROM sys.storagemodel WHERE schema NOT IN (SELECT name FROM sys.schemas); -% sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel # table_name -% schema, table, column, type, count, columnsize, heapsize, hashsize, imprintsize, orderidxsize, sorted, revsorted, unique # name -% varchar, varchar, varchar, varchar, bigint, bigint, bigint, bigint, bigint, bigint, boolean, boolean, boolean # type -% 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 5, 5, 5 # length +% sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel # table_name +% schema, table, column, type, count, columnsize, heapsize, hashsize, imprintsize, orderidxsize, sorted, revsorted, unique, compressed # name +% varchar, varchar, varchar, varchar, bigint, bigint, bigint, bigint, bigint, bigint, boolean, boolean, boolean, boolean # type +% 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 5, 5, 5, 5 # length #SELECT * FROM sys.storagemodel WHERE table NOT IN (SELECT name FROM sys._tables UNION ALL SELECT name FROM tmp._tables); -% sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel # table_name -% schema, table, column, type, count, columnsize, heapsize, hashsize, imprintsize, orderidxsize, sorted, revsorted, unique # name -% varchar, varchar, varchar, varchar, bigint, bigint, bigint, bigint, bigint, bigint, boolean, boolean, boolean # type -% 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 5, 5, 5 # length +% sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel # table_name +% schema, table, column, type, count, columnsize, heapsize, hashsize, imprintsize, orderidxsize, sorted, revsorted, unique, compressed # name +% varchar, varchar, varchar, varchar, bigint, bigint, bigint, bigint, bigint, bigint, boolean, boolean, boolean, boolean # type +% 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 5, 5, 5, 5 # length #SELECT * FROM sys.storagemodel WHERE column NOT IN (SELECT name FROM sys._columns UNION ALL SELECT name FROM tmp._columns UNION ALL SELECT name FROM sys.keys UNION ALL SELECT name FROM tmp.keys UNION ALL SELECT name FROM sys.idxs UNION ALL SELECT name FROM tmp.idxs); -% sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel # table_name -% schema, table, column, type, count, columnsize, heapsize, hashsize, imprintsize, orderidxsize, sorted, revsorted, unique # name -% varchar, varchar, varchar, varchar, bigint, bigint, bigint, bigint, bigint, bigint, boolean, boolean, boolean # type -% 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 5, 5, 5 # length +% sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel # table_name +% schema, table, column, type, count, columnsize, heapsize, hashsize, imprintsize, orderidxsize, sorted, revsorted, unique, compressed # name +% varchar, varchar, varchar, varchar, bigint, bigint, bigint, bigint, bigint, bigint, boolean, boolean, boolean, boolean # type +% 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 5, 5, 5, 5 # length #SELECT * FROM sys.storagemodel WHERE type NOT IN (SELECT sqlname FROM sys.types); -% sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel # table_name -% schema, table, column, type, count, columnsize, heapsize, hashsize, imprintsize, orderidxsize, sorted, revsorted, unique # name -% varchar, varchar, varchar, varchar, bigint, bigint, bigint, bigint, bigint, bigint, boolean, boolean, boolean # type -% 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 5, 5, 5 # length +% sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel, sys.storagemodel # table_name +% schema, table, column, type, count, columnsize, heapsize, hashsize, imprintsize, orderidxsize, sorted, revsorted, unique, compressed # name +% varchar, varchar, varchar, varchar, bigint, bigint, bigint, bigint, bigint, bigint, boolean, boolean, boolean, boolean # type +% 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 5, 5, 5, 5 # length #SELECT * FROM sys.storagemodelinput WHERE schema NOT IN (SELECT name FROM sys.schemas); -% sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput # table_name -% schema, table, column, type, typewidth, count, distinct, atomwidth, reference, sorted, revsorted, unique, orderidxsize # name -% varchar, varchar, varchar, varchar, int, bigint, bigint, int, boolean, boolean, boolean, boolean, bigint # type -% 0, 0, 0, 0, 1, 1, 1, 1, 5, 5, 5, 5, 1 # length +% sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput # table_name +% schema, table, column, type, typewidth, count, distinct, atomwidth, reference, sorted, revsorted, unique, orderidx, compressed # name +% varchar, varchar, varchar, varchar, int, bigint, bigint, int, boolean, boolean, boolean, boolean, bigint, boolean # type +% 0, 0, 0, 0, 1, 1, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT * FROM sys.storagemodelinput WHERE table NOT IN (SELECT name FROM sys._tables UNION ALL SELECT name FROM tmp._tables); -% sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput # table_name -% schema, table, column, type, typewidth, count, distinct, atomwidth, reference, sorted, revsorted, unique, orderidxsize # name -% varchar, varchar, varchar, varchar, int, bigint, bigint, int, boolean, boolean, boolean, boolean, bigint # type -% 0, 0, 0, 0, 1, 1, 1, 1, 5, 5, 5, 5, 1 # length +% sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput # table_name +% schema, table, column, type, typewidth, count, distinct, atomwidth, reference, sorted, revsorted, unique, orderidx, compressed # name +% varchar, varchar, varchar, varchar, int, bigint, bigint, int, boolean, boolean, boolean, boolean, bigint, boolean # type +% 0, 0, 0, 0, 1, 1, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT * FROM sys.storagemodelinput WHERE column NOT IN (SELECT name FROM sys._columns UNION ALL SELECT name FROM tmp._columns UNION ALL SELECT name FROM sys.keys UNION ALL SELECT name FROM tmp.keys UNION ALL SELECT name FROM sys.idxs UNION ALL SELECT name FROM tmp.idxs); -% sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput # table_name -% schema, table, column, type, typewidth, count, distinct, atomwidth, reference, sorted, revsorted, unique, orderidxsize # name -% varchar, varchar, varchar, varchar, int, bigint, bigint, int, boolean, boolean, boolean, boolean, bigint # type -% 0, 0, 0, 0, 1, 1, 1, 1, 5, 5, 5, 5, 1 # length +% sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput # table_name +% schema, table, column, type, typewidth, count, distinct, atomwidth, reference, sorted, revsorted, unique, orderidx, compressed # name +% varchar, varchar, varchar, varchar, int, bigint, bigint, int, boolean, boolean, boolean, boolean, bigint, boolean # type +% 0, 0, 0, 0, 1, 1, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT * FROM sys.storagemodelinput WHERE type NOT IN (SELECT sqlname FROM sys.types); -% sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput # table_name -% schema, table, column, type, typewidth, count, distinct, atomwidth, reference, sorted, revsorted, unique, orderidxsize # name -% varchar, varchar, varchar, varchar, int, bigint, bigint, int, boolean, boolean, boolean, boolean, bigint # type -% 0, 0, 0, 0, 1, 1, 1, 1, 5, 5, 5, 5, 1 # length +% sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput, sys.storagemodelinput # table_name +% schema, table, column, type, typewidth, count, distinct, atomwidth, reference, sorted, revsorted, unique, orderidx, compressed # name +% varchar, varchar, varchar, varchar, int, bigint, bigint, int, boolean, boolean, boolean, boolean, bigint, boolean # type +% 0, 0, 0, 0, 1, 1, 1, 1, 5, 5, 5, 5, 1, 5 # length #SELECT schema, table, rowcount, columnsize, heapsize, hashsize, imprintsize, auxiliary FROM sys.tablestoragemodel WHERE schema NOT IN (SELECT name FROM sys.schemas); % sys.tablestoragemodel, sys.tablestoragemodel, sys.tablestoragemodel, sys.tablestoragemodel, sys.tablestoragemodel, sys.tablestoragemodel, sys.tablestoragemodel, sys.tablestoragemodel # table_name % schema, table, rowcount, columnsize, heapsize, hashsize, imprintsize, auxiliary # name _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
