Changeset: 457d039a375d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/457d039a375d
Removed Files:
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
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-previous-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
Modified Files:
sql/backends/monet5/sql_upgrades.c
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-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade/Tests/upgrade.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:
Merge with Sep2022 branch.
diffs (truncated from 73256 to 300 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -137,7 +137,7 @@ sql_fix_system_tables(Client c, mvc *sql
}
assert(pos < bufsize);
- printf("Running database upgrade commands:\n%s\n", buf);
+ printf("Running database upgrade commands to update system
tables.\n\n");
err = SQLstatementIntern(c, buf, "update", true, false, NULL);
GDKfree(buf);
return err; /* usually MAL_SUCCEED */
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
@@ -1,2952 +1,4 @@
-Running database upgrade commands:
-delete from sys.dependencies where id < 2000;
-delete from sys.types where id < 2000;
-insert into sys.types values (1, 'void', 'any', 0, 0, 0, 0, 2000);
-insert into sys.types values (2, 'bat', 'table', 0, 0, 0, 1, 2000);
-insert into sys.types values (3, 'ptr', 'ptr', 0, 0, 0, 1, 2000);
-insert into sys.types values (4, 'bit', 'boolean', 1, 0, 2, 2, 2000);
-insert into sys.types values (5, 'str', 'clob', 0, 0, 0, 4, 2000);
-insert into sys.types values (6, 'str', 'varchar', 0, 0, 0, 4, 2000);
-insert into sys.types values (7, 'str', 'char', 0, 0, 0, 3, 2000);
-insert into sys.types values (8, 'oid', 'oid', 63, 0, 2, 6, 2000);
-insert into sys.types values (9, 'bte', 'tinyint', 8, 1, 2, 7, 2000);
-insert into sys.types values (10, 'sht', 'smallint', 16, 1, 2, 7, 2000);
-insert into sys.types values (11, 'int', 'int', 32, 1, 2, 7, 2000);
-insert into sys.types values (12, 'lng', 'bigint', 64, 1, 2, 7, 2000);
-insert into sys.types values (13, 'hge', 'hugeint', 128, 1, 2, 7, 2000);
-insert into sys.types values (14, 'bte', 'decimal', 2, 1, 10, 10, 2000);
-insert into sys.types values (15, 'sht', 'decimal', 4, 1, 10, 10, 2000);
-insert into sys.types values (16, 'int', 'decimal', 9, 1, 10, 10, 2000);
-insert into sys.types values (17, 'lng', 'decimal', 18, 1, 10, 10, 2000);
-insert into sys.types values (18, 'hge', 'decimal', 38, 1, 10, 10, 2000);
-insert into sys.types values (19, 'flt', 'real', 24, 2, 2, 11, 2000);
-insert into sys.types values (20, 'dbl', 'double', 53, 2, 2, 11, 2000);
-insert into sys.types values (21, 'int', 'month_interval', 3, 0, 10, 8, 2000);
-insert into sys.types values (22, 'lng', 'day_interval', 4, 0, 10, 9, 2000);
-insert into sys.types values (23, 'lng', 'sec_interval', 13, 1, 10, 9, 2000);
-insert into sys.types values (24, 'daytime', 'time', 7, 0, 0, 12, 2000);
-insert into sys.types values (25, 'daytime', 'timetz', 7, 1, 0, 13, 2000);
-insert into sys.types values (26, 'date', 'date', 0, 0, 0, 14, 2000);
-insert into sys.types values (27, 'timestamp', 'timestamp', 7, 0, 0, 15, 2000);
-insert into sys.types values (28, 'timestamp', 'timestamptz', 7, 1, 0, 16,
2000);
-insert into sys.types values (29, 'blob', 'blob', 0, 0, 0, 5, 2000);
-insert into sys.types values (32, 'wkb', 'geometry', 0, 0, 0, 17, 2000);
-insert into sys.types values (33, 'wkba', 'geometrya', 0, 0, 0, 18, 2000);
-insert into sys.types values (34, 'mbr', 'mbr', 0, 0, 0, 18, 2000);
-delete from sys.functions where id < 2000;
-delete from sys.args where func_id not in (select id from sys.functions);
-insert into sys.functions values (30, 'length', 'nitems', 'blob', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (48547, 30, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (48548, 30, 'arg_1', 'blob', 0, 0, 1, 1);
-insert into sys.functions values (31, 'octet_length', 'nitems', 'blob', 0, 1,
false, false, false, 2000, true, false);
-insert into sys.args values (48549, 31, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (48550, 31, 'arg_1', 'blob', 0, 0, 1, 1);
-insert into sys.functions values (35, 'mbr_overlap', 'mbrOverlaps', 'geom', 0,
1, false, false, false, 2000, true, true);
-insert into sys.args values (48551, 35, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48552, 35, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48553, 35, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (36, 'mbr_overlap', 'mbrOverlaps', 'geom', 0,
1, false, false, false, 2000, true, true);
-insert into sys.args values (48554, 36, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48555, 36, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48556, 36, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (37, 'mbr_above', 'mbrAbove', 'geom', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48557, 37, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48558, 37, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48559, 37, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (38, 'mbr_above', 'mbrAbove', 'geom', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48560, 38, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48561, 38, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48562, 38, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (39, 'mbr_below', 'mbrBelow', 'geom', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48563, 39, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48564, 39, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48565, 39, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (40, 'mbr_below', 'mbrBelow', 'geom', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48566, 40, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48567, 40, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48568, 40, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (41, 'mbr_right', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48569, 41, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48570, 41, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48571, 41, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (42, 'mbr_right', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48572, 42, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48573, 42, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48574, 42, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (43, 'mbr_left', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48575, 43, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48576, 43, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48577, 43, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (44, 'mbr_left', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48578, 44, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48579, 44, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48580, 44, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (45, 'mbr_overlap_or_above',
'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (48581, 45, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48582, 45, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48583, 45, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (46, 'mbr_overlap_or_above',
'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (48584, 46, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48585, 46, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48586, 46, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (47, 'mbr_overlap_or_below',
'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (48587, 47, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48588, 47, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48589, 47, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (48, 'mbr_overlap_or_below',
'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (48590, 48, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48591, 48, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48592, 48, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (49, 'mbr_overlap_or_right',
'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (48593, 49, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48594, 49, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48595, 49, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (50, 'mbr_overlap_or_right',
'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (48596, 50, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48597, 50, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48598, 50, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (51, 'mbr_overlap_or_left',
'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (48599, 51, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48600, 51, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48601, 51, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (52, 'mbr_overlap_or_left',
'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (48602, 52, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48603, 52, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48604, 52, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (53, 'mbr_contains', 'mbrContains', 'geom',
0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (48605, 53, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48606, 53, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48607, 53, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (54, 'mbr_contains', 'mbrContains', 'geom',
0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (48608, 54, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48609, 54, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48610, 54, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (55, 'mbr_contained', 'mbrContained', 'geom',
0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (48611, 55, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48612, 55, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48613, 55, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (56, 'mbr_contained', 'mbrContained', 'geom',
0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (48614, 56, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48615, 56, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48616, 56, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (57, 'mbr_equal', 'mbrEqual', 'geom', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48617, 57, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48618, 57, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48619, 57, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (58, 'mbr_equal', 'mbrEqual', 'geom', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48620, 58, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48621, 58, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48622, 58, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (59, 'mbr_distance', 'mbrDistance', 'geom',
0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (48623, 59, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (48624, 59, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48625, 59, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (60, 'mbr_distance', 'mbrDistance', 'geom',
0, 1, false, false, false, 2000, true, true);
-insert into sys.args values (48626, 60, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (48627, 60, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48628, 60, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (61, 'left_shift', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48629, 61, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48630, 61, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48631, 61, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (62, 'left_shift', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48632, 62, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48633, 62, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48634, 62, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (63, 'right_shift', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48635, 63, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48636, 63, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (48637, 63, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (64, 'right_shift', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48638, 64, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48639, 64, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (48640, 64, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (73, '=', '=', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (48641, 73, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48642, 73, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (48643, 73, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (74, '<>', '!=', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (48644, 74, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48645, 74, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (48646, 74, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (75, 'isnull', 'isnil', 'calc', 0, 1, false,
false, false, 2000, true, true);
-insert into sys.args values (48647, 75, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48648, 75, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (76, 'isnotnull', 'isnotnil', 'calc', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48649, 76, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48650, 76, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (77, '>', '>', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (48651, 77, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48652, 77, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (48653, 77, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (78, '>=', '>=', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (48654, 78, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48655, 78, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (48656, 78, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (79, '<', '<', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (48657, 79, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48658, 79, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (48659, 79, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (80, '<=', '<=', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (48660, 80, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48661, 80, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (48662, 80, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (81, 'between', 'between', 'calc', 0, 1,
false, false, false, 2000, true, false);
-insert into sys.args values (48663, 81, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (48664, 81, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (48665, 81, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.args values (48666, 81, 'arg_3', 'any', 0, 0, 1, 3);
-insert into sys.args values (48667, 81, 'arg_4', 'boolean', 1, 0, 1, 4);
-insert into sys.args values (48668, 81, 'arg_5', 'boolean', 1, 0, 1, 5);
-insert into sys.args values (48669, 81, 'arg_6', 'boolean', 1, 0, 1, 6);
-insert into sys.args values (48670, 81, 'arg_7', 'boolean', 1, 0, 1, 7);
-insert into sys.args values (48671, 81, 'arg_8', 'boolean', 1, 0, 1, 8);
-insert into sys.functions values (100, 'min', 'min', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48672, 100, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (48673, 100, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (101, 'max', 'max', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48674, 101, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (48675, 101, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (102, 'sql_min', 'min', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (48676, 102, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (48677, 102, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (48678, 102, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (103, 'sql_max', 'max', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (48679, 103, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (48680, 103, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (48681, 103, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (104, 'least', 'min_no_nil', 'calc', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48682, 104, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (48683, 104, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (48684, 104, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (105, 'greatest', 'max_no_nil', 'calc', 0, 1,
false, false, false, 2000, true, true);
-insert into sys.args values (48685, 105, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (48686, 105, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (48687, 105, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (106, 'ifthenelse', 'ifthenelse', 'calc', 0,
1, false, false, false, 2000, true, true);
-insert into sys.args values (48688, 106, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (48689, 106, 'arg_1', 'boolean', 1, 0, 1, 1);
-insert into sys.args values (48690, 106, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.args values (48691, 106, 'arg_3', 'any', 0, 0, 1, 3);
-insert into sys.functions values (112, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48692, 112, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (48693, 112, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.functions values (113, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48694, 113, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (48695, 113, 'arg_1', 'smallint', 16, 0, 1, 1);
-insert into sys.functions values (114, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48696, 114, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (48697, 114, 'arg_1', 'int', 32, 0, 1, 1);
-insert into sys.functions values (115, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48698, 115, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (48699, 115, 'arg_1', 'hugeint', 128, 0, 1, 1);
-insert into sys.functions values (116, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48700, 116, 'res_0', 'bigint', 64, 0, 0, 0);
-insert into sys.args values (48701, 116, 'arg_1', 'bigint', 64, 0, 1, 1);
-insert into sys.functions values (117, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48702, 117, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (48703, 117, 'arg_1', 'decimal', 2, 0, 1, 1);
-insert into sys.functions values (118, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48704, 118, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (48705, 118, 'arg_1', 'decimal', 4, 0, 1, 1);
-insert into sys.functions values (119, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48706, 119, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (48707, 119, 'arg_1', 'decimal', 9, 0, 1, 1);
-insert into sys.functions values (120, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48708, 120, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (48709, 120, 'arg_1', 'decimal', 18, 0, 1, 1);
-insert into sys.functions values (121, 'sum', 'sum', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48710, 121, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (48711, 121, 'arg_1', 'decimal', 38, 0, 1, 1);
-insert into sys.functions values (122, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48712, 122, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (48713, 122, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.functions values (123, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48714, 123, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (48715, 123, 'arg_1', 'smallint', 16, 0, 1, 1);
-insert into sys.functions values (124, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48716, 124, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (48717, 124, 'arg_1', 'int', 32, 0, 1, 1);
-insert into sys.functions values (125, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48718, 125, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (48719, 125, 'arg_1', 'bigint', 64, 0, 1, 1);
-insert into sys.functions values (126, 'prod', 'prod', 'aggr', 0, 3, false,
false, false, 2000, true, false);
-insert into sys.args values (48720, 126, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (48721, 126, 'arg_1', 'hugeint', 128, 0, 1, 1);
-insert into sys.functions values (127, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (48722, 127, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (48723, 127, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.args values (48724, 127, 'arg_2', 'tinyint', 8, 0, 1, 2);
-insert into sys.functions values (128, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
-insert into sys.args values (48725, 128, 'res_0', 'smallint', 16, 0, 0, 0);
-insert into sys.args values (48726, 128, 'arg_1', 'smallint', 16, 0, 1, 1);
-insert into sys.args values (48727, 128, 'arg_2', 'smallint', 16, 0, 1, 2);
-insert into sys.functions values (129, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true, false);
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
