MonetDB: Dec2023 - Approve upgrade tests.

[Lucas Pereira via checkin-list]

Changeset: 73ca75617737 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/73ca75617737
Modified Files:
        clients/Tests/MAL-signatures-hge.test
        clients/Tests/MAL-signatures.test
        
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
        sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
        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
        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/Tests/upgrade.stable.out
        sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
        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.int128
        sql/test/emptydb/Tests/check.stable.out
        sql/test/emptydb/Tests/check.stable.out.32bit
        sql/test/emptydb/Tests/check.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
        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
        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.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.int128
Branch: Dec2023
Log Message:

Approve upgrade tests.


diffs (truncated from 628 to 300 lines):

diff --git a/clients/Tests/MAL-signatures-hge.test 
b/clients/Tests/MAL-signatures-hge.test
--- a/clients/Tests/MAL-signatures-hge.test
+++ b/clients/Tests/MAL-signatures-hge.test
@@ -49750,16 +49750,6 @@ SQLpercent_rank;
 return the percentage into the total number of groups for each row
 sql
 persist_unlogged
-unsafe pattern sql.persist_unlogged() (X_0:bat[:str], X_1:bat[:int], 
X_2:bat[:lng]) 
-SQLpersist_unlogged;
-Persist deltas on append only tables in current schema
-sql
-persist_unlogged
-unsafe pattern sql.persist_unlogged(X_0:str) (X_1:bat[:str], X_2:bat[:int], 
X_3:bat[:lng]) 
-SQLpersist_unlogged;
-Persist deltas on append only tables in schema s
-sql
-persist_unlogged
 unsafe pattern sql.persist_unlogged(X_0:str, X_1:str) (X_2:bat[:str], 
X_3:bat[:int], X_4:bat[:lng]) 
 SQLpersist_unlogged;
 Persist deltas on append only table in schema s table t
diff --git a/clients/Tests/MAL-signatures.test 
b/clients/Tests/MAL-signatures.test
--- a/clients/Tests/MAL-signatures.test
+++ b/clients/Tests/MAL-signatures.test
@@ -38155,16 +38155,6 @@ SQLpercent_rank;
 return the percentage into the total number of groups for each row
 sql
 persist_unlogged
-unsafe pattern sql.persist_unlogged() (X_0:bat[:str], X_1:bat[:int], 
X_2:bat[:lng]) 
-SQLpersist_unlogged;
-Persist deltas on append only tables in current schema
-sql
-persist_unlogged
-unsafe pattern sql.persist_unlogged(X_0:str) (X_1:bat[:str], X_2:bat[:int], 
X_3:bat[:lng]) 
-SQLpersist_unlogged;
-Persist deltas on append only tables in schema s
-sql
-persist_unlogged
 unsafe pattern sql.persist_unlogged(X_0:str, X_1:str) (X_2:bat[:str], 
X_3:bat[:int], X_4:bat[:lng]) 
 SQLpersist_unlogged;
 Persist deltas on append only table in schema s table t
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
@@ -956,17 +956,9 @@ update sys._tables set system = true whe
  and name in 
('character_sets','check_constraints','columns','parameters','routines','schemata','sequences','referential_constraints','table_constraints','tables','views');
 
 Running database upgrade commands:
-CREATE FUNCTION sys.persist_unlogged()
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
-CREATE FUNCTION sys.persist_unlogged(sname STRING)
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
 CREATE FUNCTION sys.persist_unlogged(sname STRING, tname STRING)
 RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
 EXTERNAL NAME sql.persist_unlogged;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged() TO PUBLIC;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string) TO PUBLIC;
 GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string, string) TO PUBLIC;
 UPDATE sys.functions SET system = true WHERE system <> true AND
 name = 'persist_unlogged' AND schema_id = 2000 AND type = 5 AND language = 1;
diff --git a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out 
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
@@ -956,17 +956,9 @@ update sys._tables set system = true whe
  and name in 
('character_sets','check_constraints','columns','parameters','routines','schemata','sequences','referential_constraints','table_constraints','tables','views');
 
 Running database upgrade commands:
-CREATE FUNCTION sys.persist_unlogged()
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
-CREATE FUNCTION sys.persist_unlogged(sname STRING)
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
 CREATE FUNCTION sys.persist_unlogged(sname STRING, tname STRING)
 RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
 EXTERNAL NAME sql.persist_unlogged;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged() TO PUBLIC;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string) TO PUBLIC;
 GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string, string) TO PUBLIC;
 UPDATE sys.functions SET system = true WHERE system <> true AND
 name = 'persist_unlogged' AND schema_id = 2000 AND type = 5 AND language = 1;
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
@@ -1025,17 +1025,9 @@ update sys._tables set system = true whe
  and name in 
