Changeset: 9aedbae82111 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/9aedbae82111
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: string_imprints
Log Message:
Added upgrade code for strimps functions.
diffs (truncated from 453 to 300 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -4112,6 +4112,17 @@ sql_update_default(Client c, mvc *sql, c
pos += snprintf(buf + pos, bufsize - pos,
"update sys._tables set system = true
where name in ('fkey_actions', 'fkeys') AND schema_id = 2000;\n");
+ /* 90_strimps.sql */
+ pos += snprintf(buf + pos, bufsize - pos,
+ "CREATE FILTER FUNCTION
sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME strimps.strimpfilter;\n"
+ "GRANT EXECUTE ON FILTER FUNCTION
sys.strimp_filter TO PUBLIC;\n"
+ "CREATE PROCEDURE sys.strimp_create(sch
string, tab string, col string)\n"
+ " EXTERNAL NAME sql.createstrimps;\n");
+ pos += snprintf(buf + pos, bufsize - pos,
+ "update sys.functions set system = true
where system <> true and name = 'strimp_filter' and schema_id = 2000 and type =
%d;\n"
+ "update sys.functions set system = true
where system <> true and name = 'strimp_create' and schema_id = 2000 and type =
%d;\n",
+ F_FILT, F_PROC);
+
/* recreate SQL functions that just need to be recompiled since the
* MAL functions's "unsafe" property was changed */
sql_schema *lg = mvc_bind_schema(sql, "logging");
diff --git
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
---
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -5797,6 +5797,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git
a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -5868,6 +5868,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git
a/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -5797,6 +5797,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
@@ -5868,6 +5868,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -669,6 +669,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
@@ -669,6 +669,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
@@ -669,6 +669,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
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
@@ -669,6 +669,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -4895,6 +4895,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
@@ -669,6 +669,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git
a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
@@ -4895,6 +4895,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -669,6 +669,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
@@ -669,6 +669,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
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
@@ -669,6 +669,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
@@ -4895,6 +4895,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git
a/sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -5797,6 +5797,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git
a/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -5868,6 +5868,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git
a/sql/test/testdb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/testdb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -5797,6 +5797,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
