Changeset: 25fed9b645cb for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/25fed9b645cb
Modified Files:
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb/Tests/check.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
Branch: default
Log Message:
32 bit upgrade approvals.
diffs (truncated from 14459 to 300 lines):
diff --git
a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -5202,6 +5202,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
diff --git a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit
@@ -5202,6 +5202,12 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+CREATE FILTER FUNCTION sys.strimp_filter(strs STRING, q STRING) EXTERNAL NAME
strimps.strimpfilter;
+GRANT EXECUTE ON FILTER FUNCTION sys.strimp_filter TO PUBLIC;
+CREATE PROCEDURE sys.strimp_create(sch string, tab string, col string)
+ EXTERNAL NAME sql.createstrimps;
+update sys.functions set system = true where system <> true and name =
'strimp_filter' and schema_id = 2000 and type = 4;
+update sys.functions set system = true where system <> true and name =
'strimp_create' and schema_id = 2000 and type = 2;
drop view logging.compinfo;
drop function logging.compinfo;
drop procedure sys.storagemodelinit();
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
@@ -1,3 +1,3563 @@
+Running database upgrade commands:
+set schema "sys";
+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', 31, 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, 'bte', 'decimal', 2, 1, 10, 10, 2000);
+insert into sys.types values (14, 'sht', 'decimal', 4, 1, 10, 10, 2000);
+insert into sys.types values (15, 'int', 'decimal', 9, 1, 10, 10, 2000);
+insert into sys.types values (16, 'lng', 'decimal', 18, 1, 10, 10, 2000);
+insert into sys.types values (17, 'flt', 'real', 24, 2, 2, 11, 2000);
+insert into sys.types values (18, 'dbl', 'double', 53, 2, 2, 11, 2000);
+insert into sys.types values (19, 'int', 'month_interval', 3, 0, 10, 8, 2000);
+insert into sys.types values (20, 'lng', 'day_interval', 4, 0, 10, 9, 2000);
+insert into sys.types values (21, 'lng', 'sec_interval', 13, 1, 10, 9, 2000);
+insert into sys.types values (22, 'daytime', 'time', 7, 0, 0, 12, 2000);
+insert into sys.types values (23, 'daytime', 'timetz', 7, 1, 0, 13, 2000);
+insert into sys.types values (24, 'date', 'date', 0, 0, 0, 14, 2000);
+insert into sys.types values (25, 'timestamp', 'timestamp', 7, 0, 0, 15, 2000);
+insert into sys.types values (26, 'timestamp', 'timestamptz', 7, 1, 0, 16,
2000);
+insert into sys.types values (27, 'blob', 'blob', 0, 0, 0, 5, 2000);
+insert into sys.types values (30, 'wkb', 'geometry', 0, 0, 0, 17, 2000);
+insert into sys.types values (31, 'wkba', 'geometrya', 0, 0, 0, 18, 2000);
+insert into sys.types values (32, '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 (28, 'length', 'nitems', 'blob', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (39527, 28, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (39528, 28, 'arg_1', 'blob', 0, 0, 1, 1);
+insert into sys.functions values (29, 'octet_length', 'nitems', 'blob', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.args values (39529, 29, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (39530, 29, 'arg_1', 'blob', 0, 0, 1, 1);
+insert into sys.functions values (33, 'mbr_overlap', 'mbrOverlaps', 'geom', 0,
1, false, false, false, 2000, true, true);
+insert into sys.args values (39531, 33, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39532, 33, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39533, 33, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (34, 'mbr_overlap', 'mbrOverlaps', 'geom', 0,
1, false, false, false, 2000, true, true);
+insert into sys.args values (39534, 34, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39535, 34, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39536, 34, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (35, 'mbr_above', 'mbrAbove', 'geom', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39537, 35, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39538, 35, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39539, 35, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (36, 'mbr_above', 'mbrAbove', 'geom', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39540, 36, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39541, 36, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39542, 36, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (37, 'mbr_below', 'mbrBelow', 'geom', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39543, 37, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39544, 37, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39545, 37, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (38, 'mbr_below', 'mbrBelow', 'geom', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39546, 38, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39547, 38, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39548, 38, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (39, 'mbr_right', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39549, 39, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39550, 39, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39551, 39, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (40, 'mbr_right', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39552, 40, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39553, 40, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39554, 40, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (41, 'mbr_left', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39555, 41, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39556, 41, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39557, 41, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (42, 'mbr_left', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39558, 42, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39559, 42, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39560, 42, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (43, 'mbr_overlap_or_above',
'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39561, 43, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39562, 43, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39563, 43, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (44, 'mbr_overlap_or_above',
'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39564, 44, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39565, 44, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39566, 44, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (45, 'mbr_overlap_or_below',
'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39567, 45, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39568, 45, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39569, 45, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (46, 'mbr_overlap_or_below',
'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39570, 46, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39571, 46, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39572, 46, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (47, 'mbr_overlap_or_right',
'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39573, 47, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39574, 47, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39575, 47, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (48, 'mbr_overlap_or_right',
'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39576, 48, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39577, 48, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39578, 48, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (49, 'mbr_overlap_or_left',
'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39579, 49, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39580, 49, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39581, 49, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (50, 'mbr_overlap_or_left',
'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39582, 50, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39583, 50, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39584, 50, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (51, 'mbr_contains', 'mbrContains', 'geom',
0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39585, 51, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39586, 51, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39587, 51, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (52, 'mbr_contains', 'mbrContains', 'geom',
0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39588, 52, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39589, 52, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39590, 52, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (53, 'mbr_contained', 'mbrContained', 'geom',
0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39591, 53, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39592, 53, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39593, 53, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (54, 'mbr_contained', 'mbrContained', 'geom',
0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39594, 54, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39595, 54, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39596, 54, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (55, 'mbr_equal', 'mbrEqual', 'geom', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39597, 55, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39598, 55, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39599, 55, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (56, 'mbr_equal', 'mbrEqual', 'geom', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39600, 56, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39601, 56, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39602, 56, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (57, 'mbr_distance', 'mbrDistance', 'geom',
0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39603, 57, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (39604, 57, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39605, 57, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (58, 'mbr_distance', 'mbrDistance', 'geom',
0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39606, 58, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (39607, 58, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39608, 58, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (59, 'left_shift', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39609, 59, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39610, 59, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39611, 59, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (60, 'left_shift', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39612, 60, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39613, 60, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39614, 60, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (61, 'right_shift', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39615, 61, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39616, 61, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (39617, 61, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (62, 'right_shift', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39618, 62, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39619, 62, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (39620, 62, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (63, 'grouping', '', '', 0, 3, false, false,
false, 2000, true, true);
+insert into sys.args values (39621, 63, 'res_0', 'tinyint', 8, 0, 0, 0);
+insert into sys.args values (39622, 63, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (64, 'grouping', '', '', 0, 3, false, false,
false, 2000, true, true);
+insert into sys.args values (39623, 64, 'res_0', 'smallint', 16, 0, 0, 0);
+insert into sys.args values (39624, 64, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (65, 'grouping', '', '', 0, 3, false, false,
false, 2000, true, true);
+insert into sys.args values (39625, 65, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (39626, 65, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (66, 'grouping', '', '', 0, 3, false, false,
false, 2000, true, true);
+insert into sys.args values (39627, 66, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (39628, 66, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (67, 'not_unique', 'not_unique', 'aggr', 0,
3, false, false, false, 2000, true, true);
+insert into sys.args values (39629, 67, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39630, 67, 'arg_1', 'oid', 31, 0, 1, 1);
+insert into sys.functions values (68, 'hash', 'hash', 'mkey', 0, 1, false,
false, false, 2000, true, true);
+insert into sys.args values (39631, 68, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (39632, 68, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (69, 'rotate_xor_hash', 'rotate_xor_hash',
'calc', 0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39633, 69, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (39634, 69, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.args values (39635, 69, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.args values (39636, 69, 'arg_3', 'any', 0, 0, 1, 3);
+insert into sys.functions values (70, '=', '=', 'calc', 0, 1, false, false,
false, 2000, true, false);
+insert into sys.args values (39637, 70, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39638, 70, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (39639, 70, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (71, '<>', '!=', 'calc', 0, 1, false, false,
false, 2000, true, false);
+insert into sys.args values (39640, 71, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39641, 71, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (39642, 71, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (72, 'isnull', 'isnil', 'calc', 0, 1, false,
false, false, 2000, true, true);
+insert into sys.args values (39643, 72, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39644, 72, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (73, 'isnotnull', 'isnotnil', 'calc', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (39645, 73, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39646, 73, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (74, '>', '>', 'calc', 0, 1, false, false,
false, 2000, true, false);
+insert into sys.args values (39647, 74, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39648, 74, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (39649, 74, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (75, '>=', '>=', 'calc', 0, 1, false, false,
false, 2000, true, false);
+insert into sys.args values (39650, 75, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39651, 75, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (39652, 75, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (76, '<', '<', 'calc', 0, 1, false, false,
false, 2000, true, false);
+insert into sys.args values (39653, 76, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39654, 76, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (39655, 76, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (77, '<=', '<=', 'calc', 0, 1, false, false,
false, 2000, true, false);
+insert into sys.args values (39656, 77, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39657, 77, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (39658, 77, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (78, 'between', 'between', 'calc', 0, 1,
false, false, false, 2000, true, false);
+insert into sys.args values (39659, 78, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39660, 78, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (39661, 78, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.args values (39662, 78, 'arg_3', 'any', 0, 0, 1, 3);
+insert into sys.args values (39663, 78, 'arg_4', 'boolean', 1, 0, 1, 4);
+insert into sys.args values (39664, 78, 'arg_5', 'boolean', 1, 0, 1, 5);
+insert into sys.args values (39665, 78, 'arg_6', 'boolean', 1, 0, 1, 6);
+insert into sys.args values (39666, 78, 'arg_7', 'boolean', 1, 0, 1, 7);
+insert into sys.args values (39667, 78, 'arg_8', 'boolean', 1, 0, 1, 8);
+insert into sys.functions values (79, 'zero_or_one', 'zero_or_one', 'aggr', 0,
3, false, false, false, 2000, true, true);
+insert into sys.args values (39668, 79, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (39669, 79, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (80, 'all', 'all', 'aggr', 0, 3, false,
false, false, 2000, true, true);
+insert into sys.args values (39670, 80, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (39671, 80, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (81, 'null', 'null', 'aggr', 0, 3, false,
false, false, 2000, true, true);
+insert into sys.args values (39672, 81, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39673, 81, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (82, 'any', 'any', 'sql', 0, 1, false, false,
false, 2000, true, true);
+insert into sys.args values (39674, 82, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39675, 82, 'arg_1', 'boolean', 1, 0, 1, 1);
+insert into sys.args values (39676, 82, 'arg_2', 'boolean', 1, 0, 1, 2);
+insert into sys.args values (39677, 82, 'arg_3', 'boolean', 1, 0, 1, 3);
+insert into sys.functions values (83, 'all', 'all', 'sql', 0, 1, false, false,
false, 2000, true, true);
+insert into sys.args values (39678, 83, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39679, 83, 'arg_1', 'boolean', 1, 0, 1, 1);
+insert into sys.args values (39680, 83, 'arg_2', 'boolean', 1, 0, 1, 2);
+insert into sys.args values (39681, 83, 'arg_3', 'boolean', 1, 0, 1, 3);
+insert into sys.functions values (84, 'anyequal', 'anyequal', 'aggr', 0, 3,
false, false, false, 2000, true, true);
+insert into sys.args values (39682, 84, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39683, 84, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (85, 'allnotequal', 'allnotequal', 'aggr', 0,
3, false, false, false, 2000, true, true);
+insert into sys.args values (39684, 85, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39685, 85, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (86, 'sql_anyequal', 'anyequal', 'aggr', 0,
1, false, false, false, 2000, true, true);
+insert into sys.args values (39686, 86, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39687, 86, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (39688, 86, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (87, 'sql_not_anyequal', 'not_anyequal',
'aggr', 0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (39689, 87, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39690, 87, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (39691, 87, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (88, 'exist', 'exist', 'aggr', 0, 3, false,
false, false, 2000, true, true);
+insert into sys.args values (39692, 88, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39693, 88, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (89, 'not_exist', 'not_exist', 'aggr', 0, 3,
false, false, false, 2000, true, true);
+insert into sys.args values (39694, 89, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (39695, 89, 'arg_1', 'any', 0, 0, 1, 1);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
