Changeset: fd41f5bee75b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fd41f5bee75b
Modified Files:
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
Branch: default
Log Message:
32 bit upgrade fun.
diffs (270 lines):
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -3616,6 +3616,7 @@ drop procedure sys.shrink(string, string
drop procedure sys.reuse(string, string);
drop procedure sys.vacuum(string, string);
drop procedure sys.flush_log();
+delete from sys.dependencies d where d.depend_id = (select id from
sys.functions where name = 'getproj4' and schema_id = 2000) and id in (select
id from sys._columns where name not in ('proj4text', 'srid'));
drop function json.isobject(string);
drop function json.isarray(string);
drop function json.isvalid(json);
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
@@ -3616,6 +3616,7 @@ drop procedure sys.shrink(string, string
drop procedure sys.reuse(string, string);
drop procedure sys.vacuum(string, string);
drop procedure sys.flush_log();
+delete from sys.dependencies d where d.depend_id = (select id from
sys.functions where name = 'getproj4' and schema_id = 2000) and id in (select
id from sys._columns where name not in ('proj4text', 'srid'));
drop function json.isobject(string);
drop function json.isarray(string);
drop function json.isvalid(json);
diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit
b/sql/test/emptydb/Tests/check.stable.out.32bit
--- a/sql/test/emptydb/Tests/check.stable.out.32bit
+++ b/sql/test/emptydb/Tests/check.stable.out.32bit
@@ -3951,27 +3951,14 @@ drop function pcre_replace(string, strin
% %1, name, name, name, name, name, dependency_type_name # name
% char, varchar, varchar, varchar, varchar,
varchar, varchar # type
% 23, 3, 26, 21, 3, 37, 9 # length
-[ "column used by function", "sys", "columns", "default", "sys",
"_dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "columns", "id", "sys",
"_dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "columns", "name", "sys",
"_dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "columns", "null", "sys",
"_dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "columns", "number", "sys",
"_dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "columns", "storage", "sys",
"_dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "columns", "table_id", "sys",
"_dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "columns", "type", "sys",
"_dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "columns", "type_digits", "sys",
"_dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "columns", "type_scale", "sys",
"_dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "dump_statements", "o", "sys",
"_dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "dump_statements", "s", "sys",
"_dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "access", "sys",
"_dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "commit_action",
"sys", "_dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "tables", "id", "sys",
"_dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "tables", "name", "sys",
"_dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "query", "sys",
"_dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "schema_id", "sys",
"_dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "system", "sys",
"_dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "temporary", "sys",
"_dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "type", "sys",
"_dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "_columns", "default", "sys",
"describe_columns", "FUNCTION" ]
[ "column used by function", "sys", "_columns", "id", "sys",
"describe_columns", "FUNCTION" ]
[ "column used by function", "sys", "_columns", "name", "sys",
"describe_columns", "FUNCTION" ]
@@ -3982,21 +3969,13 @@ drop function pcre_replace(string, strin
[ "column used by function", "sys", "_columns", "type", "sys",
"describe_columns", "FUNCTION" ]
[ "column used by function", "sys", "_columns", "type_digits", "sys",
"describe_columns", "FUNCTION" ]
[ "column used by function", "sys", "_columns", "type_scale", "sys",
"describe_columns", "FUNCTION" ]
-[ "column used by function", "sys", "_tables", "access", "sys",
"describe_columns", "FUNCTION" ]
-[ "column used by function", "sys", "_tables", "commit_action",
"sys", "describe_columns", "FUNCTION" ]
[ "column used by function", "sys", "_tables", "id", "sys",
"describe_columns", "FUNCTION" ]
[ "column used by function", "sys", "_tables", "name", "sys",
"describe_columns", "FUNCTION" ]
-[ "column used by function", "sys", "_tables", "query", "sys",
"describe_columns", "FUNCTION" ]
[ "column used by function", "sys", "_tables", "schema_id", "sys",
"describe_columns", "FUNCTION" ]
-[ "column used by function", "sys", "_tables", "system", "sys",
"describe_columns", "FUNCTION" ]
-[ "column used by function", "sys", "_tables", "type", "sys",
"describe_columns", "FUNCTION" ]
[ "column used by function", "sys", "comments", "id", "sys",
"describe_columns", "FUNCTION" ]
[ "column used by function", "sys", "comments", "remark", "sys",
"describe_columns", "FUNCTION" ]
-[ "column used by function", "sys", "schemas", "authorization",
"sys", "describe_columns", "FUNCTION" ]
[ "column used by function", "sys", "schemas", "id", "sys",
"describe_columns", "FUNCTION" ]
[ "column used by function", "sys", "schemas", "name", "sys",
"describe_columns", "FUNCTION" ]
-[ "column used by function", "sys", "schemas", "owner", "sys",
"describe_columns", "FUNCTION" ]
-[ "column used by function", "sys", "schemas", "system", "sys",
"describe_columns", "FUNCTION" ]
[ "column used by function", "sys", "comments", "id", "sys",
"describe_function", "FUNCTION" ]
[ "column used by function", "sys", "comments", "remark", "sys",
"describe_function", "FUNCTION" ]
[ "column used by function", "sys", "function_languages", "language_id",
"sys", "describe_function", "FUNCTION" ]
@@ -4032,21 +4011,11 @@ drop function pcre_replace(string, strin
[ "column used by function", "sys", "_tables", "type", "sys",
"describe_table", "FUNCTION" ]
[ "column used by function", "sys", "comments", "id", "sys",
"describe_table", "FUNCTION" ]
[ "column used by function", "sys", "comments", "remark", "sys",
"describe_table", "FUNCTION" ]
-[ "column used by function", "sys", "schemas", "authorization",
"sys", "describe_table", "FUNCTION" ]
[ "column used by function", "sys", "schemas", "id", "sys",
"describe_table", "FUNCTION" ]
[ "column used by function", "sys", "schemas", "name", "sys",
"describe_table", "FUNCTION" ]
-[ "column used by function", "sys", "schemas", "owner", "sys",
"describe_table", "FUNCTION" ]
-[ "column used by function", "sys", "schemas", "system", "sys",
"describe_table", "FUNCTION" ]
[ "column used by function", "sys", "table_types", "table_type_id",
"sys", "describe_table", "FUNCTION" ]
[ "column used by function", "sys", "table_types", "table_type_name",
"sys", "describe_table", "FUNCTION" ]
-[ "column used by function", "sys", "types", "digits", "sys",
"describe_type", "FUNCTION" ]
-[ "column used by function", "sys", "types", "eclass", "sys",
"describe_type", "FUNCTION" ]
-[ "column used by function", "sys", "types", "id", "sys",
"describe_type", "FUNCTION" ]
-[ "column used by function", "sys", "types", "radix", "sys",
"describe_type", "FUNCTION" ]
-[ "column used by function", "sys", "types", "scale", "sys",
"describe_type", "FUNCTION" ]
-[ "column used by function", "sys", "types", "schema_id", "sys",
"describe_type", "FUNCTION" ]
[ "column used by function", "sys", "types", "sqlname", "sys",
"describe_type", "FUNCTION" ]
-[ "column used by function", "sys", "types", "systemname", "sys",
"describe_type", "FUNCTION" ]
[ "column used by function", "sys", "dump_add_schemas_to_users", "stmt",
"sys", "dump_database", "FUNCTION" ]
[ "column used by function", "sys", "dump_column_defaults", "stmt", "sys",
"dump_database", "FUNCTION" ]
[ "column used by function", "sys", "dump_comments", "stmt", "sys",
"dump_database", "FUNCTION" ]
@@ -4069,78 +4038,36 @@ drop function pcre_replace(string, strin
[ "column used by function", "sys", "dump_tables", "stmt", "sys",
"dump_database", "FUNCTION" ]
[ "column used by function", "sys", "dump_triggers", "stmt", "sys",
"dump_database", "FUNCTION" ]
[ "column used by function", "sys", "dump_user_defined_types", "stmt",
"sys", "dump_database", "FUNCTION" ]
-[ "column used by function", "sys", "schemas", "authorization",
"sys", "dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "schemas", "id", "sys",
"dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "schemas", "name", "sys",
"dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "schemas", "owner", "sys",
"dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "schemas", "system", "sys",
"dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "table_types", "table_type_id",
"sys", "dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "table_types", "table_type_name",
"sys", "dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "access", "sys",
"dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "commit_action",
"sys", "dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "tables", "id", "sys",
"dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "tables", "name", "sys",
"dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "query", "sys",
"dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "tables", "schema_id", "sys",
"dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "tables", "system", "sys",
"dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "temporary", "sys",
"dump_table_data", "PROCEDURE" ]
[ "column used by function", "sys", "tables", "type", "sys",
"dump_table_data", "PROCEDURE" ]
-[ "column used by function", "sys", "columns", "default", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
[ "column used by function", "sys", "columns", "id", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
[ "column used by function", "sys", "columns", "name", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
-[ "column used by function", "sys", "columns", "null", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
-[ "column used by function", "sys", "columns", "number", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
-[ "column used by function", "sys", "columns", "storage", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
-[ "column used by function", "sys", "columns", "table_id", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
-[ "column used by function", "sys", "columns", "type", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
-[ "column used by function", "sys", "columns", "type_digits", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
-[ "column used by function", "sys", "columns", "type_scale", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
[ "column used by function", "sys", "table_partitions", "column_id",
"sys", "get_merge_table_partition_expressions", "FUNCTION" ]
[ "column used by function", "sys", "table_partitions", "expression",
"sys", "get_merge_table_partition_expressions", "FUNCTION" ]
[ "column used by function", "sys", "table_partitions", "id", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
[ "column used by function", "sys", "table_partitions", "table_id",
"sys", "get_merge_table_partition_expressions", "FUNCTION" ]
[ "column used by function", "sys", "table_partitions", "type", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
-[ "column used by function", "sys", "spatial_ref_sys", "auth_name",
"sys", "getproj4", "FUNCTION" ]
-[ "column used by function", "sys", "spatial_ref_sys", "auth_srid",
"sys", "getproj4", "FUNCTION" ]
[ "column used by function", "sys", "spatial_ref_sys", "proj4text",
"sys", "getproj4", "FUNCTION" ]
[ "column used by function", "sys", "spatial_ref_sys", "srid", "sys",
"getproj4", "FUNCTION" ]
-[ "column used by function", "sys", "spatial_ref_sys", "srtext",
"sys", "getproj4", "FUNCTION" ]
-[ "column used by function", "sys", "columns", "default", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "columns", "id", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "columns", "name", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "columns", "null", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "columns", "number", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "columns", "storage", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "columns", "table_id", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "columns", "type", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "columns", "type_digits", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "columns", "type_scale", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "keys", "action", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "keys", "id", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "keys", "name", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "keys", "rkey", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "keys", "table_id", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "keys", "type", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "objects", "id", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "objects", "name", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "objects", "nr", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "objects", "sub", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "schemas", "authorization",
"sys", "storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "schemas", "id", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "schemas", "name", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "schemas", "owner", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "schemas", "system", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "storage", "column", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "storage", "columnsize", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "storage", "count", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "storage", "hashes", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "storage", "heapsize", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "storage", "imprints", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "storage", "location", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "storage", "mode", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "storage", "orderidx", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "storage", "phash", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "storage", "revsorted", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "storage", "schema", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "storage", "sorted", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "storage", "table", "sys",
"storagemodelinit", "PROCEDURE" ]
@@ -4159,15 +4086,9 @@ drop function pcre_replace(string, strin
[ "column used by function", "sys", "storagemodelinput", "type", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "storagemodelinput", "typewidth",
"sys", "storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "storagemodelinput", "unique",
"sys", "storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "access", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "commit_action",
"sys", "storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "tables", "id", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "tables", "name", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "query", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "tables", "schema_id", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "system", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "temporary", "sys",
"storagemodelinit", "PROCEDURE" ]
-[ "column used by function", "sys", "tables", "type", "sys",
"storagemodelinit", "PROCEDURE" ]
% .%1, sys.s1, sys.f1, sys.s2, sys.t2, .dt # table_name
% %1, name, name, name, name, dependency_type_name # name
% char, varchar, varchar, varchar, varchar,
varchar # type
@@ -4771,33 +4692,21 @@ drop function pcre_replace(string, strin
[ "column used by view", "sys", "objects", "nr", "sys",
"describe_indices", "VIEW" ]
[ "column used by view", "sys", "schemas", "id", "sys",
"describe_indices", "VIEW" ]
[ "column used by view", "sys", "schemas", "name", "sys",
"describe_indices", "VIEW" ]
-[ "column used by view", "sys", "_tables", "access", "sys",
"describe_partition_tables", "VIEW" ]
-[ "column used by view", "sys", "_tables", "commit_action",
"sys", "describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "_tables", "id", "sys",
"describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "_tables", "name", "sys",
"describe_partition_tables", "VIEW" ]
-[ "column used by view", "sys", "_tables", "query", "sys",
"describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "_tables", "schema_id", "sys",
"describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "_tables", "system", "sys",
"describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "_tables", "type", "sys",
"describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "dependencies", "depend_id", "sys",
"describe_partition_tables", "VIEW" ]
-[ "column used by view", "sys", "dependencies", "depend_type", "sys",
"describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "dependencies", "id", "sys",
"describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "range_partitions", "maximum",
"sys", "describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "range_partitions", "minimum",
"sys", "describe_partition_tables", "VIEW" ]
-[ "column used by view", "sys", "range_partitions", "partition_id",
"sys", "describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "range_partitions", "table_id",
"sys", "describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "range_partitions", "with_nulls",
"sys", "describe_partition_tables", "VIEW" ]
-[ "column used by view", "sys", "schemas", "authorization",
"sys", "describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "schemas", "id", "sys",
"describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "schemas", "name", "sys",
"describe_partition_tables", "VIEW" ]
-[ "column used by view", "sys", "schemas", "owner", "sys",
"describe_partition_tables", "VIEW" ]
-[ "column used by view", "sys", "schemas", "system", "sys",
"describe_partition_tables", "VIEW" ]
-[ "column used by view", "sys", "table_partitions", "column_id",
"sys", "describe_partition_tables", "VIEW" ]
-[ "column used by view", "sys", "table_partitions", "expression",
"sys", "describe_partition_tables", "VIEW" ]
-[ "column used by view", "sys", "table_partitions", "id", "sys",
"describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "table_partitions", "table_id",
"sys", "describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "table_partitions", "type", "sys",
"describe_partition_tables", "VIEW" ]
-[ "column used by view", "sys", "value_partitions", "partition_id",
"sys", "describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "value_partitions", "table_id",
"sys", "describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "value_partitions", "value",
"sys", "describe_partition_tables", "VIEW" ]
[ "column used by view", "sys", "auths", "id", "sys",
"describe_privileges", "VIEW" ]
@@ -4836,21 +4745,15 @@ drop function pcre_replace(string, strin
[ "column used by view", "sys", "_columns", "type", "sys",
"describe_tables", "VIEW" ]
[ "column used by view", "sys", "_columns", "type_digits", "sys",
"describe_tables", "VIEW" ]
[ "column used by view", "sys", "_columns", "type_scale", "sys",
"describe_tables", "VIEW" ]
-[ "column used by view", "sys", "schemas", "authorization",
"sys", "describe_tables", "VIEW" ]
[ "column used by view", "sys", "schemas", "id", "sys",
"describe_tables", "VIEW" ]
[ "column used by view", "sys", "schemas", "name", "sys",
"describe_tables", "VIEW" ]
-[ "column used by view", "sys", "schemas", "owner", "sys",
"describe_tables", "VIEW" ]
-[ "column used by view", "sys", "schemas", "system", "sys",
"describe_tables", "VIEW" ]
[ "column used by view", "sys", "table_types", "table_type_id",
"sys", "describe_tables", "VIEW" ]
[ "column used by view", "sys", "table_types", "table_type_name",
"sys", "describe_tables", "VIEW" ]
-[ "column used by view", "sys", "tables", "access", "sys",
"describe_tables", "VIEW" ]
-[ "column used by view", "sys", "tables", "commit_action",
"sys", "describe_tables", "VIEW" ]
[ "column used by view", "sys", "tables", "id", "sys",
"describe_tables", "VIEW" ]
[ "column used by view", "sys", "tables", "name", "sys",
"describe_tables", "VIEW" ]
[ "column used by view", "sys", "tables", "query", "sys",
"describe_tables", "VIEW" ]
[ "column used by view", "sys", "tables", "schema_id", "sys",
"describe_tables", "VIEW" ]
[ "column used by view", "sys", "tables", "system", "sys",
"describe_tables", "VIEW" ]
-[ "column used by view", "sys", "tables", "temporary", "sys",
"describe_tables", "VIEW" ]
[ "column used by view", "sys", "tables", "type", "sys",
"describe_tables", "VIEW" ]
[ "column used by view", "sys", "schemas", "id", "sys",
"describe_triggers", "VIEW" ]
[ "column used by view", "sys", "schemas", "name", "sys",
"describe_triggers", "VIEW" ]
diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -3616,6 +3616,7 @@ drop procedure sys.shrink(string, string
drop procedure sys.reuse(string, string);
drop procedure sys.vacuum(string, string);
drop procedure sys.flush_log();
+delete from sys.dependencies d where d.depend_id = (select id from
sys.functions where name = 'getproj4' and schema_id = 2000) and id in (select
id from sys._columns where name not in ('proj4text', 'srid'));
drop function json.isobject(string);
drop function json.isarray(string);
drop function json.isvalid(json);
diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
--- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
+++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
@@ -3616,6 +3616,7 @@ drop procedure sys.shrink(string, string
drop procedure sys.reuse(string, string);
drop procedure sys.vacuum(string, string);
drop procedure sys.flush_log();
+delete from sys.dependencies d where d.depend_id = (select id from
sys.functions where name = 'getproj4' and schema_id = 2000) and id in (select
id from sys._columns where name not in ('proj4text', 'srid'));
drop function json.isobject(string);
drop function json.isarray(string);
drop function json.isvalid(json);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
