Changeset: 2ef2c9472336 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2ef2c9472336 Removed Files: sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out.int128 Modified Files: sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out Branch: Dec2016 Log Message:
Adjusted FK query on tablestoragemodel to not return hugeint output and therefor remove the need for a .stable.out.int128 version. diffs (truncated from 461 to 300 lines): diff --git a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql --- a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql +++ b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql @@ -118,6 +118,6 @@ SELECT * FROM sys.storagemodelinput WHER SELECT * FROM sys.storagemodelinput WHERE column NOT IN (SELECT name FROM sys._columns UNION ALL SELECT name FROM sys.keys); SELECT * FROM sys.storagemodelinput WHERE type NOT IN (SELECT sqlname FROM sys.types); -SELECT * FROM sys.tablestoragemodel WHERE schema NOT IN (SELECT name FROM sys.schemas); -SELECT * FROM sys.tablestoragemodel WHERE table NOT IN (SELECT name FROM sys._tables); +SELECT schema, table, count, columnsize, heapsize, hashes, imprints, cast(auxiliary as bigint) as auxiliary FROM sys.tablestoragemodel WHERE schema NOT IN (SELECT name FROM sys.schemas); +SELECT schema, table, count, columnsize, heapsize, hashes, imprints, cast(auxiliary as bigint) as auxiliary FROM sys.tablestoragemodel WHERE table NOT IN (SELECT name FROM sys._tables); 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 @@ -312,7 +312,7 @@ Ready. % id, owner, defined, query, pipe, plan, mal, optimize, start, stop, arguments, tuples, run, ship, cpu, io # name % oid, clob, timestamp, clob, clob, clob, int, bigint, timestamp, timestamp, clob, bigint, bigint, bigint, int, int # type % 3, 0, 26, 0, 0, 0, 1, 1, 26, 26, 0, 1, 1, 1, 1, 1 # length -#SELECT * FROM sys.queue WHERE tag NOT IN (SELECT qtag FROM sys.queue); +#SELECT * FROM sys.queue WHERE tag > 0 AND tag NOT IN (SELECT qtag FROM sys.queue); % .queue, .queue, .queue, .queue, .queue, .queue, .queue, .queue # table_name % qtag, user, started, estimate, progress, status, tag, query # name % bigint, clob, timestamp, timestamp, int, clob, oid, clob # type @@ -397,13 +397,13 @@ Ready. % schema, table, column, type, typewidth, count, distinct, atomwidth, reference, sorted, revsorted, unique, orderidx # name % clob, clob, clob, clob, int, bigint, bigint, int, boolean, boolean, boolean, boolean, bigint # type % 0, 0, 0, 0, 1, 1, 1, 1, 5, 5, 5, 5, 1 # length -#SELECT * FROM sys.tablestoragemodel WHERE schema NOT IN (SELECT name FROM sys.schemas); -% .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel # table_name +#SELECT schema, table, count, columnsize, heapsize, hashes, imprints, cast(auxiliary as bigint) as auxiliary FROM sys.tablestoragemodel WHERE schema NOT IN (SELECT name FROM sys.schemas); +% .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .L52 # table_name % schema, table, count, columnsize, heapsize, hashes, imprints, auxiliary # name % clob, clob, bigint, bigint, bigint, bigint, bigint, bigint # type % 0, 0, 1, 1, 1, 1, 1, 1 # length -#SELECT * FROM sys.tablestoragemodel WHERE table NOT IN (SELECT name FROM sys._tables); -% .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel # table_name +#SELECT schema, table, count, columnsize, heapsize, hashes, imprints, cast(auxiliary as bigint) as auxiliary FROM sys.tablestoragemodel WHERE table NOT IN (SELECT name FROM sys._tables); +% .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .tablestoragemodel, .L52 # table_name % schema, table, count, columnsize, heapsize, hashes, imprints, auxiliary # name % clob, clob, bigint, bigint, bigint, bigint, bigint, bigint # type % 0, 0, 1, 1, 1, 1, 1, 1 # length diff --git a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out.int128 b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out.int128 deleted file mode 100644 --- a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out.int128 +++ /dev/null @@ -1,414 +0,0 @@ -stdout of test 'check_ForeignKey_referential_integrity` in directory 'sql/test/sys-schema` itself: - - -# 16:15:38 > -# 16:15:38 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34676" "--set" "mapi_usock=/var/tmp/mtest-32669/.s.monetdb.34676" "--set" "monet_prompt=" "--forcemito" "--dbpath=/export/scratch2/dinther/INSTALL/var/MonetDB/mTests_sql_test_sys-schema" -# 16:15:38 > - -# MonetDB 5 server v11.25.4 -# This is an unreleased version -# Serving database 'mTests_sql_test_sys-schema', using 8 threads -# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers -# Found 15.589 GiB available main-memory. -# Copyright (c) 1993-July 2008 CWI. -# Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved -# Visit http://www.monetdb.org/ for further information -# Listening for connection requests on mapi:monetdb://toulouse.da.cwi.nl:34676/ -# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-32669/.s.monetdb.34676 -# MonetDB/GIS module loaded -# MonetDB/SQL module loaded - -Ready. -#WARNING To speedup user.columnsize a bulk operator implementation is needed -# X_61:bat[:lng] := mal.multiplex("user":str,"columnsize":str,X_46:bat[:str],X_53:bat[:lng],X_60:bat[:lng]); -#WARNING To speedup user.heapsize a bulk operator implementation is needed -# X_71:bat[:lng] := mal.multiplex("user":str,"heapsize":str,X_46:bat[:str],X_60:bat[:lng],X_70:bat[:int]); -#WARNING To speedup user.hashsize a bulk operator implementation is needed -# X_80:bat[:lng] := mal.multiplex("user":str,"hashsize":str,X_79:bat[:bit],X_53:bat[:lng]); -#WARNING To speedup user.imprintsize a bulk operator implementation is needed -# X_82:bat[:lng] := mal.multiplex("user":str,"imprintsize":str,X_53:bat[:lng],X_46:bat[:str]); - -# 16:15:38 > -# 16:15:38 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-32669" "--port=34676" -# 16:15:38 > - -#SELECT * FROM sys.schemas WHERE authorization NOT IN (SELECT id FROM sys.auths); -% sys.schemas, sys.schemas, sys.schemas, sys.schemas, sys.schemas # table_name -% id, name, authorization, owner, system # name -% int, varchar, int, int, boolean # type -% 1, 0, 1, 1, 5 # length -#SELECT * FROM sys.schemas WHERE owner NOT IN (SELECT id FROM sys.auths); -% sys.schemas, sys.schemas, sys.schemas, sys.schemas, sys.schemas # table_name -% id, name, authorization, owner, system # name -% int, varchar, int, int, boolean # type -% 1, 0, 1, 1, 5 # length -#SELECT * FROM sys.tables WHERE schema_id NOT IN (SELECT id FROM sys.schemas); -% .tables, .tables, .tables, .tables, .tables, .tables, .tables, .tables, .tables # table_name -% id, name, schema_id, query, type, system, commit_action, access, temporary # name -% int, varchar, int, varchar, smallint, boolean, smallint, smallint, tinyint # type -% 1, 0, 1, 0, 1, 5, 1, 1, 1 # length -#SELECT * FROM sys._tables WHERE schema_id NOT IN (SELECT id FROM sys.schemas); -% sys._tables, sys._tables, sys._tables, sys._tables, sys._tables, sys._tables, sys._tables, sys._tables # table_name -% id, name, schema_id, query, type, system, commit_action, access # name -% int, varchar, int, varchar, smallint, boolean, smallint, smallint # type -% 1, 0, 1, 0, 1, 5, 1, 1 # length -#SELECT * FROM tmp._tables WHERE schema_id NOT IN (SELECT id FROM sys.schemas); -% tmp._tables, tmp._tables, tmp._tables, tmp._tables, tmp._tables, tmp._tables, tmp._tables, tmp._tables # table_name -% id, name, schema_id, query, type, system, commit_action, access # name -% int, varchar, int, varchar, smallint, boolean, smallint, smallint # type -% 1, 0, 1, 0, 1, 5, 1, 1 # length -#SELECT * FROM sys.tables WHERE type NOT IN (SELECT table_type_id FROM sys.table_types); -% .tables, .tables, .tables, .tables, .tables, .tables, .tables, .tables, .tables # table_name -% id, name, schema_id, query, type, system, commit_action, access, temporary # name -% int, varchar, int, varchar, smallint, boolean, smallint, smallint, tinyint # type -% 1, 0, 1, 0, 1, 5, 1, 1, 1 # length -#SELECT * FROM sys._tables WHERE type NOT IN (SELECT table_type_id FROM sys.table_types); -% sys._tables, sys._tables, sys._tables, sys._tables, sys._tables, sys._tables, sys._tables, sys._tables # table_name -% id, name, schema_id, query, type, system, commit_action, access # name -% int, varchar, int, varchar, smallint, boolean, smallint, smallint # type -% 1, 0, 1, 0, 1, 5, 1, 1 # length -#SELECT * FROM tmp._tables WHERE type NOT IN (SELECT table_type_id FROM sys.table_types); -% tmp._tables, tmp._tables, tmp._tables, tmp._tables, tmp._tables, tmp._tables, tmp._tables, tmp._tables # table_name -% id, name, schema_id, query, type, system, commit_action, access # name -% int, varchar, int, varchar, smallint, boolean, smallint, smallint # type -% 1, 0, 1, 0, 1, 5, 1, 1 # length -#SELECT * FROM sys.columns WHERE table_id NOT IN (SELECT id FROM sys.tables); -% .columns, .columns, .columns, .columns, .columns, .columns, .columns, .columns, .columns, .columns # table_name -% id, name, type, type_digits, type_scale, table_id, default, null, number, storage # name -% int, varchar, varchar, int, int, int, varchar, boolean, int, varchar # type -% 1, 0, 0, 1, 1, 1, 0, 5, 1, 0 # length -#SELECT * FROM sys._columns WHERE table_id NOT IN (SELECT id FROM sys._tables); -% sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns # table_name -% id, name, type, type_digits, type_scale, table_id, default, null, number, storage # name -% int, varchar, varchar, int, int, int, varchar, boolean, int, varchar # type -% 1, 0, 0, 1, 1, 1, 0, 5, 1, 0 # length -#SELECT * FROM tmp._columns WHERE table_id NOT IN (SELECT id FROM tmp._tables); -% tmp._columns, tmp._columns, tmp._columns, tmp._columns, tmp._columns, tmp._columns, tmp._columns, tmp._columns, tmp._columns, tmp._columns # table_name -% id, name, type, type_digits, type_scale, table_id, default, null, number, storage # name -% int, varchar, varchar, int, int, int, varchar, boolean, int, varchar # type -% 1, 0, 0, 1, 1, 1, 0, 5, 1, 0 # length -#SELECT * FROM sys.columns WHERE type NOT IN (SELECT sqlname FROM sys.types); -% .columns, .columns, .columns, .columns, .columns, .columns, .columns, .columns, .columns, .columns # table_name -% id, name, type, type_digits, type_scale, table_id, default, null, number, storage # name -% int, varchar, varchar, int, int, int, varchar, boolean, int, varchar # type -% 1, 0, 0, 1, 1, 1, 0, 5, 1, 0 # length -#SELECT * FROM sys._columns WHERE type NOT IN (SELECT sqlname FROM sys.types); -% sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns # table_name -% id, name, type, type_digits, type_scale, table_id, default, null, number, storage # name -% int, varchar, varchar, int, int, int, varchar, boolean, int, varchar # type -% 1, 0, 0, 1, 1, 1, 0, 5, 1, 0 # length -#SELECT * FROM sys._columns WHERE type NOT IN (SELECT sqlname FROM sys.types); -% sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns, sys._columns # table_name -% id, name, type, type_digits, type_scale, table_id, default, null, number, storage # name -% int, varchar, varchar, int, int, int, varchar, boolean, int, varchar # type -% 1, 0, 0, 1, 1, 1, 0, 5, 1, 0 # length -#SELECT * FROM sys.functions WHERE schema_id NOT IN (SELECT id FROM sys.schemas); -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% id, name, func, mod, language, type, side_effect, varres, vararg, schema_id # name -% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int # type -% 1, 0, 0, 0, 1, 1, 5, 5, 5, 1 # length -#SELECT * FROM sys.functions WHERE type NOT IN (1,2,3,4,5,6,7); -- replace this check when table sys.function_types becomes available -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% id, name, func, mod, language, type, side_effect, varres, vararg, schema_id # name -% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int # type -% 1, 0, 0, 0, 1, 1, 5, 5, 5, 1 # length -#SELECT * FROM sys.functions WHERE language NOT IN (0,1,2,3,4,5,6,7); -- replace this check when table sys.function_languages becomes available -% sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions, sys.functions # table_name -% id, name, func, mod, language, type, side_effect, varres, vararg, schema_id # name -% int, varchar, varchar, varchar, int, int, boolean, boolean, boolean, int # type -% 1, 0, 0, 0, 1, 1, 5, 5, 5, 1 # length -#SELECT * FROM sys.systemfunctions WHERE function_id NOT IN (SELECT id FROM sys.functions); -% sys.systemfunctions # table_name -% function_id # name -% int # type -% 1 # length -#SELECT * FROM sys.systemfunctions WHERE function_id NOT IN (SELECT id FROM sys.functions WHERE schema_id IN (SELECT id FROM sys.schemas WHERE name IN ('sys','json','profiler','bam'))); -% sys.systemfunctions # table_name -% function_id # name -% int # type -% 1 # length -#SELECT * FROM sys.args WHERE func_id NOT IN (SELECT id FROM sys.functions); -% sys.args, sys.args, sys.args, sys.args, sys.args, sys.args, sys.args, sys.args # table_name -% id, func_id, name, type, type_digits, type_scale, inout, number # name -% int, int, varchar, varchar, int, int, tinyint, int # type -% 1, 1, 0, 0, 1, 1, 1, 1 # length -#SELECT * FROM sys.args WHERE type NOT IN (SELECT sqlname FROM sys.types); -% sys.args, sys.args, sys.args, sys.args, sys.args, sys.args, sys.args, sys.args # table_name -% id, func_id, name, type, type_digits, type_scale, inout, number # name -% int, int, varchar, varchar, int, int, tinyint, int # type -% 1, 1, 0, 0, 1, 1, 1, 1 # length -#SELECT * FROM sys.types WHERE schema_id NOT IN (SELECT id FROM sys.schemas); -% sys.types, sys.types, sys.types, sys.types, sys.types, sys.types, sys.types, sys.types # table_name -% id, systemname, sqlname, digits, scale, radix, eclass, schema_id # name -% int, varchar, varchar, int, int, int, int, int # type -% 1, 0, 0, 1, 1, 1, 1, 1 # length -#SELECT * FROM sys.types WHERE schema_id NOT IN (SELECT id FROM sys.schemas) AND schema_id <> 0; -% sys.types, sys.types, sys.types, sys.types, sys.types, sys.types, sys.types, sys.types # table_name -% id, systemname, sqlname, digits, scale, radix, eclass, schema_id # name -% int, varchar, varchar, int, int, int, int, int # type -% 1, 0, 0, 1, 1, 1, 1, 1 # length -#SELECT * FROM sys.keys WHERE table_id NOT IN (SELECT id FROM sys.tables); -% sys.keys, sys.keys, sys.keys, sys.keys, sys.keys, sys.keys # table_name -% id, table_id, type, name, rkey, action # name -% int, int, int, varchar, int, int # type -% 1, 1, 1, 0, 1, 1 # length -#SELECT * FROM sys.keys WHERE table_id NOT IN (SELECT id FROM sys._tables); -% sys.keys, sys.keys, sys.keys, sys.keys, sys.keys, sys.keys # table_name -% id, table_id, type, name, rkey, action # name -% int, int, int, varchar, int, int # type -% 1, 1, 1, 0, 1, 1 # length -#SELECT * FROM tmp.keys WHERE table_id NOT IN (SELECT id FROM tmp._tables); -% tmp.keys, tmp.keys, tmp.keys, tmp.keys, tmp.keys, tmp.keys # table_name -% id, table_id, type, name, rkey, action # name -% int, int, int, varchar, int, int # type -% 1, 1, 1, 0, 1, 1 # length -#SELECT * FROM sys.keys WHERE type NOT IN (0, 1, 2); -- replace this check when table sys.key_types becomes available -% sys.keys, sys.keys, sys.keys, sys.keys, sys.keys, sys.keys # table_name -% id, table_id, type, name, rkey, action # name -% int, int, int, varchar, int, int # type -% 1, 1, 1, 0, 1, 1 # length -#SELECT * FROM tmp.keys WHERE type NOT IN (0, 1, 2); -- replace this check when table sys.key_types becomes available -% tmp.keys, tmp.keys, tmp.keys, tmp.keys, tmp.keys, tmp.keys # table_name -% id, table_id, type, name, rkey, action # name -% int, int, int, varchar, int, int # type -% 1, 1, 1, 0, 1, 1 # length -#SELECT * FROM sys.idxs WHERE table_id NOT IN (SELECT id FROM sys.tables); -% sys.idxs, sys.idxs, sys.idxs, sys.idxs # table_name -% id, table_id, type, name # name -% int, int, int, varchar # type -% 1, 1, 1, 0 # length -#SELECT * FROM sys.idxs WHERE table_id NOT IN (SELECT id FROM sys._tables); -% sys.idxs, sys.idxs, sys.idxs, sys.idxs # table_name -% id, table_id, type, name # name -% int, int, int, varchar # type -% 1, 1, 1, 0 # length -#SELECT * FROM tmp.idxs WHERE table_id NOT IN (SELECT id FROM tmp._tables); -% tmp.idxs, tmp.idxs, tmp.idxs, tmp.idxs # table_name -% id, table_id, type, name # name -% int, int, int, varchar # type -% 1, 1, 1, 0 # length -#SELECT * FROM sys.idxs WHERE type NOT IN (0, 1, 2); -- replace this check when table sys.index_types becomes available -% sys.idxs, sys.idxs, sys.idxs, sys.idxs # table_name -% id, table_id, type, name # name -% int, int, int, varchar # type -% 1, 1, 1, 0 # length -#SELECT * FROM tmp.idxs WHERE type NOT IN (0, 1, 2); -- replace this check when table sys.index_types becomes available -% tmp.idxs, tmp.idxs, tmp.idxs, tmp.idxs # table_name -% id, table_id, type, name # name -% int, int, int, varchar # type -% 1, 1, 1, 0 # length -#SELECT * FROM sys.sequences WHERE schema_id NOT IN (SELECT id FROM sys.schemas); -% sys.sequences, sys.sequences, sys.sequences, sys.sequences, sys.sequences, sys.sequences, sys.sequences, sys.sequences, sys.sequences # table_name -% id, schema_id, name, start, minvalue, maxvalue, increment, cacheinc, cycle # name -% int, int, varchar, bigint, bigint, bigint, bigint, bigint, boolean # type -% 1, 1, 0, 1, 1, 1, 1, 1, 5 # length -#SELECT * FROM sys.triggers WHERE table_id NOT IN (SELECT id FROM sys.tables); -% sys.triggers, sys.triggers, sys.triggers, sys.triggers, sys.triggers, sys.triggers, sys.triggers, sys.triggers, sys.triggers, sys.triggers # table_name -% id, name, table_id, time, orientation, event, old_name, new_name, condition, statement # name -% int, varchar, int, smallint, smallint, smallint, varchar, varchar, varchar, varchar # type -% 1, 0, 1, 1, 1, 1, 0, 0, 0, 0 # length -#SELECT * FROM sys.triggers WHERE table_id NOT IN (SELECT id FROM sys._tables); -% sys.triggers, sys.triggers, sys.triggers, sys.triggers, sys.triggers, sys.triggers, sys.triggers, sys.triggers, sys.triggers, sys.triggers # table_name -% id, name, table_id, time, orientation, event, old_name, new_name, condition, statement # name -% int, varchar, int, smallint, smallint, smallint, varchar, varchar, varchar, varchar # type -% 1, 0, 1, 1, 1, 1, 0, 0, 0, 0 # length -#SELECT * FROM tmp.triggers WHERE table_id NOT IN (SELECT id FROM tmp._tables); -% tmp.triggers, tmp.triggers, tmp.triggers, tmp.triggers, tmp.triggers, tmp.triggers, tmp.triggers, tmp.triggers, tmp.triggers, tmp.triggers # table_name -% id, name, table_id, time, orientation, event, old_name, new_name, condition, statement # name -% int, varchar, int, smallint, smallint, smallint, varchar, varchar, varchar, varchar # type -% 1, 0, 1, 1, 1, 1, 0, 0, 0, 0 # length -#SELECT * FROM sys.dependencies WHERE depend_type NOT IN (SELECT dependency_type_id FROM sys.dependency_types); -% sys.dependencies, sys.dependencies, sys.dependencies # table_name -% id, depend_id, depend_type # name -% int, int, smallint # type -% 1, 1, 1 # length -#SELECT * FROM sys.dependencies WHERE depend_type = 4 and id NOT IN (SELECT id FROM sys.columns); -% sys.dependencies, sys.dependencies, sys.dependencies # table_name -% id, depend_id, depend_type # name -% int, int, smallint # type -% 1, 1, 1 # length -#SELECT * FROM sys.dependencies WHERE depend_type = 4 and depend_id NOT IN (SELECT id FROM sys.keys WHERE type IN (0,1)); -% sys.dependencies, sys.dependencies, sys.dependencies # table_name -% id, depend_id, depend_type # name -% int, int, smallint # type -% 1, 1, 1 # length -#SELECT * FROM sys.dependencies WHERE depend_type = 5 and depend_id NOT IN (SELECT id FROM sys.tables); -% sys.dependencies, sys.dependencies, sys.dependencies # table_name -% id, depend_id, depend_type # name -% int, int, smallint # type -% 1, 1, 1 # length -#SELECT * FROM sys.dependencies WHERE depend_type = 7 and depend_id NOT IN (SELECT id FROM sys.functions); -% sys.dependencies, sys.dependencies, sys.dependencies # table_name -% id, depend_id, depend_type # name -% int, int, smallint # type -% 1, 1, 1 # length -#SELECT * FROM sys.dependencies WHERE depend_type = 10 and id NOT IN (SELECT id FROM sys.columns); -% sys.dependencies, sys.dependencies, sys.dependencies # table_name -% id, depend_id, depend_type # name -% int, int, smallint # type -% 1, 1, 1 # length -#SELECT * FROM sys.dependencies WHERE depend_type = 10 and depend_id NOT IN (SELECT id FROM sys.idxs); -% sys.dependencies, sys.dependencies, sys.dependencies # table_name -% id, depend_id, depend_type # name -% int, int, smallint # type _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
