Changeset: 696834438666 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=696834438666
Modified Files:
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.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.powerpc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.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-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: default
Log Message:
Approve various upgrade tests
By monkey patching the outputs, I don't have the input files
needed to run the tests locally
diffs (266 lines):
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
@@ -6009,7 +6009,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
diff --git
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
---
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
+++
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
@@ -6009,7 +6009,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
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
@@ -5219,7 +5219,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
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
@@ -5219,7 +5219,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
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
@@ -6048,7 +6048,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
@@ -5219,7 +5219,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
diff --git
a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
@@ -6048,7 +6048,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
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
@@ -6009,7 +6009,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
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
@@ -5219,7 +5219,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
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
@@ -5219,7 +5219,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
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
@@ -6048,7 +6048,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
diff --git a/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -6009,7 +6009,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
@@ -5218,7 +5218,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
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
@@ -5218,7 +5218,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -6047,7 +6047,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
diff --git a/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -6009,7 +6009,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out
b/sql/test/testdb-upgrade/Tests/upgrade.stable.out
--- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out
@@ -5219,7 +5219,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
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
@@ -5219,7 +5219,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
@@ -6048,7 +6048,9 @@ create procedure suspend_log_flushing()
external name sql.suspend_log_flushing;
create procedure resume_log_flushing()
external name sql.resume_log_flushing;
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing') and type = 2;
+create procedure hot_snapshot(tarfile string)
+ external name sql.hot_snapshot;
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('suspend_log_flushing',
'resume_log_flushing', 'hot_snapshot') and type = 2;
set schema "sys";
commit;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
