Changeset: 1b03169d2ff1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1b03169d2ff1
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 494 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
@@ -82,8 +82,20 @@ returns table(
"created" timestamp)
external name sql.prepared_statements;
create view sys.prepared_statements as select * from sys.prepared_statements();
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements')
and type = 5;
-update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements');
+create function sys.prepared_statements_args()
+returns table(
+"statementid" int,
+"parameter" boolean,
+"type" string,
+"digits" int,
+"scale" int,
+"schema" string,
+"table" string,
+"column" string)
+ external name sql.prepared_statements_args;
+create view sys.prepared_statements_args as select * from
sys.prepared_statements_args();
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args') and type = 5;
+update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args');
update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('setoptimizer', 'setquerytimeout',
'setsessiontimeout', 'setworkerlimit', 'setmemorylimit', 'setoptimizer',
'stopsession') and type = 2;
create function sys.debug(flag string) returns integer
external name mdb."setDebug";
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
@@ -82,8 +82,20 @@ returns table(
"created" timestamp)
external name sql.prepared_statements;
create view sys.prepared_statements as select * from sys.prepared_statements();
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements')
and type = 5;
-update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements');
+create function sys.prepared_statements_args()
+returns table(
+"statementid" int,
+"parameter" boolean,
+"type" string,
+"digits" int,
+"scale" int,
+"schema" string,
+"table" string,
+"column" string)
+ external name sql.prepared_statements_args;
+create view sys.prepared_statements_args as select * from
sys.prepared_statements_args();
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args') and type = 5;
+update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args');
update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('setoptimizer', 'setquerytimeout',
'setsessiontimeout', 'setworkerlimit', 'setmemorylimit', 'setoptimizer',
'stopsession') and type = 2;
create function sys.debug(flag string) returns integer
external name mdb."setDebug";
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
@@ -82,8 +82,20 @@ returns table(
"created" timestamp)
external name sql.prepared_statements;
create view sys.prepared_statements as select * from sys.prepared_statements();
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements')
and type = 5;
-update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements');
+create function sys.prepared_statements_args()
+returns table(
+"statementid" int,
+"parameter" boolean,
+"type" string,
+"digits" int,
+"scale" int,
+"schema" string,
+"table" string,
+"column" string)
+ external name sql.prepared_statements_args;
+create view sys.prepared_statements_args as select * from
sys.prepared_statements_args();
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args') and type = 5;
+update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args');
update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('setoptimizer', 'setquerytimeout',
'setsessiontimeout', 'setworkerlimit', 'setmemorylimit', 'setoptimizer',
'stopsession') and type = 2;
create function sys.debug(flag string) returns integer
external name mdb."setDebug";
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
@@ -82,8 +82,20 @@ returns table(
"created" timestamp)
external name sql.prepared_statements;
create view sys.prepared_statements as select * from sys.prepared_statements();
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements')
and type = 5;
-update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements');
+create function sys.prepared_statements_args()
+returns table(
+"statementid" int,
+"parameter" boolean,
+"type" string,
+"digits" int,
+"scale" int,
+"schema" string,
+"table" string,
+"column" string)
+ external name sql.prepared_statements_args;
+create view sys.prepared_statements_args as select * from
sys.prepared_statements_args();
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args') and type = 5;
+update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args');
update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('setoptimizer', 'setquerytimeout',
'setsessiontimeout', 'setworkerlimit', 'setmemorylimit', 'setoptimizer',
'stopsession') and type = 2;
create function sys.debug(flag string) returns integer
external name mdb."setDebug";
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
@@ -6008,8 +6008,20 @@ returns table(
"created" timestamp)
external name sql.prepared_statements;
create view sys.prepared_statements as select * from sys.prepared_statements();
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements')
and type = 5;
-update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements');
+create function sys.prepared_statements_args()
+returns table(
+"statementid" int,
+"parameter" boolean,
+"type" string,
+"digits" int,
+"scale" int,
+"schema" string,
+"table" string,
+"column" string)
+ external name sql.prepared_statements_args;
+create view sys.prepared_statements_args as select * from
sys.prepared_statements_args();
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args') and type = 5;
+update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args');
update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('setoptimizer', 'setquerytimeout',
'setsessiontimeout', 'setworkerlimit', 'setmemorylimit', 'setoptimizer',
'stopsession') and type = 2;
create function sys.debug(flag string) returns integer
external name mdb."setDebug";
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
@@ -82,8 +82,20 @@ returns table(
"created" timestamp)
external name sql.prepared_statements;
create view sys.prepared_statements as select * from sys.prepared_statements();
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements')
and type = 5;
-update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements');
+create function sys.prepared_statements_args()
+returns table(
+"statementid" int,
+"parameter" boolean,
+"type" string,
+"digits" int,
+"scale" int,
+"schema" string,
+"table" string,
+"column" string)
+ external name sql.prepared_statements_args;
+create view sys.prepared_statements_args as select * from
sys.prepared_statements_args();
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args') and type = 5;
+update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args');
update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('setoptimizer', 'setquerytimeout',
'setsessiontimeout', 'setworkerlimit', 'setmemorylimit', 'setoptimizer',
'stopsession') and type = 2;
create function sys.debug(flag string) returns integer
external name mdb."setDebug";
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
@@ -6008,8 +6008,20 @@ returns table(
"created" timestamp)
external name sql.prepared_statements;
create view sys.prepared_statements as select * from sys.prepared_statements();
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements')
and type = 5;
-update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements');
+create function sys.prepared_statements_args()
+returns table(
+"statementid" int,
+"parameter" boolean,
+"type" string,
+"digits" int,
+"scale" int,
+"schema" string,
+"table" string,
+"column" string)
+ external name sql.prepared_statements_args;
+create view sys.prepared_statements_args as select * from
sys.prepared_statements_args();
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args') and type = 5;
+update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args');
update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('setoptimizer', 'setquerytimeout',
'setsessiontimeout', 'setworkerlimit', 'setmemorylimit', 'setoptimizer',
'stopsession') and type = 2;
create function sys.debug(flag string) returns integer
external name mdb."setDebug";
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
@@ -82,8 +82,20 @@ returns table(
"created" timestamp)
external name sql.prepared_statements;
create view sys.prepared_statements as select * from sys.prepared_statements();
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements')
and type = 5;
-update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements');
+create function sys.prepared_statements_args()
+returns table(
+"statementid" int,
+"parameter" boolean,
+"type" string,
+"digits" int,
+"scale" int,
+"schema" string,
+"table" string,
+"column" string)
+ external name sql.prepared_statements_args;
+create view sys.prepared_statements_args as select * from
sys.prepared_statements_args();
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args') and type = 5;
+update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args');
update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('setoptimizer', 'setquerytimeout',
'setsessiontimeout', 'setworkerlimit', 'setmemorylimit', 'setoptimizer',
'stopsession') and type = 2;
create function sys.debug(flag string) returns integer
external name mdb."setDebug";
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
@@ -82,8 +82,20 @@ returns table(
"created" timestamp)
external name sql.prepared_statements;
create view sys.prepared_statements as select * from sys.prepared_statements();
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements')
and type = 5;
-update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements');
+create function sys.prepared_statements_args()
+returns table(
+"statementid" int,
+"parameter" boolean,
+"type" string,
+"digits" int,
+"scale" int,
+"schema" string,
+"table" string,
+"column" string)
+ external name sql.prepared_statements_args;
+create view sys.prepared_statements_args as select * from
sys.prepared_statements_args();
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args') and type = 5;
+update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args');
update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('setoptimizer', 'setquerytimeout',
'setsessiontimeout', 'setworkerlimit', 'setmemorylimit', 'setoptimizer',
'stopsession') and type = 2;
create function sys.debug(flag string) returns integer
external name mdb."setDebug";
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
@@ -82,8 +82,20 @@ returns table(
"created" timestamp)
external name sql.prepared_statements;
create view sys.prepared_statements as select * from sys.prepared_statements();
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements')
and type = 5;
-update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements');
+create function sys.prepared_statements_args()
+returns table(
+"statementid" int,
+"parameter" boolean,
+"type" string,
+"digits" int,
+"scale" int,
+"schema" string,
+"table" string,
+"column" string)
+ external name sql.prepared_statements_args;
+create view sys.prepared_statements_args as select * from
sys.prepared_statements_args();
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args') and type = 5;
+update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args');
update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('setoptimizer', 'setquerytimeout',
'setsessiontimeout', 'setworkerlimit', 'setmemorylimit', 'setoptimizer',
'stopsession') and type = 2;
create function sys.debug(flag string) returns integer
external name mdb."setDebug";
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
@@ -6008,8 +6008,20 @@ returns table(
"created" timestamp)
external name sql.prepared_statements;
create view sys.prepared_statements as select * from sys.prepared_statements();
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements')
and type = 5;
-update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements');
+create function sys.prepared_statements_args()
+returns table(
+"statementid" int,
+"parameter" boolean,
+"type" string,
+"digits" int,
+"scale" int,
+"schema" string,
+"table" string,
+"column" string)
+ external name sql.prepared_statements_args;
+create view sys.prepared_statements_args as select * from
sys.prepared_statements_args();
+update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args') and type = 5;
+update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements',
'prepared_statements_args');
update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('setoptimizer', 'setquerytimeout',
'setsessiontimeout', 'setworkerlimit', 'setmemorylimit', 'setoptimizer',
'stopsession') and type = 2;
create function sys.debug(flag string) returns integer
external name mdb."setDebug";
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
@@ -82,8 +82,20 @@ returns table(
"created" timestamp)
external name sql.prepared_statements;
create view sys.prepared_statements as select * from sys.prepared_statements();
-update sys.functions set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements')
and type = 5;
-update sys._tables set system = true where schema_id = (select id from
sys.schemas where name = 'sys') and name in ('sessions', 'prepared_statements');
+create function sys.prepared_statements_args()
+returns table(
+"statementid" int,
+"parameter" boolean,
+"type" string,
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