('character_sets','check_constraints','columns','parameters','routines','schemata','sequences','referential_constraints','table_constraints','tables','views');
 
 Running database upgrade commands:
-CREATE FUNCTION sys.persist_unlogged()
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
-CREATE FUNCTION sys.persist_unlogged(sname STRING)
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
 CREATE FUNCTION sys.persist_unlogged(sname STRING, tname STRING)
 RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
 EXTERNAL NAME sql.persist_unlogged;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged() TO PUBLIC;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string) TO PUBLIC;
 GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string, string) TO PUBLIC;
 UPDATE sys.functions SET system = true WHERE system <> true AND
 name = 'persist_unlogged' AND schema_id = 2000 AND type = 5 AND language = 1;
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
@@ -956,17 +956,9 @@ update sys._tables set system = true whe
  and name in 
('character_sets','check_constraints','columns','parameters','routines','schemata','sequences','referential_constraints','table_constraints','tables','views');
 
 Running database upgrade commands:
-CREATE FUNCTION sys.persist_unlogged()
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
-CREATE FUNCTION sys.persist_unlogged(sname STRING)
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
 CREATE FUNCTION sys.persist_unlogged(sname STRING, tname STRING)
 RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
 EXTERNAL NAME sql.persist_unlogged;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged() TO PUBLIC;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string) TO PUBLIC;
 GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string, string) TO PUBLIC;
 UPDATE sys.functions SET system = true WHERE system <> true AND
 name = 'persist_unlogged' AND schema_id = 2000 AND type = 5 AND language = 1;
diff --git a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out 
b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
--- a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
@@ -956,17 +956,9 @@ update sys._tables set system = true whe
  and name in 
('character_sets','check_constraints','columns','parameters','routines','schemata','sequences','referential_constraints','table_constraints','tables','views');
 
 Running database upgrade commands:
-CREATE FUNCTION sys.persist_unlogged()
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
-CREATE FUNCTION sys.persist_unlogged(sname STRING)
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
 CREATE FUNCTION sys.persist_unlogged(sname STRING, tname STRING)
 RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
 EXTERNAL NAME sql.persist_unlogged;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged() TO PUBLIC;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string) TO PUBLIC;
 GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string, string) TO PUBLIC;
 UPDATE sys.functions SET system = true WHERE system <> true AND
 name = 'persist_unlogged' AND schema_id = 2000 AND type = 5 AND language = 1;
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
@@ -1025,17 +1025,9 @@ update sys._tables set system = true whe
  and name in 
('character_sets','check_constraints','columns','parameters','routines','schemata','sequences','referential_constraints','table_constraints','tables','views');
 
 Running database upgrade commands:
-CREATE FUNCTION sys.persist_unlogged()
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
-CREATE FUNCTION sys.persist_unlogged(sname STRING)
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
 CREATE FUNCTION sys.persist_unlogged(sname STRING, tname STRING)
 RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
 EXTERNAL NAME sql.persist_unlogged;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged() TO PUBLIC;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string) TO PUBLIC;
 GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string, string) TO PUBLIC;
 UPDATE sys.functions SET system = true WHERE system <> true AND
 name = 'persist_unlogged' AND schema_id = 2000 AND type = 5 AND language = 1;
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
@@ -596,17 +596,9 @@ update sys._tables set system = true whe
  and name in 
('character_sets','check_constraints','columns','parameters','routines','schemata','sequences','referential_constraints','table_constraints','tables','views');
 
 Running database upgrade commands:
-CREATE FUNCTION sys.persist_unlogged()
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
-CREATE FUNCTION sys.persist_unlogged(sname STRING)
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
 CREATE FUNCTION sys.persist_unlogged(sname STRING, tname STRING)
 RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
 EXTERNAL NAME sql.persist_unlogged;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged() TO PUBLIC;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string) TO PUBLIC;
 GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string, string) TO PUBLIC;
 UPDATE sys.functions SET system = true WHERE system <> true AND
 name = 'persist_unlogged' AND schema_id = 2000 AND type = 5 AND language = 1;
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
@@ -596,17 +596,9 @@ update sys._tables set system = true whe
  and name in 
