Changeset: 58bc75c01139 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/58bc75c01139
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/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.stable.out
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/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: default
Log Message:
Approvals.
diffs (truncated from 536 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
@@ -3455,7 +3455,7 @@ insert into sys.args values (43915, 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 (43916, 929, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (43917, 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 (43918, 930, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (43919, 930, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (43920, 930, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3676,7 +3676,7 @@ insert into sys.args values (44080, 984,
insert into sys.args values (44081, 984, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (44082, 984, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (44083, 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 (44084, 985, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (44085, 985, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (44086, 985, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3897,7 +3897,7 @@ insert into sys.args values (44246, 1039
insert into sys.args values (44247, 1039, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (44248, 1039, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (44249, 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 (44250, 1040, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (44251, 1040, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (44252, 1040, 'arg_2', 'char', 0, 0, 1, 2);
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
@@ -2860,7 +2860,7 @@ insert into sys.args values (38634, 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 (38635, 778, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (38636, 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 (38637, 779, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (38638, 779, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (38639, 779, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3081,7 +3081,7 @@ insert into sys.args values (38799, 833,
insert into sys.args values (38800, 833, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38801, 833, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38802, 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 (38803, 834, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (38804, 834, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (38805, 834, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3302,7 +3302,7 @@ insert into sys.args values (38965, 888,
insert into sys.args values (38966, 888, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38967, 888, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38968, 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 (38969, 889, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (38970, 889, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (38971, 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.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
@@ -3455,7 +3455,7 @@ insert into sys.args values (39078, 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 (39079, 929, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (39080, 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 (39081, 930, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (39082, 930, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (39083, 930, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3676,7 +3676,7 @@ insert into sys.args values (39243, 984,
insert into sys.args values (39244, 984, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (39245, 984, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (39246, 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 (39247, 985, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (39248, 985, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (39249, 985, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3897,7 +3897,7 @@ insert into sys.args values (39409, 1039
insert into sys.args values (39410, 1039, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (39411, 1039, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (39412, 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 (39413, 1040, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (39414, 1040, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (39415, 1040, 'arg_2', 'char', 0, 0, 1, 2);
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
@@ -3455,7 +3455,7 @@ insert into sys.args values (10683, 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 (10684, 929, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (10685, 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 (10686, 930, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (10687, 930, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (10688, 930, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3676,7 +3676,7 @@ insert into sys.args values (10848, 984,
insert into sys.args values (10849, 984, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (10850, 984, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (10851, 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 (10852, 985, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (10853, 985, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (10854, 985, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3897,7 +3897,7 @@ insert into sys.args values (11014, 1039
insert into sys.args values (11015, 1039, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (11016, 1039, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (11017, 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 (11018, 1040, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (11019, 1040, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (11020, 1040, 'arg_2', 'char', 0, 0, 1, 2);
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
@@ -2860,7 +2860,7 @@ insert into sys.args values (9681, 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 (9682, 778, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (9683, 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 (9684, 779, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (9685, 779, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (9686, 779, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3081,7 +3081,7 @@ insert into sys.args values (9846, 833,
insert into sys.args values (9847, 833, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (9848, 833, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (9849, 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 (9850, 834, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (9851, 834, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (9852, 834, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3302,7 +3302,7 @@ insert into sys.args values (10012, 888,
insert into sys.args values (10013, 888, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (10014, 888, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (10015, 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 (10016, 889, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (10017, 889, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (10018, 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/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
@@ -3455,7 +3455,7 @@ insert into sys.args values (10125, 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 (10126, 929, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (10127, 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 (10128, 930, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (10129, 930, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (10130, 930, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3676,7 +3676,7 @@ insert into sys.args values (10290, 984,
insert into sys.args values (10291, 984, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (10292, 984, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (10293, 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 (10294, 985, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (10295, 985, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (10296, 985, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3897,7 +3897,7 @@ insert into sys.args values (10456, 1039
insert into sys.args values (10457, 1039, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (10458, 1039, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (10459, 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 (10460, 1040, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (10461, 1040, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (10462, 1040, 'arg_2', 'char', 0, 0, 1, 2);
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
@@ -3455,7 +3455,7 @@ insert into sys.args values (42046, 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 (42047, 929, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (42048, 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 (42049, 930, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (42050, 930, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (42051, 930, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3676,7 +3676,7 @@ insert into sys.args values (42211, 984,
insert into sys.args values (42212, 984, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (42213, 984, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (42214, 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 (42215, 985, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (42216, 985, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (42217, 985, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3897,7 +3897,7 @@ insert into sys.args values (42377, 1039
insert into sys.args values (42378, 1039, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (42379, 1039, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (42380, 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 (42381, 1040, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (42382, 1040, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (42383, 1040, 'arg_2', 'char', 0, 0, 1, 2);
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
@@ -3455,7 +3455,7 @@ insert into sys.args values (10261, 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 (10262, 929, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (10263, 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 (10264, 930, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (10265, 930, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (10266, 930, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3676,7 +3676,7 @@ insert into sys.args values (10426, 984,
insert into sys.args values (10427, 984, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (10428, 984, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (10429, 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 (10430, 985, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (10431, 985, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (10432, 985, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3897,7 +3897,7 @@ insert into sys.args values (10592, 1039
insert into sys.args values (10593, 1039, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (10594, 1039, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (10595, 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 (10596, 1040, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (10597, 1040, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (10598, 1040, 'arg_2', 'char', 0, 0, 1, 2);
diff --git a/sql/test/emptydb/Tests/check.stable.out
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -3396,9 +3396,9 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "network", "SYSTEM", "create
function \"network\" (p inet) returns inet external name inet.\"network\";",
"inet", "MAL", "Scalar function", false, false, false, true,
"result", "inet", 0, 0, "out", "p", "inet", 0, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "sys", "newurl", "SYSTEM", "create
function newurl(protocol string, hostname string, \"port\" int, file string)
returns url external name url.\"new\";", "url", "MAL", "Scalar function",
false, false, false, true, "result", "url", 0, 0,
"out", "protocol", "clob", 0, 0, "in", "hostname", "clob",
0, 0, "in", "port", "int", 32, 0, "in", "file", "clob",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "newurl", "SYSTEM", "create
function newurl(protocol string, hostname string, file string) returns url
external name url.\"new\";", "url", "MAL", "Scalar function", false,
false, false, true, "result", "url", 0, 0, "out",
"protocol", "clob", 0, 0, "in", "hostname", "clob", 0,
0, "in", "file", "clob", 0, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "next_value_for", "SYSTEM",
"next_value", "sql", "Internal C", "Scalar function", false, false,
false, true, "res_0", "bigint", 64, 0, "out",
"arg_1", "char", 0, 0, "in", "arg_2", "char", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "next_value_for", "SYSTEM",
"next_value", "sql", "Internal C", "Scalar function", false, false,
false, true, "res_0", "bigint", 64, 0, "out",
"arg_1", "clob", 0, 0, "in", "arg_2", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "next_value_for", "SYSTEM",
"next_value", "sql", "Internal C", "Scalar function", false, false,
false, true, "res_0", "bigint", 64, 0, "out",
"arg_1", "varchar", 0, 0, "in", "arg_2",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
+[ "sys.functions", "sys", "next_value_for", "SYSTEM",
"next_value", "sql", "Internal C", "Scalar function", true, false,
false, true, "res_0", "bigint", 64, 0, "out",
"arg_1", "char", 0, 0, "in", "arg_2", "char", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "next_value_for", "SYSTEM",
"next_value", "sql", "Internal C", "Scalar function", true, false,
false, true, "res_0", "bigint", 64, 0, "out",
"arg_1", "clob", 0, 0, "in", "arg_2", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "next_value_for", "SYSTEM",
"next_value", "sql", "Internal C", "Scalar function", true, false,
false, true, "res_0", "bigint", 64, 0, "out",
"arg_1", "varchar", 0, 0, "in", "arg_2",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "not", "SYSTEM", "not", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "boolean", 1, 0, "out", "arg_1",
"boolean", 1, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "not_exist", "SYSTEM", "not_exist",
"aggr", "Internal C", "Aggregate function", false, false, false, true,
"res_0", "boolean", 1, 0, "out", "arg_1", "any",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "not_like", "SYSTEM", "not_like",
"algebra", "Internal C", "Filter function", false, false, false,
false, "res_0", "boolean", 1, 0, "out", "arg_1",
"char", 0, 0, "in", "arg_2", "char", 0, 0, "in",
"arg_3", "char", 0, 0, "in", "arg_4", "boolean",
1, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.int128
b/sql/test/emptydb/Tests/check.stable.out.int128
--- a/sql/test/emptydb/Tests/check.stable.out.int128
+++ b/sql/test/emptydb/Tests/check.stable.out.int128
@@ -3450,9 +3450,9 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "network", "SYSTEM", "create
function \"network\" (p inet) returns inet external name inet.\"network\";",
"inet", "MAL", "Scalar function", false, false, false, true,
"result", "inet", 0, 0, "out", "p", "inet", 0, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "sys", "newurl", "SYSTEM", "create
function newurl(protocol string, hostname string, \"port\" int, file string)
returns url external name url.\"new\";", "url", "MAL", "Scalar function",
false, false, false, true, "result", "url", 0, 0,
"out", "protocol", "clob", 0, 0, "in", "hostname", "clob",
0, 0, "in", "port", "int", 32, 0, "in", "file", "clob",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "newurl", "SYSTEM", "create
function newurl(protocol string, hostname string, file string) returns url
external name url.\"new\";", "url", "MAL", "Scalar function", false,
false, false, true, "result", "url", 0, 0, "out",
"protocol", "clob", 0, 0, "in", "hostname", "clob", 0,
0, "in", "file", "clob", 0, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "next_value_for", "SYSTEM",
"next_value", "sql", "Internal C", "Scalar function", false, false,
false, true, "res_0", "bigint", 64, 0, "out",
"arg_1", "char", 0, 0, "in", "arg_2", "char", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "next_value_for", "SYSTEM",
"next_value", "sql", "Internal C", "Scalar function", false, false,
false, true, "res_0", "bigint", 64, 0, "out",
"arg_1", "clob", 0, 0, "in", "arg_2", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "next_value_for", "SYSTEM",
"next_value", "sql", "Internal C", "Scalar function", false, false,
false, true, "res_0", "bigint", 64, 0, "out",
"arg_1", "varchar", 0, 0, "in", "arg_2",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
+[ "sys.functions", "sys", "next_value_for", "SYSTEM",
"next_value", "sql", "Internal C", "Scalar function", true, false,
false, true, "res_0", "bigint", 64, 0, "out",
"arg_1", "char", 0, 0, "in", "arg_2", "char", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "next_value_for", "SYSTEM",
"next_value", "sql", "Internal C", "Scalar function", true, false,
false, true, "res_0", "bigint", 64, 0, "out",
"arg_1", "clob", 0, 0, "in", "arg_2", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "next_value_for", "SYSTEM",
"next_value", "sql", "Internal C", "Scalar function", true, false,
false, true, "res_0", "bigint", 64, 0, "out",
"arg_1", "varchar", 0, 0, "in", "arg_2",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "not", "SYSTEM", "not", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "boolean", 1, 0, "out", "arg_1",
"boolean", 1, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "not_exist", "SYSTEM", "not_exist",
"aggr", "Internal C", "Aggregate function", false, false, false, true,
"res_0", "boolean", 1, 0, "out", "arg_1", "any",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "not_like", "SYSTEM", "not_like",
"algebra", "Internal C", "Filter function", false, false, false,
false, "res_0", "boolean", 1, 0, "out", "arg_1",
"char", 0, 0, "in", "arg_2", "char", 0, 0, "in",
"arg_3", "char", 0, 0, "in", "arg_4", "boolean",
1, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
diff --git
a/sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -3455,7 +3455,7 @@ insert into sys.args values (44217, 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 (44218, 929, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (44219, 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 (44220, 930, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (44221, 930, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (44222, 930, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3676,7 +3676,7 @@ insert into sys.args values (44382, 984,
insert into sys.args values (44383, 984, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (44384, 984, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (44385, 984, 'arg_5', 'int', 32, 0, 1, 5);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
