Changeset: 069d1413870e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/069d1413870e 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 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-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.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: clientinfo Log Message:
Fix and approve upgrades. diffs (truncated from 1103 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 @@ -7141,7 +7141,7 @@ sql_update_default(Client c, mvc *sql, s " ('ClientRemark'),\n" " ('ClientPid');\n" "update sys.functions set system = true where schema_id = 2000 and name in ('setclientinfo', 'sessions');\n" - "update sys._tables set system = true where schema_id = 2000 and name = 'clientinfo_properties';\n"; + "update sys._tables set system = true where schema_id = 2000 and name in ('clientinfo_properties', 'sessions');\n"; ; sql_schema *sys = mvc_bind_schema(sql, "sys"); sql_table *t = mvc_bind_table(sql, sys, "sessions"); 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 @@ -1009,3 +1009,40 @@ returns table (value date) external name generator.series; update sys.functions set system = true where system <> true and name = 'generate_series' and schema_id = 2000; +Running database upgrade commands: +drop view sys.sessions; +drop function sys.sessions(); +create function sys.sessions() + returns table( + "sessionid" int, + "username" string, + "login" timestamp, + "idle" timestamp, + "optimizer" string, + "sessiontimeout" int, + "querytimeout" int, + "workerlimit" int, + "memorylimit" int, + "language" string, + "peer" string, + "hostname" string, + "application" string, + "client" string, + "clientpid" bigint, + "remark" string + ) + external name sql.sessions; +create view sys.sessions as select * from sys.sessions(); +create procedure sys.setclientinfo(property string, value string) + external name clients.setinfo; +grant execute on procedure sys.setclientinfo(string, string) to public; +create table sys.clientinfo_properties(prop string); +insert into sys.clientinfo_properties values + ('ClientHostname'), + ('ApplicationName'), + ('ClientLibrary'), + ('ClientRemark'), + ('ClientPid'); +update sys.functions set system = true where schema_id = 2000 and name in ('setclientinfo', 'sessions'); +update sys._tables set system = true where schema_id = 2000 and name in ('clientinfo_properties', 'sessions'); + 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 @@ -997,3 +997,40 @@ returns table (value date) external name generator.series; update sys.functions set system = true where system <> true and name = 'generate_series' and schema_id = 2000; +Running database upgrade commands: +drop view sys.sessions; +drop function sys.sessions(); +create function sys.sessions() + returns table( + "sessionid" int, + "username" string, + "login" timestamp, + "idle" timestamp, + "optimizer" string, + "sessiontimeout" int, + "querytimeout" int, + "workerlimit" int, + "memorylimit" int, + "language" string, + "peer" string, + "hostname" string, + "application" string, + "client" string, + "clientpid" bigint, + "remark" string + ) + external name sql.sessions; +create view sys.sessions as select * from sys.sessions(); +create procedure sys.setclientinfo(property string, value string) + external name clients.setinfo; +grant execute on procedure sys.setclientinfo(string, string) to public; +create table sys.clientinfo_properties(prop string); +insert into sys.clientinfo_properties values + ('ClientHostname'), + ('ApplicationName'), + ('ClientLibrary'), + ('ClientRemark'), + ('ClientPid'); +update sys.functions set system = true where schema_id = 2000 and name in ('setclientinfo', 'sessions'); +update sys._tables set system = true where schema_id = 2000 and name in ('clientinfo_properties', 'sessions'); + 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 @@ -1078,3 +1078,40 @@ returns table (value date) external name generator.series; update sys.functions set system = true where system <> true and name = 'generate_series' and schema_id = 2000; +Running database upgrade commands: +drop view sys.sessions; +drop function sys.sessions(); +create function sys.sessions() + returns table( + "sessionid" int, + "username" string, + "login" timestamp, + "idle" timestamp, + "optimizer" string, + "sessiontimeout" int, + "querytimeout" int, + "workerlimit" int, + "memorylimit" int, + "language" string, + "peer" string, + "hostname" string, + "application" string, + "client" string, + "clientpid" bigint, + "remark" string + ) + external name sql.sessions; +create view sys.sessions as select * from sys.sessions(); +create procedure sys.setclientinfo(property string, value string) + external name clients.setinfo; +grant execute on procedure sys.setclientinfo(string, string) to public; +create table sys.clientinfo_properties(prop string); +insert into sys.clientinfo_properties values + ('ClientHostname'), + ('ApplicationName'), + ('ClientLibrary'), + ('ClientRemark'), + ('ClientPid'); +update sys.functions set system = true where schema_id = 2000 and name in ('setclientinfo', 'sessions'); +update sys._tables set system = true where schema_id = 2000 and name in ('clientinfo_properties', 'sessions'); + 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 @@ -1009,3 +1009,40 @@ returns table (value date) external name generator.series; update sys.functions set system = true where system <> true and name = 'generate_series' and schema_id = 2000; +Running database upgrade commands: +drop view sys.sessions; +drop function sys.sessions(); +create function sys.sessions() + returns table( + "sessionid" int, + "username" string, + "login" timestamp, + "idle" timestamp, + "optimizer" string, + "sessiontimeout" int, + "querytimeout" int, + "workerlimit" int, + "memorylimit" int, + "language" string, + "peer" string, + "hostname" string, + "application" string, + "client" string, + "clientpid" bigint, + "remark" string + ) + external name sql.sessions; +create view sys.sessions as select * from sys.sessions(); +create procedure sys.setclientinfo(property string, value string) + external name clients.setinfo; +grant execute on procedure sys.setclientinfo(string, string) to public; +create table sys.clientinfo_properties(prop string); +insert into sys.clientinfo_properties values + ('ClientHostname'), + ('ApplicationName'), + ('ClientLibrary'), + ('ClientRemark'), + ('ClientPid'); +update sys.functions set system = true where schema_id = 2000 and name in ('setclientinfo', 'sessions'); +update sys._tables set system = true where schema_id = 2000 and name in ('clientinfo_properties', 'sessions'); + 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 @@ -997,3 +997,40 @@ returns table (value date) external name generator.series; update sys.functions set system = true where system <> true and name = 'generate_series' and schema_id = 2000; +Running database upgrade commands: +drop view sys.sessions; +drop function sys.sessions(); +create function sys.sessions() + returns table( + "sessionid" int, + "username" string, + "login" timestamp, + "idle" timestamp, + "optimizer" string, + "sessiontimeout" int, + "querytimeout" int, + "workerlimit" int, + "memorylimit" int, + "language" string, + "peer" string, + "hostname" string, + "application" string, + "client" string, + "clientpid" bigint, + "remark" string + ) + external name sql.sessions; +create view sys.sessions as select * from sys.sessions(); +create procedure sys.setclientinfo(property string, value string) + external name clients.setinfo; +grant execute on procedure sys.setclientinfo(string, string) to public; +create table sys.clientinfo_properties(prop string); +insert into sys.clientinfo_properties values + ('ClientHostname'), + ('ApplicationName'), + ('ClientLibrary'), + ('ClientRemark'), + ('ClientPid'); +update sys.functions set system = true where schema_id = 2000 and name in ('setclientinfo', 'sessions'); +update sys._tables set system = true where schema_id = 2000 and name in ('clientinfo_properties', 'sessions'); + 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 @@ -1078,3 +1078,40 @@ returns table (value date) external name generator.series; update sys.functions set system = true where system <> true and name = 'generate_series' and schema_id = 2000; +Running database upgrade commands: +drop view sys.sessions; +drop function sys.sessions(); +create function sys.sessions() + returns table( + "sessionid" int, + "username" string, + "login" timestamp, + "idle" timestamp, + "optimizer" string, + "sessiontimeout" int, + "querytimeout" int, + "workerlimit" int, + "memorylimit" int, + "language" string, + "peer" string, + "hostname" string, + "application" string, + "client" string, + "clientpid" bigint, + "remark" string + ) + external name sql.sessions; +create view sys.sessions as select * from sys.sessions(); +create procedure sys.setclientinfo(property string, value string) + external name clients.setinfo; +grant execute on procedure sys.setclientinfo(string, string) to public; +create table sys.clientinfo_properties(prop string); +insert into sys.clientinfo_properties values + ('ClientHostname'), + ('ApplicationName'), + ('ClientLibrary'), + ('ClientRemark'), + ('ClientPid'); +update sys.functions set system = true where schema_id = 2000 and name in ('setclientinfo', 'sessions'); +update sys._tables set system = true where schema_id = 2000 and name in ('clientinfo_properties', 'sessions'); + 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 @@ -399,3 +399,40 @@ returns table (value date) external name generator.series; update sys.functions set system = true where system <> true and name = 'generate_series' and schema_id = 2000; +Running database upgrade commands: +drop view sys.sessions; +drop function sys.sessions(); +create function sys.sessions() + returns table( + "sessionid" int, + "username" string, + "login" timestamp, + "idle" timestamp, + "optimizer" string, + "sessiontimeout" int, + "querytimeout" int, + "workerlimit" int, + "memorylimit" int, + "language" string, + "peer" string, + "hostname" string, _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org