Changeset: 6319163e3d93 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6319163e3d93 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 upgrade. diffs (truncated from 304 to 300 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 @@ -5994,7 +5994,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -5994,7 +5994,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -5207,7 +5207,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -5207,7 +5207,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -6038,7 +6038,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -5207,7 +5207,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -6038,7 +6038,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -5994,7 +5994,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -5207,7 +5207,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -5207,7 +5207,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -6038,7 +6038,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -5994,7 +5994,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -5206,7 +5206,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -5206,7 +5206,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -6037,7 +6037,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -5994,7 +5994,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -5207,7 +5207,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -5207,7 +5207,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; +update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags', 'sleep'); drop view sys.queue; drop function sys.queue; create function sys.queue() 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 @@ -6038,7 +6038,11 @@ create function sys.debug(flag string) r create function sys.debugflags() returns table(flag string, val bool) external name mdb."getDebugFlags"; -update sys.functions set system = true where schema_id = (select id from sys.schemas where name = 'sys') and name in ('debug', 'debugflags'); +create procedure sys."sleep"(msecs int) + external name "alarm"."sleep"; +create function sys."sleep"(msecs int) returns integer + external name "alarm"."sleep"; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list