Changeset: a869dc71439c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/a869dc71439c
Modified Files:
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out
Branch: clean_parser
Log Message:
No hge upgrade approvals.
diffs (136 lines):
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
@@ -755,6 +755,13 @@ GRANT SELECT ON TABLE INFORMATION_SCHEMA
update sys._tables set system = true where not system and schema_id = (select
id from sys.schemas where name = 'information_schema') and name = 'parameters';
Running database upgrade commands:
+create function dayname(d date) returns varchar(10) return date_to_str(d,
'%A');
+create function monthname(d date) returns varchar(10) return date_to_str(d,
'%B');
+grant execute on function dayname(date) to public;
+grant execute on function monthname(date) to public;
+update sys.functions set system = true where system <> true and name in
('dayname', 'monthname') and schema_id = 2000 and type = (select
function_type_id from sys.function_types where function_type_name = 'Scalar
function');
+
+Running database upgrade commands:
drop view sys.geometry_columns;
create view sys.geometry_columns as
select cast(null as varchar(1)) as f_table_catalog,
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
@@ -755,6 +755,13 @@ GRANT SELECT ON TABLE INFORMATION_SCHEMA
update sys._tables set system = true where not system and schema_id = (select
id from sys.schemas where name = 'information_schema') and name = 'parameters';
Running database upgrade commands:
+create function dayname(d date) returns varchar(10) return date_to_str(d,
'%A');
+create function monthname(d date) returns varchar(10) return date_to_str(d,
'%B');
+grant execute on function dayname(date) to public;
+grant execute on function monthname(date) to public;
+update sys.functions set system = true where system <> true and name in
('dayname', 'monthname') and schema_id = 2000 and type = (select
function_type_id from sys.function_types where function_type_name = 'Scalar
function');
+
+Running database upgrade commands:
drop view sys.geometry_columns;
create view sys.geometry_columns as
select cast(null as varchar(1)) as f_table_catalog,
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
@@ -266,6 +266,13 @@ GRANT SELECT ON TABLE INFORMATION_SCHEMA
update sys._tables set system = true where not system and schema_id = (select
id from sys.schemas where name = 'information_schema') and name = 'parameters';
Running database upgrade commands:
+create function dayname(d date) returns varchar(10) return date_to_str(d,
'%A');
+create function monthname(d date) returns varchar(10) return date_to_str(d,
'%B');
+grant execute on function dayname(date) to public;
+grant execute on function monthname(date) to public;
+update sys.functions set system = true where system <> true and name in
('dayname', 'monthname') and schema_id = 2000 and type = (select
function_type_id from sys.function_types where function_type_name = 'Scalar
function');
+
+Running database upgrade commands:
drop view sys.geometry_columns;
create view sys.geometry_columns as
select cast(null as varchar(1)) as f_table_catalog,
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
@@ -266,6 +266,13 @@ GRANT SELECT ON TABLE INFORMATION_SCHEMA
update sys._tables set system = true where not system and schema_id = (select
id from sys.schemas where name = 'information_schema') and name = 'parameters';
Running database upgrade commands:
+create function dayname(d date) returns varchar(10) return date_to_str(d,
'%A');
+create function monthname(d date) returns varchar(10) return date_to_str(d,
'%B');
+grant execute on function dayname(date) to public;
+grant execute on function monthname(date) to public;
+update sys.functions set system = true where system <> true and name in
('dayname', 'monthname') and schema_id = 2000 and type = (select
function_type_id from sys.function_types where function_type_name = 'Scalar
function');
+
+Running database upgrade commands:
drop view sys.geometry_columns;
create view sys.geometry_columns as
select cast(null as varchar(1)) as f_table_catalog,
diff --git a/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
@@ -775,6 +775,13 @@ GRANT SELECT ON TABLE INFORMATION_SCHEMA
update sys._tables set system = true where not system and schema_id = (select
id from sys.schemas where name = 'information_schema') and name = 'parameters';
Running database upgrade commands:
+create function dayname(d date) returns varchar(10) return date_to_str(d,
'%A');
+create function monthname(d date) returns varchar(10) return date_to_str(d,
'%B');
+grant execute on function dayname(date) to public;
+grant execute on function monthname(date) to public;
+update sys.functions set system = true where system <> true and name in
('dayname', 'monthname') and schema_id = 2000 and type = (select
function_type_id from sys.function_types where function_type_name = 'Scalar
function');
+
+Running database upgrade commands:
drop view sys.geometry_columns;
create view sys.geometry_columns as
select cast(null as varchar(1)) as f_table_catalog,
diff --git a/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
b/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
--- a/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
@@ -755,6 +755,13 @@ GRANT SELECT ON TABLE INFORMATION_SCHEMA
update sys._tables set system = true where not system and schema_id = (select
id from sys.schemas where name = 'information_schema') and name = 'parameters';
Running database upgrade commands:
+create function dayname(d date) returns varchar(10) return date_to_str(d,
'%A');
+create function monthname(d date) returns varchar(10) return date_to_str(d,
'%B');
+grant execute on function dayname(date) to public;
+grant execute on function monthname(date) to public;
+update sys.functions set system = true where system <> true and name in
('dayname', 'monthname') and schema_id = 2000 and type = (select
function_type_id from sys.function_types where function_type_name = 'Scalar
function');
+
+Running database upgrade commands:
drop view sys.geometry_columns;
create view sys.geometry_columns as
select cast(null as varchar(1)) as f_table_catalog,
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
@@ -266,6 +266,13 @@ GRANT SELECT ON TABLE INFORMATION_SCHEMA
update sys._tables set system = true where not system and schema_id = (select
id from sys.schemas where name = 'information_schema') and name = 'parameters';
Running database upgrade commands:
+create function dayname(d date) returns varchar(10) return date_to_str(d,
'%A');
+create function monthname(d date) returns varchar(10) return date_to_str(d,
'%B');
+grant execute on function dayname(date) to public;
+grant execute on function monthname(date) to public;
+update sys.functions set system = true where system <> true and name in
('dayname', 'monthname') and schema_id = 2000 and type = (select
function_type_id from sys.function_types where function_type_name = 'Scalar
function');
+
+Running database upgrade commands:
drop view sys.geometry_columns;
create view sys.geometry_columns as
select cast(null as varchar(1)) as f_table_catalog,
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
@@ -266,6 +266,13 @@ GRANT SELECT ON TABLE INFORMATION_SCHEMA
update sys._tables set system = true where not system and schema_id = (select
id from sys.schemas where name = 'information_schema') and name = 'parameters';
Running database upgrade commands:
+create function dayname(d date) returns varchar(10) return date_to_str(d,
'%A');
+create function monthname(d date) returns varchar(10) return date_to_str(d,
'%B');
+grant execute on function dayname(date) to public;
+grant execute on function monthname(date) to public;
+update sys.functions set system = true where system <> true and name in
('dayname', 'monthname') and schema_id = 2000 and type = (select
function_type_id from sys.function_types where function_type_name = 'Scalar
function');
+
+Running database upgrade commands:
drop view sys.geometry_columns;
create view sys.geometry_columns as
select cast(null as varchar(1)) as f_table_catalog,
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
