Changeset: 0f1a44eab4dc for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0f1a44eab4dc
Modified Files:
sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out
Branch: Dec2016
Log Message:
Remove \r.
diffs (truncated from 456 to 300 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
@@ -32,377 +32,377 @@ Ready.
# 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);
+#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);
+#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);
+#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);
+#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);
+#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);
+#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);
+#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);
+#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);
+#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);
+#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);
+#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);
+#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);
+#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);
+#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);
+#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
+#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
+#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);
+#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')));
+#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);
+#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);
+#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);
+#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;
+#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);
+#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);
+#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);
+#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
+#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
+#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);
+#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);
+#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);
+#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
+#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
+#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);
+#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);
+#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);
+#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);
+#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);
+#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);
+#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));
+#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);
+#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);
+#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);
+#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);
+#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
% 1, 1, 1 # length
-#SELECT * FROM sys.dependencies WHERE depend_type = 11 and depend_id NOT IN
(SELECT id FROM sys.keys WHERE type IN (2));
+#SELECT * FROM sys.dependencies WHERE depend_type = 11 and depend_id NOT IN
(SELECT id FROM sys.keys WHERE type IN (2));
% 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 = 13 and depend_id NOT IN
(SELECT id FROM sys.functions);
+#SELECT * FROM sys.dependencies WHERE depend_type = 13 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.auths WHERE grantor NOT IN (SELECT id FROM sys.auths) AND
grantor > 0;
+#SELECT * FROM sys.auths WHERE grantor NOT IN (SELECT id FROM sys.auths) AND
grantor > 0;
% sys.auths, sys.auths, sys.auths # table_name
% id, name, grantor # name
% int, varchar, int # type
% 1, 0, 1 # length
-#SELECT * FROM sys.users WHERE default_schema NOT IN (SELECT id FROM
sys.schemas);
+#SELECT * FROM sys.users WHERE default_schema NOT IN (SELECT id FROM
sys.schemas);
% .users, .users, .users # table_name
% name, fullname, default_schema # name
% varchar, varchar, int # type
% 0, 0, 1 # length
-#SELECT * FROM sys.db_user_info WHERE default_schema NOT IN (SELECT id FROM
sys.schemas);
+#SELECT * FROM sys.db_user_info WHERE default_schema NOT IN (SELECT id FROM
sys.schemas);
% sys.db_user_info, sys.db_user_info, sys.db_user_info # table_name
% name, fullname, default_schema # name
% varchar, varchar, int # type
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