('character_sets','check_constraints','columns','parameters','routines','schemata','sequences','referential_constraints','table_constraints','tables','views');
 
 Running database upgrade commands:
-CREATE FUNCTION sys.persist_unlogged()
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
-CREATE FUNCTION sys.persist_unlogged(sname STRING)
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
 CREATE FUNCTION sys.persist_unlogged(sname STRING, tname STRING)
 RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
 EXTERNAL NAME sql.persist_unlogged;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged() TO PUBLIC;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string) TO PUBLIC;
 GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string, string) TO PUBLIC;
 UPDATE sys.functions SET system = true WHERE system <> true AND
 name = 'persist_unlogged' AND schema_id = 2000 AND type = 5 AND language = 1;
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
@@ -665,17 +665,9 @@ update sys._tables set system = true whe
  and name in 
('character_sets','check_constraints','columns','parameters','routines','schemata','sequences','referential_constraints','table_constraints','tables','views');
 
 Running database upgrade commands:
-CREATE FUNCTION sys.persist_unlogged()
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
-CREATE FUNCTION sys.persist_unlogged(sname STRING)
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
 CREATE FUNCTION sys.persist_unlogged(sname STRING, tname STRING)
 RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
 EXTERNAL NAME sql.persist_unlogged;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged() TO PUBLIC;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string) TO PUBLIC;
 GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string, string) TO PUBLIC;
 UPDATE sys.functions SET system = true WHERE system <> true AND
 name = 'persist_unlogged' AND schema_id = 2000 AND type = 5 AND language = 1;
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
@@ -665,17 +665,9 @@ update sys._tables set system = true whe
  and name in 
('character_sets','check_constraints','columns','parameters','routines','schemata','sequences','referential_constraints','table_constraints','tables','views');
 
 Running database upgrade commands:
-CREATE FUNCTION sys.persist_unlogged()
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
-CREATE FUNCTION sys.persist_unlogged(sname STRING)
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
 CREATE FUNCTION sys.persist_unlogged(sname STRING, tname STRING)
 RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
 EXTERNAL NAME sql.persist_unlogged;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged() TO PUBLIC;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string) TO PUBLIC;
 GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string, string) TO PUBLIC;
 UPDATE sys.functions SET system = true WHERE system <> true AND
 name = 'persist_unlogged' AND schema_id = 2000 AND type = 5 AND language = 1;
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
@@ -596,17 +596,9 @@ update sys._tables set system = true whe
  and name in 
('character_sets','check_constraints','columns','parameters','routines','schemata','sequences','referential_constraints','table_constraints','tables','views');
 
 Running database upgrade commands:
-CREATE FUNCTION sys.persist_unlogged()
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
-CREATE FUNCTION sys.persist_unlogged(sname STRING)
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
 CREATE FUNCTION sys.persist_unlogged(sname STRING, tname STRING)
 RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
 EXTERNAL NAME sql.persist_unlogged;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged() TO PUBLIC;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string) TO PUBLIC;
 GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string, string) TO PUBLIC;
 UPDATE sys.functions SET system = true WHERE system <> true AND
 name = 'persist_unlogged' AND schema_id = 2000 AND type = 5 AND language = 1;
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
@@ -596,17 +596,9 @@ update sys._tables set system = true whe
  and name in 
('character_sets','check_constraints','columns','parameters','routines','schemata','sequences','referential_constraints','table_constraints','tables','views');
 
 Running database upgrade commands:
-CREATE FUNCTION sys.persist_unlogged()
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
-CREATE FUNCTION sys.persist_unlogged(sname STRING)
-RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
-EXTERNAL NAME sql.persist_unlogged;
 CREATE FUNCTION sys.persist_unlogged(sname STRING, tname STRING)
 RETURNS TABLE("table" STRING, "table_id" INT, "rowcount" BIGINT)
 EXTERNAL NAME sql.persist_unlogged;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged() TO PUBLIC;
-GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string) TO PUBLIC;
 GRANT EXECUTE ON FUNCTION sys.persist_unlogged(string, string) TO PUBLIC;
 UPDATE sys.functions SET system = true WHERE system <> true AND
 name = 'persist_unlogged' AND schema_id = 2000 AND type = 5 AND language = 1;
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
@@ -665,17 +665,9 @@ update sys._tables set system = true whe
  and name in 
('character_sets','check_constraints','columns','parameters','routines','schemata','sequences','referential_constraints','table_constraints','tables','views');
 
 Running database upgrade commands:
-CREATE FUNCTION sys.persist_unlogged()
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org