Changeset: 8c31cf24cb03 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/8c31cf24cb03
Modified Files:
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: Aug2024
Log Message:
Approve upgrades.
diffs (truncated from 807 to 300 lines):
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
@@ -1029,20 +1029,25 @@ create function sys.sessions()
)
external name sql.sessions;
create view sys.sessions as select * from sys.sessions();
+grant select on sys.sessions to public;
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, session_attr string);
+create table sys.clientinfo_properties(prop varchar(40) NOT NULL, session_attr
varchar(40) NOT NULL);
insert into sys.clientinfo_properties values
('ClientHostname', 'hostname'),
('ApplicationName', 'application'),
('ClientLibrary', 'client'),
- ('ClientRemark', 'remark'),
- ('ClientPid', 'clientpid');
+ ('ClientPid', 'clientpid'),
+ ('ClientRemark', 'remark');
+grant select on sys.clientinfo_properties to public;
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');
Running database upgrade commands:
+alter table sys.clientinfo_properties SET READ ONLY;
+
+Running database upgrade commands:
DROP TABLE sys.key_types;
CREATE TABLE sys.key_types (
key_type_id SMALLINT NOT NULL PRIMARY KEY,
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
@@ -1017,20 +1017,25 @@ create function sys.sessions()
)
external name sql.sessions;
create view sys.sessions as select * from sys.sessions();
+grant select on sys.sessions to public;
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, session_attr string);
+create table sys.clientinfo_properties(prop varchar(40) NOT NULL, session_attr
varchar(40) NOT NULL);
insert into sys.clientinfo_properties values
('ClientHostname', 'hostname'),
('ApplicationName', 'application'),
('ClientLibrary', 'client'),
- ('ClientRemark', 'remark'),
- ('ClientPid', 'clientpid');
+ ('ClientPid', 'clientpid'),
+ ('ClientRemark', 'remark');
+grant select on sys.clientinfo_properties to public;
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');
Running database upgrade commands:
+alter table sys.clientinfo_properties SET READ ONLY;
+
+Running database upgrade commands:
DROP TABLE sys.key_types;
CREATE TABLE sys.key_types (
key_type_id SMALLINT NOT NULL PRIMARY KEY,
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
@@ -1098,20 +1098,25 @@ create function sys.sessions()
)
external name sql.sessions;
create view sys.sessions as select * from sys.sessions();
+grant select on sys.sessions to public;
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, session_attr string);
+create table sys.clientinfo_properties(prop varchar(40) NOT NULL, session_attr
varchar(40) NOT NULL);
insert into sys.clientinfo_properties values
('ClientHostname', 'hostname'),
('ApplicationName', 'application'),
('ClientLibrary', 'client'),
- ('ClientRemark', 'remark'),
- ('ClientPid', 'clientpid');
+ ('ClientPid', 'clientpid'),
+ ('ClientRemark', 'remark');
+grant select on sys.clientinfo_properties to public;
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');
Running database upgrade commands:
+alter table sys.clientinfo_properties SET READ ONLY;
+
+Running database upgrade commands:
DROP TABLE sys.key_types;
CREATE TABLE sys.key_types (
key_type_id SMALLINT NOT NULL PRIMARY KEY,
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
@@ -1029,20 +1029,25 @@ create function sys.sessions()
)
external name sql.sessions;
create view sys.sessions as select * from sys.sessions();
+grant select on sys.sessions to public;
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, session_attr string);
+create table sys.clientinfo_properties(prop varchar(40) NOT NULL, session_attr
varchar(40) NOT NULL);
insert into sys.clientinfo_properties values
('ClientHostname', 'hostname'),
('ApplicationName', 'application'),
('ClientLibrary', 'client'),
- ('ClientRemark', 'remark'),
- ('ClientPid', 'clientpid');
+ ('ClientPid', 'clientpid'),
+ ('ClientRemark', 'remark');
+grant select on sys.clientinfo_properties to public;
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');
Running database upgrade commands:
+alter table sys.clientinfo_properties SET READ ONLY;
+
+Running database upgrade commands:
DROP TABLE sys.key_types;
CREATE TABLE sys.key_types (
key_type_id SMALLINT NOT NULL PRIMARY KEY,
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
@@ -1017,20 +1017,25 @@ create function sys.sessions()
)
external name sql.sessions;
create view sys.sessions as select * from sys.sessions();
+grant select on sys.sessions to public;
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, session_attr string);
+create table sys.clientinfo_properties(prop varchar(40) NOT NULL, session_attr
varchar(40) NOT NULL);
insert into sys.clientinfo_properties values
('ClientHostname', 'hostname'),
('ApplicationName', 'application'),
('ClientLibrary', 'client'),
- ('ClientRemark', 'remark'),
- ('ClientPid', 'clientpid');
+ ('ClientPid', 'clientpid'),
+ ('ClientRemark', 'remark');
+grant select on sys.clientinfo_properties to public;
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');
Running database upgrade commands:
+alter table sys.clientinfo_properties SET READ ONLY;
+
+Running database upgrade commands:
DROP TABLE sys.key_types;
CREATE TABLE sys.key_types (
key_type_id SMALLINT NOT NULL PRIMARY KEY,
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
@@ -1098,20 +1098,25 @@ create function sys.sessions()
)
external name sql.sessions;
create view sys.sessions as select * from sys.sessions();
+grant select on sys.sessions to public;
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, session_attr string);
+create table sys.clientinfo_properties(prop varchar(40) NOT NULL, session_attr
varchar(40) NOT NULL);
insert into sys.clientinfo_properties values
('ClientHostname', 'hostname'),
('ApplicationName', 'application'),
('ClientLibrary', 'client'),
- ('ClientRemark', 'remark'),
- ('ClientPid', 'clientpid');
+ ('ClientPid', 'clientpid'),
+ ('ClientRemark', 'remark');
+grant select on sys.clientinfo_properties to public;
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');
Running database upgrade commands:
+alter table sys.clientinfo_properties SET READ ONLY;
+
+Running database upgrade commands:
DROP TABLE sys.key_types;
CREATE TABLE sys.key_types (
key_type_id SMALLINT NOT NULL PRIMARY KEY,
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
@@ -419,20 +419,25 @@ create function sys.sessions()
)
external name sql.sessions;
create view sys.sessions as select * from sys.sessions();
+grant select on sys.sessions to public;
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, session_attr string);
+create table sys.clientinfo_properties(prop varchar(40) NOT NULL, session_attr
varchar(40) NOT NULL);
insert into sys.clientinfo_properties values
('ClientHostname', 'hostname'),
('ApplicationName', 'application'),
('ClientLibrary', 'client'),
- ('ClientRemark', 'remark'),
- ('ClientPid', 'clientpid');
+ ('ClientPid', 'clientpid'),
+ ('ClientRemark', 'remark');
+grant select on sys.clientinfo_properties to public;
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');
Running database upgrade commands:
+alter table sys.clientinfo_properties SET READ ONLY;
+
+Running database upgrade commands:
DROP TABLE sys.key_types;
CREATE TABLE sys.key_types (
key_type_id SMALLINT NOT NULL PRIMARY KEY,
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
@@ -407,20 +407,25 @@ create function sys.sessions()
)
external name sql.sessions;
create view sys.sessions as select * from sys.sessions();
+grant select on sys.sessions to public;
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, session_attr string);
+create table sys.clientinfo_properties(prop varchar(40) NOT NULL, session_attr
varchar(40) NOT NULL);
insert into sys.clientinfo_properties values
('ClientHostname', 'hostname'),
('ApplicationName', 'application'),
('ClientLibrary', 'client'),
- ('ClientRemark', 'remark'),
- ('ClientPid', 'clientpid');
+ ('ClientPid', 'clientpid'),
+ ('ClientRemark', 'remark');
+grant select on sys.clientinfo_properties to public;
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');
Running database upgrade commands:
+alter table sys.clientinfo_properties SET READ ONLY;
+
+Running database upgrade commands:
DROP TABLE sys.key_types;
CREATE TABLE sys.key_types (
key_type_id SMALLINT NOT NULL PRIMARY KEY,
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
@@ -488,20 +488,25 @@ create function sys.sessions()
)
external name sql.sessions;
create view sys.sessions as select * from sys.sessions();
+grant select on sys.sessions to public;
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, session_attr string);
+create table sys.clientinfo_properties(prop varchar(40) NOT NULL, session_attr
varchar(40) NOT NULL);
insert into sys.clientinfo_properties values
('ClientHostname', 'hostname'),
('ApplicationName', 'application'),
('ClientLibrary', 'client'),
- ('ClientRemark', 'remark'),
- ('ClientPid', 'clientpid');
+ ('ClientPid', 'clientpid'),
+ ('ClientRemark', 'remark');
+grant select on sys.clientinfo_properties to public;
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');
Running database upgrade commands:
+alter table sys.clientinfo_properties SET READ ONLY;
+
+Running database upgrade commands:
DROP TABLE sys.key_types;
CREATE TABLE sys.key_types (
key_type_id SMALLINT NOT NULL PRIMARY KEY,
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
@@ -419,20 +419,25 @@ create function sys.sessions()
)
external name sql.sessions;
create view sys.sessions as select * from sys.sessions();
+grant select on sys.sessions to public;
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, session_attr string);
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
