Changeset: 08b786ab3cb7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=08b786ab3cb7 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 1216 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 @@ -41,7 +41,7 @@ drop function sys.sessions; create function sys.sessions() returns table( "sessionid" int, -"user" string, +"username" string, "login" timestamp, "idle" timestamp, "optimizer" string, @@ -76,7 +76,7 @@ create procedure sys.stopsession("sessio create function sys.prepared_statements() returns table( "sessionid" int, -"user" string, +"username" string, "statementid" int, "statement" string, "created" timestamp) @@ -85,10 +85,11 @@ create view sys.prepared_statements as s create function sys.prepared_statements_args() returns table( "statementid" int, -"parameter" boolean, "type" string, -"digits" int, -"scale" int, +"type_digits" int, +"type_scale" int, +"inout" tinyint, +"number" int, "schema" string, "table" string, "column" string) @@ -107,17 +108,16 @@ drop view sys.queue; drop function sys.queue; create function sys.queue() returns table( - tag bigint, - sessionid int, - "user" string, - started timestamp, - status string, - query string, - progress int, - workers int, - memory int -) -external name sql.sysmon_queue; +"tag" bigint, +"sessionid" int, +"username" string, +"started" timestamp, +"status" string, +"query" string, +"progress" int, +"workers" int, +"memory" int) + external name sql.sysmon_queue; grant execute on function sys.queue to public; create view sys.queue as select * from sys.queue(); grant select on sys.queue to public; 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 @@ -41,7 +41,7 @@ drop function sys.sessions; create function sys.sessions() returns table( "sessionid" int, -"user" string, +"username" string, "login" timestamp, "idle" timestamp, "optimizer" string, @@ -76,7 +76,7 @@ create procedure sys.stopsession("sessio create function sys.prepared_statements() returns table( "sessionid" int, -"user" string, +"username" string, "statementid" int, "statement" string, "created" timestamp) @@ -85,10 +85,11 @@ create view sys.prepared_statements as s create function sys.prepared_statements_args() returns table( "statementid" int, -"parameter" boolean, "type" string, -"digits" int, -"scale" int, +"type_digits" int, +"type_scale" int, +"inout" tinyint, +"number" int, "schema" string, "table" string, "column" string) @@ -107,17 +108,16 @@ drop view sys.queue; drop function sys.queue; create function sys.queue() returns table( - tag bigint, - sessionid int, - "user" string, - started timestamp, - status string, - query string, - progress int, - workers int, - memory int -) -external name sql.sysmon_queue; +"tag" bigint, +"sessionid" int, +"username" string, +"started" timestamp, +"status" string, +"query" string, +"progress" int, +"workers" int, +"memory" int) + external name sql.sysmon_queue; grant execute on function sys.queue to public; create view sys.queue as select * from sys.queue(); grant select on sys.queue to public; 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 @@ -41,7 +41,7 @@ drop function sys.sessions; create function sys.sessions() returns table( "sessionid" int, -"user" string, +"username" string, "login" timestamp, "idle" timestamp, "optimizer" string, @@ -76,7 +76,7 @@ create procedure sys.stopsession("sessio create function sys.prepared_statements() returns table( "sessionid" int, -"user" string, +"username" string, "statementid" int, "statement" string, "created" timestamp) @@ -85,10 +85,11 @@ create view sys.prepared_statements as s create function sys.prepared_statements_args() returns table( "statementid" int, -"parameter" boolean, "type" string, -"digits" int, -"scale" int, +"type_digits" int, +"type_scale" int, +"inout" tinyint, +"number" int, "schema" string, "table" string, "column" string) @@ -107,17 +108,16 @@ drop view sys.queue; drop function sys.queue; create function sys.queue() returns table( - tag bigint, - sessionid int, - "user" string, - started timestamp, - status string, - query string, - progress int, - workers int, - memory int -) -external name sql.sysmon_queue; +"tag" bigint, +"sessionid" int, +"username" string, +"started" timestamp, +"status" string, +"query" string, +"progress" int, +"workers" int, +"memory" int) + external name sql.sysmon_queue; grant execute on function sys.queue to public; create view sys.queue as select * from sys.queue(); grant select on sys.queue to public; 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 @@ -41,7 +41,7 @@ drop function sys.sessions; create function sys.sessions() returns table( "sessionid" int, -"user" string, +"username" string, "login" timestamp, "idle" timestamp, "optimizer" string, @@ -76,7 +76,7 @@ create procedure sys.stopsession("sessio create function sys.prepared_statements() returns table( "sessionid" int, -"user" string, +"username" string, "statementid" int, "statement" string, "created" timestamp) @@ -85,10 +85,11 @@ create view sys.prepared_statements as s create function sys.prepared_statements_args() returns table( "statementid" int, -"parameter" boolean, "type" string, -"digits" int, -"scale" int, +"type_digits" int, +"type_scale" int, +"inout" tinyint, +"number" int, "schema" string, "table" string, "column" string) @@ -107,17 +108,16 @@ drop view sys.queue; drop function sys.queue; create function sys.queue() returns table( - tag bigint, - sessionid int, - "user" string, - started timestamp, - status string, - query string, - progress int, - workers int, - memory int -) -external name sql.sysmon_queue; +"tag" bigint, +"sessionid" int, +"username" string, +"started" timestamp, +"status" string, +"query" string, +"progress" int, +"workers" int, +"memory" int) + external name sql.sysmon_queue; grant execute on function sys.queue to public; create view sys.queue as select * from sys.queue(); grant select on sys.queue to public; 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 @@ -5967,7 +5967,7 @@ drop function sys.sessions; create function sys.sessions() returns table( "sessionid" int, -"user" string, +"username" string, "login" timestamp, "idle" timestamp, "optimizer" string, @@ -6002,7 +6002,7 @@ create procedure sys.stopsession("sessio create function sys.prepared_statements() returns table( "sessionid" int, -"user" string, +"username" string, "statementid" int, "statement" string, "created" timestamp) @@ -6011,10 +6011,11 @@ create view sys.prepared_statements as s create function sys.prepared_statements_args() returns table( "statementid" int, -"parameter" boolean, "type" string, -"digits" int, -"scale" int, +"type_digits" int, +"type_scale" int, +"inout" tinyint, +"number" int, "schema" string, "table" string, "column" string) @@ -6033,17 +6034,16 @@ drop view sys.queue; drop function sys.queue; create function sys.queue() returns table( - tag bigint, - sessionid int, - "user" string, - started timestamp, _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list