Changeset: 9dbd1e297384 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/9dbd1e297384
Modified Files:
sql/backends/monet5/sql.c
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/dump.stable.out
sql/test/testdb-upgrade/Tests/dump.stable.out
Branch: Aug2024
Log Message:
We need to be able to read old databases.
I.e. upgrade from an Aug2024 release database with an "old" CHECK
constraint needs to be possible.
diffs (truncated from 574 to 300 lines):
diff --git a/sql/backends/monet5/sql.c b/sql/backends/monet5/sql.c
--- a/sql/backends/monet5/sql.c
+++ b/sql/backends/monet5/sql.c
@@ -5501,9 +5501,12 @@ SQLcheck(Client cntxt, MalBlkPtr mb, Mal
int pos = 0;
sql_rel *rel = rel_basetable(m, k->t, k->t->base.name);
sql_exp *exp = exp_read(m, rel, NULL, NULL,
sa_strdup(m->sa, k->check), &pos, 0);
- if (!(*r = GDKstrdup(exp->comment)))
+ if (exp->comment)
+ *r = GDKstrdup(exp->comment);
+ else
+ *r = GDKstrdup(exp2sql(m, exp));
+ if (*r == NULL)
throw(SQL, "SQLcheck", SQLSTATE(HY013)
MAL_MALLOC_FAIL);
- // *r = GDKstrdup(exp2sql(m, exp));
return MAL_SUCCEED;
}
}
diff --git a/sql/test/emptydb/Tests/check.stable.out.int128
b/sql/test/emptydb/Tests/check.stable.out.int128
--- a/sql/test/emptydb/Tests/check.stable.out.int128
+++ b/sql/test/emptydb/Tests/check.stable.out.int128
@@ -6424,131 +6424,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
@@ -6572,63 +6572,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
@@ -6648,27 +6648,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
@@ -6676,15 +6676,15 @@ select 'null in fkeys.delete_action', de
% %1, keyword, keyword # name
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
