Changeset: cc5e4ca0b792 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/cc5e4ca0b792
Modified Files:
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
Branch: default
Log Message:
Approvals.
diffs (138 lines):
diff --git
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
---
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
+++
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
@@ -3455,7 +3455,7 @@ insert into sys.args values (43910, 928,
insert into sys.functions values (929, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1,
false, false, false, 2000, true, false);
insert into sys.args values (43911, 929, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (43912, 929, 'arg_1', 'sec_interval', 13, 0, 1, 1);
-insert into sys.functions values (930, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (930, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (43913, 930, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (43914, 930, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (43915, 930, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3676,7 +3676,7 @@ insert into sys.args values (44075, 984,
insert into sys.args values (44076, 984, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (44077, 984, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (44078, 984, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (985, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (985, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (44079, 985, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (44080, 985, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (44081, 985, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3897,7 +3897,7 @@ insert into sys.args values (44241, 1039
insert into sys.args values (44242, 1039, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (44243, 1039, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (44244, 1039, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (1040, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (1040, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (44245, 1040, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (44246, 1040, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (44247, 1040, 'arg_2', 'char', 0, 0, 1, 2);
@@ -6065,4 +6065,5 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'profiler') and name = 'getlimit';
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'wlc') and name in ('clock', 'tick');
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'wlr') and name in ('clock', 'tick');
+drop view sys.systemfunctions;
diff --git
a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64
--- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64
+++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64
@@ -2860,7 +2860,7 @@ insert into sys.args values (38629, 777,
insert into sys.functions values (778, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1,
false, false, false, 2000, true, false);
insert into sys.args values (38630, 778, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (38631, 778, 'arg_1', 'sec_interval', 13, 0, 1, 1);
-insert into sys.functions values (779, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (779, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (38632, 779, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (38633, 779, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (38634, 779, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3081,7 +3081,7 @@ insert into sys.args values (38794, 833,
insert into sys.args values (38795, 833, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38796, 833, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38797, 833, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (834, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (834, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (38798, 834, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (38799, 834, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (38800, 834, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3302,7 +3302,7 @@ insert into sys.args values (38960, 888,
insert into sys.args values (38961, 888, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38962, 888, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38963, 888, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (889, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (889, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (38964, 889, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (38965, 889, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (38966, 889, 'arg_2', 'char', 0, 0, 1, 2);
@@ -5470,4 +5470,5 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'profiler') and name = 'getlimit';
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'wlc') and name in ('clock', 'tick');
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'wlr') and name in ('clock', 'tick');
+drop view sys.systemfunctions;
diff --git
a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
---
a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
+++
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
@@ -3455,7 +3455,7 @@ insert into sys.args values (39073, 928,
insert into sys.functions values (929, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1,
false, false, false, 2000, true, false);
insert into sys.args values (39074, 929, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (39075, 929, 'arg_1', 'sec_interval', 13, 0, 1, 1);
-insert into sys.functions values (930, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (930, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (39076, 930, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (39077, 930, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (39078, 930, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3676,7 +3676,7 @@ insert into sys.args values (39238, 984,
insert into sys.args values (39239, 984, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (39240, 984, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (39241, 984, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (985, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (985, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (39242, 985, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (39243, 985, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (39244, 985, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3897,7 +3897,7 @@ insert into sys.args values (39404, 1039
insert into sys.args values (39405, 1039, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (39406, 1039, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (39407, 1039, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (1040, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (1040, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (39408, 1040, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (39409, 1040, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (39410, 1040, 'arg_2', 'char', 0, 0, 1, 2);
@@ -6136,4 +6136,5 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'profiler') and name = 'getlimit';
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'wlc') and name in ('clock', 'tick');
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'wlr') and name in ('clock', 'tick');
+drop view sys.systemfunctions;
diff --git
a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
@@ -3455,7 +3455,7 @@ insert into sys.args values (42041, 928,
insert into sys.functions values (929, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1,
false, false, false, 2000, true, false);
insert into sys.args values (42042, 929, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (42043, 929, 'arg_1', 'sec_interval', 13, 0, 1, 1);
-insert into sys.functions values (930, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (930, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (42044, 930, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (42045, 930, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (42046, 930, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3676,7 +3676,7 @@ insert into sys.args values (42206, 984,
insert into sys.args values (42207, 984, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (42208, 984, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (42209, 984, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (985, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (985, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (42210, 985, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (42211, 985, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (42212, 985, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3897,7 +3897,7 @@ insert into sys.args values (42372, 1039
insert into sys.args values (42373, 1039, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (42374, 1039, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (42375, 1039, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (1040, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (1040, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (42376, 1040, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (42377, 1040, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (42378, 1040, 'arg_2', 'char', 0, 0, 1, 2);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
