Changeset: 99de15fa3b2e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/99de15fa3b2e
Modified Files:
sql/test/emptydb/Tests/check.stable.out
Branch: Aug2024
Log Message:
Approve foreign key check test.
diffs (truncated from 551 to 300 lines):
diff --git a/sql/test/emptydb/Tests/check.stable.out
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -208,6 +208,7 @@ select 'missing reference in querylog_ca
select 'missing reference in querylog_history id', id, * from
sys.querylog_history where (id) not in (select id from sys.querylog_catalog);
select 'missing reference in querylog_history owner', owner, * from
sys.querylog_history where (owner) not in (select name from sys.users);
select 'missing reference in querylog_history pipe', pipe, * from
sys.querylog_history where (pipe) not in (select name from sys.optimizers);
+select 'missing reference in remote_user_info table_id', table_id, * from
sys.remote_user_info where (table_id) not in (select id from sys._tables);
select 'missing reference in sessions username', "username", * from
sys.sessions where ("username") not in (select name from sys.users);
select 'missing reference in sessions optimizer', optimizer, * from
sys.sessions where (optimizer) not in (select name from sys.optimizers);
select 'missing reference in statistics column_id', column_id, * from
sys.statistics where (column_id) not in (select id from (SELECT id FROM
sys._columns UNION ALL SELECT id FROM tmp._columns) as c);
@@ -6113,6 +6114,10 @@ select 'null in fkeys.delete_action', de
% %5, pipe, id, owner, defined, query, pipe, plan, mal,
optimize, start, stop, arguments, tuples, run, ship, cpu,
io # name
% varchar, varchar, oid, varchar, timestamp,
varchar, varchar, varchar, int, bigint, timestamp,
timestamp, varchar, bigint, bigint, bigint, int, int # type
% 0, 0, 3, 0, 26, 0, 0, 0, 1, 1,
26, 26, 0, 1, 1, 1, 1, 1 # length
+% .%4, sys.remote_user_info, sys.remote_user_info, sys.remote_user_info,
sys.remote_user_info # table_name
+% %4, table_id, table_id, username, password # name
+% varchar, int, int, varchar, varchar # type
+% 0, 1, 1, 0, 0 # length
% .%5, .sessions, .sessions, .sessions, .sessions,
.sessions, .sessions, .sessions, .sessions, .sessions,
.sessions, .sessions, .sessions, .sessions, .sessions,
.sessions, .sessions, .sessions # table_name
% %5, username, sessionid, username, login, idle,
optimizer, sessiontimeout, querytimeout, workerlimit, memorylimit,
language, peer, hostname, application, client, clientpid,
remark # name
% varchar, varchar, int, varchar, timestamp,
timestamp, varchar, int, int, int, int, varchar,
varchar, varchar, varchar, varchar, bigint, varchar
# type
@@ -6281,131 +6286,131 @@ select 'null in fkeys.delete_action', de
% %10, delete_action_id, id, table_id, type, name, rkey,
update_action_id, update_action, delete_action_id, delete_action #
name
% varchar, smallint, int, int, int, varchar, int,
smallint, varchar, smallint, varchar # type
% 0, 1, 1, 1, 1, 0, 1, 1, 0, 1,
0 # length
-% .%1, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns # table_name
+% .%1, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns # table_name
% %1, id, id, name, type, type_digits, type_scale,
table_id, default, null, number, storage # name
% varchar, int, int, varchar, varchar, int, int,
int, varchar, boolean, int, varchar # type
% 0, 1, 1, 0, 0, 1, 1, 1, 0, 5,
1, 0 # length
-% .%1, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns # table_name
+% .%1, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns # table_name
% %1, name, id, name, type, type_digits, type_scale,
table_id, default, null, number, storage # name
% varchar, varchar, int, varchar, varchar, int,
int, int, varchar, boolean, int, varchar # type
% 0, 0, 1, 0, 0, 1, 1, 1, 0, 5,
1, 0 # length
-% .%1, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns # table_name
+% .%1, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns # table_name
% %1, type, id, name, type, type_digits, type_scale,
table_id, default, null, number, storage # name
% varchar, varchar, int, varchar, varchar, int,
int, int, varchar, boolean, int, varchar # type
% 0, 0, 1, 0, 0, 1, 1, 1, 0, 5,
1, 0 # length
-% .%1, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns # table_name
+% .%1, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns # table_name
% %1, type_digits, id, name, type, type_digits, type_scale,
table_id, default, null, number, storage # name
% varchar, int, int, varchar, varchar, int, int,
int, varchar, boolean, int, varchar # type
% 0, 1, 1, 0, 0, 1, 1, 1, 0, 5,
1, 0 # length
-% .%1, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns # table_name
+% .%1, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns # table_name
% %1, type_scale, id, name, type, type_digits, type_scale,
table_id, default, null, number, storage # name
% varchar, int, int, varchar, varchar, int, int,
int, varchar, boolean, int, varchar # type
% 0, 1, 1, 0, 0, 1, 1, 1, 0, 5,
1, 0 # length
-% .%1, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns # table_name
+% .%1, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns # table_name
% %1, table_id, id, name, type, type_digits, type_scale,
table_id, default, null, number, storage # name
% varchar, int, int, varchar, varchar, int, int,
int, varchar, boolean, int, varchar # type
% 0, 1, 1, 0, 0, 1, 1, 1, 0, 5,
1, 0 # length
-% .%1, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns # table_name
+% .%1, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns # table_name
% %1, null, id, name, type, type_digits, type_scale,
table_id, default, null, number, storage # name
% varchar, boolean, int, varchar, varchar, int,
int, int, varchar, boolean, int, varchar # type
% 0, 5, 1, 0, 0, 1, 1, 1, 0, 5,
1, 0 # length
-% .%1, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns # table_name
+% .%1, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns, ._columns, ._columns, ._columns,
._columns, ._columns # table_name
% %1, number, id, name, type, type_digits, type_scale,
table_id, default, null, number, storage # name
% varchar, int, int, varchar, varchar, int, int,
int, varchar, boolean, int, varchar # type
% 0, 1, 1, 0, 0, 1, 1, 1, 0, 5,
1, 0 # length
-% .%1, sys._tables, sys._tables, sys._tables, sys._tables,
sys._tables, sys._tables, sys._tables, sys._tables, sys._tables #
table_name
+% .%1, ._tables, ._tables, ._tables, ._tables,
._tables, ._tables, ._tables, ._tables, ._tables #
table_name
% %1, id, id, name, schema_id, query, type, system,
commit_action, access # name
% varchar, int, int, varchar, int, varchar,
smallint, boolean, smallint, smallint # type
% 0, 1, 1, 0, 1, 0, 1, 5, 1, 1 #
length
-% .%1, sys._tables, sys._tables, sys._tables, sys._tables,
sys._tables, sys._tables, sys._tables, sys._tables, sys._tables #
table_name
+% .%1, ._tables, ._tables, ._tables, ._tables,
._tables, ._tables, ._tables, ._tables, ._tables #
table_name
% %1, name, id, name, schema_id, query, type, system,
commit_action, access # name
% varchar, varchar, int, varchar, int, varchar,
smallint, boolean, smallint, smallint # type
% 0, 0, 1, 0, 1, 0, 1, 5, 1, 1 #
length
-% .%1, sys._tables, sys._tables, sys._tables, sys._tables,
sys._tables, sys._tables, sys._tables, sys._tables, sys._tables #
table_name
+% .%1, ._tables, ._tables, ._tables, ._tables,
._tables, ._tables, ._tables, ._tables, ._tables #
table_name
% %1, schema_id, id, name, schema_id, query, type, system,
commit_action, access # name
% varchar, int, int, varchar, int, varchar,
smallint, boolean, smallint, smallint # type
% 0, 1, 1, 0, 1, 0, 1, 5, 1, 1 #
length
-% .%1, sys._tables, sys._tables, sys._tables, sys._tables,
sys._tables, sys._tables, sys._tables, sys._tables, sys._tables #
table_name
+% .%1, ._tables, ._tables, ._tables, ._tables,
._tables, ._tables, ._tables, ._tables, ._tables #
table_name
% %1, type, id, name, schema_id, query, type, system,
commit_action, access # name
% varchar, smallint, int, varchar, int, varchar,
smallint, boolean, smallint, smallint # type
% 0, 1, 1, 0, 1, 0, 1, 5, 1, 1 #
length
-% .%1, sys._tables, sys._tables, sys._tables, sys._tables,
sys._tables, sys._tables, sys._tables, sys._tables, sys._tables #
table_name
+% .%1, ._tables, ._tables, ._tables, ._tables,
._tables, ._tables, ._tables, ._tables, ._tables #
table_name
% %1, system, id, name, schema_id, query, type, system,
commit_action, access # name
% varchar, boolean, int, varchar, int, varchar,
smallint, boolean, smallint, smallint # type
% 0, 5, 1, 0, 1, 0, 1, 5, 1, 1 #
length
-% .%1, sys._tables, sys._tables, sys._tables, sys._tables,
sys._tables, sys._tables, sys._tables, sys._tables, sys._tables #
table_name
+% .%1, ._tables, ._tables, ._tables, ._tables,
._tables, ._tables, ._tables, ._tables, ._tables #
table_name
% %1, commit_action, id, name, schema_id, query, type, system,
commit_action, access # name
% varchar, smallint, int, varchar, int, varchar,
smallint, boolean, smallint, smallint # type
% 0, 1, 1, 0, 1, 0, 1, 5, 1, 1 #
length
-% .%1, sys._tables, sys._tables, sys._tables, sys._tables,
sys._tables, sys._tables, sys._tables, sys._tables, sys._tables #
table_name
+% .%1, ._tables, ._tables, ._tables, ._tables,
._tables, ._tables, ._tables, ._tables, ._tables #
table_name
% %1, access, id, name, schema_id, query, type, system,
commit_action, access # name
% varchar, smallint, int, varchar, int, varchar,
smallint, boolean, smallint, smallint # type
% 0, 1, 1, 0, 1, 0, 1, 5, 1, 1 #
length
-% .%1, sys.args, sys.args, sys.args, sys.args,
sys.args, sys.args, sys.args, sys.args, sys.args #
table_name
+% .%1, .args, .args, .args, .args, .args, .args, .args, .args, .args #
table_name
% %1, id, id, func_id, name, type, type_digits,
type_scale, inout, number # name
% varchar, int, int, int, varchar, varchar, int,
int, tinyint, int # type
% 0, 1, 1, 1, 0, 0, 1, 1, 1, 1 #
length
-% .%1, sys.args, sys.args, sys.args, sys.args,
sys.args, sys.args, sys.args, sys.args, sys.args #
table_name
+% .%1, .args, .args, .args, .args, .args, .args, .args, .args, .args #
table_name
% %1, func_id, id, func_id, name, type, type_digits,
type_scale, inout, number # name
% varchar, int, int, int, varchar, varchar, int,
int, tinyint, int # type
% 0, 1, 1, 1, 0, 0, 1, 1, 1, 1 #
length
-% .%1, sys.args, sys.args, sys.args, sys.args,
sys.args, sys.args, sys.args, sys.args, sys.args #
table_name
+% .%1, .args, .args, .args, .args, .args, .args, .args, .args, .args #
table_name
% %1, name, id, func_id, name, type, type_digits,
type_scale, inout, number # name
% varchar, varchar, int, int, varchar, varchar,
int, int, tinyint, int # type
% 0, 0, 1, 1, 0, 0, 1, 1, 1, 1 #
length
-% .%1, sys.args, sys.args, sys.args, sys.args,
sys.args, sys.args, sys.args, sys.args, sys.args #
table_name
+% .%1, .args, .args, .args, .args, .args, .args, .args, .args, .args #
table_name
% %1, type, id, func_id, name, type, type_digits,
type_scale, inout, number # name
% varchar, varchar, int, int, varchar, varchar,
int, int, tinyint, int # type
% 0, 0, 1, 1, 0, 0, 1, 1, 1, 1 #
length
-% .%1, sys.args, sys.args, sys.args, sys.args,
sys.args, sys.args, sys.args, sys.args, sys.args #
table_name
+% .%1, .args, .args, .args, .args, .args, .args, .args, .args, .args #
table_name
% %1, type_digits, id, func_id, name, type, type_digits,
type_scale, inout, number # name
% varchar, int, int, int, varchar, varchar, int,
int, tinyint, int # type
% 0, 1, 1, 1, 0, 0, 1, 1, 1, 1 #
length
-% .%1, sys.args, sys.args, sys.args, sys.args,
sys.args, sys.args, sys.args, sys.args, sys.args #
table_name
+% .%1, .args, .args, .args, .args, .args, .args, .args, .args, .args #
table_name
% %1, type_scale, id, func_id, name, type, type_digits,
type_scale, inout, number # name
% varchar, int, int, int, varchar, varchar, int,
int, tinyint, int # type
% 0, 1, 1, 1, 0, 0, 1, 1, 1, 1 #
length
-% .%1, sys.args, sys.args, sys.args, sys.args,
sys.args, sys.args, sys.args, sys.args, sys.args #
table_name
+% .%1, .args, .args, .args, .args, .args, .args, .args, .args, .args #
table_name
% %1, inout, id, func_id, name, type, type_digits,
type_scale, inout, number # name
% varchar, tinyint, int, int, varchar, varchar,
int, int, tinyint, int # type
% 0, 1, 1, 1, 0, 0, 1, 1, 1, 1 #
length
-% .%1, sys.args, sys.args, sys.args, sys.args,
sys.args, sys.args, sys.args, sys.args, sys.args #
table_name
+% .%1, .args, .args, .args, .args, .args, .args, .args, .args, .args #
table_name
% %1, number, id, func_id, name, type, type_digits,
type_scale, inout, number # name
% varchar, int, int, int, varchar, varchar, int,
int, tinyint, int # type
% 0, 1, 1, 1, 0, 0, 1, 1, 1, 1 #
length
-% .%1, sys.auths, sys.auths, sys.auths, sys.auths # table_name
+% .%1, .auths, .auths, .auths, .auths # table_name
% %1, id, id, name, grantor # name
% varchar, int, int, varchar, int # type
% 0, 1, 1, 0, 1 # length
-% .%1, sys.auths, sys.auths, sys.auths, sys.auths # table_name
+% .%1, .auths, .auths, .auths, .auths # table_name
% %1, name, id, name, grantor # name
% varchar, varchar, int, varchar, int # type
% 0, 0, 1, 0, 1 # length
-% .%1, sys.auths, sys.auths, sys.auths, sys.auths # table_name
+% .%1, .auths, .auths, .auths, .auths # table_name
% %1, grantor, id, name, grantor # name
% varchar, int, int, varchar, int # type
% 0, 1, 1, 0, 1 # length
-% .%1, sys.db_user_info, sys.db_user_info, sys.db_user_info,
sys.db_user_info, sys.db_user_info, sys.db_user_info,
sys.db_user_info, sys.db_user_info, sys.db_user_info,
sys.db_user_info # table_name
+% .%1, .db_user_info, .db_user_info, .db_user_info, .db_user_info,
.db_user_info, .db_user_info, .db_user_info, .db_user_info, .db_user_info,
.db_user_info # table_name
% %1, name, name, fullname, default_schema, schema_path,
max_memory, max_workers, optimizer, default_role, password # name
% varchar, varchar, varchar, varchar, int,
varchar, bigint, int, varchar, int, varchar # type
% 0, 0, 0, 0, 1, 0, 1, 1, 0, 1,
0 # length
-% .%1, sys.db_user_info, sys.db_user_info, sys.db_user_info,
sys.db_user_info, sys.db_user_info, sys.db_user_info,
sys.db_user_info, sys.db_user_info, sys.db_user_info,
sys.db_user_info # table_name
+% .%1, .db_user_info, .db_user_info, .db_user_info, .db_user_info,
.db_user_info, .db_user_info, .db_user_info, .db_user_info, .db_user_info,
.db_user_info # table_name
% %1, fullname, name, fullname, default_schema, schema_path,
max_memory, max_workers, optimizer, default_role, password # name
% varchar, varchar, varchar, varchar, int,
varchar, bigint, int, varchar, int, varchar # type
% 0, 0, 0, 0, 1, 0, 1, 1, 0, 1,
0 # length
-% .%1, sys.db_user_info, sys.db_user_info, sys.db_user_info,
sys.db_user_info, sys.db_user_info, sys.db_user_info,
sys.db_user_info, sys.db_user_info, sys.db_user_info,
sys.db_user_info # table_name
+% .%1, .db_user_info, .db_user_info, .db_user_info, .db_user_info,
.db_user_info, .db_user_info, .db_user_info, .db_user_info, .db_user_info,
.db_user_info # table_name
% %1, default_schema, name, fullname, default_schema, schema_path,
max_memory, max_workers, optimizer, default_role, password # name
% varchar, int, varchar, varchar, int, varchar,
bigint, int, varchar, int, varchar # type
% 0, 1, 0, 0, 1, 0, 1, 1, 0, 1,
0 # length
-% .%1, sys.dependencies, sys.dependencies, sys.dependencies,
sys.dependencies # table_name
+% .%1, .dependencies, .dependencies, .dependencies, .dependencies #
table_name
% %1, id, id, depend_id, depend_type # name
% varchar, int, int, int, smallint # type
% 0, 1, 1, 1, 1 # length
-% .%1, sys.dependencies, sys.dependencies, sys.dependencies,
sys.dependencies # table_name
+% .%1, .dependencies, .dependencies, .dependencies, .dependencies #
table_name
% %1, depend_id, id, depend_id, depend_type # name
% varchar, int, int, int, smallint # type
% 0, 1, 1, 1, 1 # length
-% .%1, sys.dependencies, sys.dependencies, sys.dependencies,
sys.dependencies # table_name
+% .%1, .dependencies, .dependencies, .dependencies, .dependencies #
table_name
% %1, depend_type, id, depend_id, depend_type # name
% varchar, smallint, int, int, smallint # type
% 0, 1, 1, 1, 1 # length
@@ -6429,63 +6434,63 @@ select 'null in fkeys.delete_action', de
% %1, function_type_keyword, function_type_id, function_type_name,
function_type_keyword # name
% varchar, varchar, smallint, varchar, varchar # type
% 0, 0, 1, 0, 0 # length
-% .%1, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions # table_name
+% .%1, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions # table_name
% %1, id, id, name, func, mod, language, type,
side_effect, varres, vararg, schema_id, system, semantics # name
% varchar, int, int, varchar, varchar, varchar,
int, int, boolean, boolean, boolean, int,
boolean, boolean # type
% 0, 1, 1, 0, 0, 0, 1, 1, 5, 5,
5, 1, 5, 5 # length
-% .%1, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions # table_name
+% .%1, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions # table_name
% %1, name, id, name, func, mod, language, type,
side_effect, varres, vararg, schema_id, system, semantics # name
% varchar, varchar, int, varchar, varchar,
varchar, int, int, boolean, boolean, boolean,
int, boolean, boolean # type
% 0, 0, 1, 0, 0, 0, 1, 1, 5, 5,
5, 1, 5, 5 # length
-% .%1, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions # table_name
+% .%1, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions # table_name
% %1, func, id, name, func, mod, language, type,
side_effect, varres, vararg, schema_id, system, semantics # name
% varchar, varchar, int, varchar, varchar,
varchar, int, int, boolean, boolean, boolean,
int, boolean, boolean # type
% 0, 0, 1, 0, 0, 0, 1, 1, 5, 5,
5, 1, 5, 5 # length
-% .%1, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions # table_name
+% .%1, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions # table_name
% %1, mod, id, name, func, mod, language, type,
side_effect, varres, vararg, schema_id, system, semantics # name
% varchar, varchar, int, varchar, varchar,
varchar, int, int, boolean, boolean, boolean,
int, boolean, boolean # type
% 0, 0, 1, 0, 0, 0, 1, 1, 5, 5,
5, 1, 5, 5 # length
-% .%1, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions # table_name
+% .%1, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions # table_name
% %1, language, id, name, func, mod, language, type,
side_effect, varres, vararg, schema_id, system, semantics # name
% varchar, int, int, varchar, varchar, varchar,
int, int, boolean, boolean, boolean, int,
boolean, boolean # type
% 0, 1, 1, 0, 0, 0, 1, 1, 5, 5,
5, 1, 5, 5 # length
-% .%1, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions # table_name
+% .%1, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions # table_name
% %1, type, id, name, func, mod, language, type,
side_effect, varres, vararg, schema_id, system, semantics # name
% varchar, int, int, varchar, varchar, varchar,
int, int, boolean, boolean, boolean, int,
boolean, boolean # type
% 0, 1, 1, 0, 0, 0, 1, 1, 5, 5,
5, 1, 5, 5 # length
-% .%1, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions # table_name
+% .%1, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions # table_name
% %1, side_effect, id, name, func, mod, language, type,
side_effect, varres, vararg, schema_id, system, semantics # name
% varchar, boolean, int, varchar, varchar,
varchar, int, int, boolean, boolean, boolean,
int, boolean, boolean # type
% 0, 5, 1, 0, 0, 0, 1, 1, 5, 5,
5, 1, 5, 5 # length
-% .%1, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions # table_name
+% .%1, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions # table_name
% %1, varres, id, name, func, mod, language, type,
side_effect, varres, vararg, schema_id, system, semantics # name
% varchar, boolean, int, varchar, varchar,
varchar, int, int, boolean, boolean, boolean,
int, boolean, boolean # type
% 0, 5, 1, 0, 0, 0, 1, 1, 5, 5,
5, 1, 5, 5 # length
-% .%1, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions # table_name
+% .%1, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions # table_name
% %1, vararg, id, name, func, mod, language, type,
side_effect, varres, vararg, schema_id, system, semantics # name
% varchar, boolean, int, varchar, varchar,
varchar, int, int, boolean, boolean, boolean,
int, boolean, boolean # type
% 0, 5, 1, 0, 0, 0, 1, 1, 5, 5,
5, 1, 5, 5 # length
-% .%1, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions # table_name
+% .%1, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions # table_name
% %1, schema_id, id, name, func, mod, language, type,
side_effect, varres, vararg, schema_id, system, semantics # name
% varchar, int, int, varchar, varchar, varchar,
int, int, boolean, boolean, boolean, int,
boolean, boolean # type
% 0, 1, 1, 0, 0, 0, 1, 1, 5, 5,
5, 1, 5, 5 # length
-% .%1, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions, sys.functions,
sys.functions, sys.functions, sys.functions, sys.functions # table_name
+% .%1, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions, .functions,
.functions, .functions, .functions, .functions # table_name
% %1, system, id, name, func, mod, language, type,
side_effect, varres, vararg, schema_id, system, semantics # name
% varchar, boolean, int, varchar, varchar,
varchar, int, int, boolean, boolean, boolean,
int, boolean, boolean # type
% 0, 5, 1, 0, 0, 0, 1, 1, 5, 5,
5, 1, 5, 5 # length
-% .%1, sys.idxs, sys.idxs, sys.idxs, sys.idxs,
sys.idxs # table_name
+% .%1, .idxs, .idxs, .idxs, .idxs, .idxs # table_name
% %1, id, id, table_id, type, name # name
% varchar, int, int, int, int, varchar # type
% 0, 1, 1, 1, 1, 0 # length
-% .%1, sys.idxs, sys.idxs, sys.idxs, sys.idxs,
sys.idxs # table_name
+% .%1, .idxs, .idxs, .idxs, .idxs, .idxs # table_name
% %1, table_id, id, table_id, type, name # name
% varchar, int, int, int, int, varchar # type
% 0, 1, 1, 1, 1, 0 # length
-% .%1, sys.idxs, sys.idxs, sys.idxs, sys.idxs,
sys.idxs # table_name
+% .%1, .idxs, .idxs, .idxs, .idxs, .idxs # table_name
% %1, type, id, table_id, type, name # name
% varchar, int, int, int, int, varchar # type
% 0, 1, 1, 1, 1, 0 # length
-% .%1, sys.idxs, sys.idxs, sys.idxs, sys.idxs,
sys.idxs # table_name
+% .%1, .idxs, .idxs, .idxs, .idxs, .idxs # table_name
% %1, name, id, table_id, type, name # name
% varchar, varchar, int, int, int, varchar # type
% 0, 0, 1, 1, 1, 0 # length
@@ -6505,27 +6510,27 @@ select 'null in fkeys.delete_action', de
% %1, key_type_name, key_type_id, key_type_name # name
% varchar, varchar, smallint, varchar # type
% 0, 0, 1, 0 # length
-% .%1, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys, sys.keys, sys.keys, sys.keys # table_name
+% .%1, .keys, .keys, .keys, .keys, .keys, .keys, .keys, .keys #
table_name
% %1, id, id, table_id, type, name, rkey, action, check #
name
% varchar, int, int, int, int, varchar, int, int,
varchar # type
% 0, 1, 1, 1, 1, 0, 1, 1, 0 # length
-% .%1, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys, sys.keys, sys.keys, sys.keys # table_name
+% .%1, .keys, .keys, .keys, .keys, .keys, .keys, .keys, .keys #
table_name
% %1, table_id, id, table_id, type, name, rkey, action,
check # name
% varchar, int, int, int, int, varchar, int, int,
varchar # type
% 0, 1, 1, 1, 1, 0, 1, 1, 0 # length
-% .%1, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys, sys.keys, sys.keys, sys.keys # table_name
+% .%1, .keys, .keys, .keys, .keys, .keys, .keys, .keys, .keys #
table_name
% %1, type, id, table_id, type, name, rkey, action, check #
name
% varchar, int, int, int, int, varchar, int, int,
varchar # type
% 0, 1, 1, 1, 1, 0, 1, 1, 0 # length
-% .%1, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys, sys.keys, sys.keys, sys.keys # table_name
+% .%1, .keys, .keys, .keys, .keys, .keys, .keys, .keys, .keys #
table_name
% %1, name, id, table_id, type, name, rkey, action, check #
name
% varchar, varchar, int, int, int, varchar, int,
int, varchar # type
% 0, 0, 1, 1, 1, 0, 1, 1, 0 # length
-% .%1, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys, sys.keys, sys.keys, sys.keys # table_name
+% .%1, .keys, .keys, .keys, .keys, .keys, .keys, .keys, .keys #
table_name
% %1, rkey, id, table_id, type, name, rkey, action, check #
name
% varchar, int, int, int, int, varchar, int, int,
varchar # type
% 0, 1, 1, 1, 1, 0, 1, 1, 0 # length
-% .%1, sys.keys, sys.keys, sys.keys, sys.keys,
sys.keys, sys.keys, sys.keys, sys.keys # table_name
+% .%1, .keys, .keys, .keys, .keys, .keys, .keys, .keys, .keys #
table_name
% %1, action, id, table_id, type, name, rkey, action, check #
name
% varchar, int, int, int, int, varchar, int, int,
varchar # type
% 0, 1, 1, 1, 1, 0, 1, 1, 0 # length
@@ -6533,15 +6538,15 @@ select 'null in fkeys.delete_action', de
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
