Changeset: f0927112f272 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f0927112f272 Modified Files: sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/emptydb-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:
Approve upgrades on 32 bits. diffs (truncated from 20444 to 300 lines): 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 @@ -16,6 +16,5107 @@ stdout of test 'upgrade` in directory 's # Listening for connection requests on mapi:monetdb://madrid.da.cwi.nl:39660/ # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-30908/.s.monetdb.39660 # MonetDB/GIS module loaded +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 (0, 'void', 'any', 0, 0, 0, 0, 2000); +insert into sys.types values (1, 'bat', 'table', 0, 0, 0, 1, 2000); +insert into sys.types values (2, 'ptr', 'ptr', 0, 0, 0, 1, 2000); +insert into sys.types values (3, 'bit', 'boolean', 1, 0, 2, 2, 2000); +insert into sys.types values (4, 'str', 'char', 0, 0, 0, 3, 2000); +insert into sys.types values (5, 'str', 'varchar', 0, 0, 0, 4, 2000); +insert into sys.types values (6, 'str', 'clob', 0, 0, 0, 4, 2000); +insert into sys.types values (7, 'oid', 'oid', 31, 0, 2, 6, 2000); +insert into sys.types values (8, 'bte', 'tinyint', 8, 1, 2, 7, 2000); +insert into sys.types values (9, 'sht', 'smallint', 16, 1, 2, 7, 2000); +insert into sys.types values (10, 'int', 'int', 32, 1, 2, 7, 2000); +insert into sys.types values (11, 'lng', 'bigint', 64, 1, 2, 7, 2000); +insert into sys.types values (12, 'bte', 'decimal', 2, 1, 10, 10, 2000); +insert into sys.types values (13, 'sht', 'decimal', 4, 1, 10, 10, 2000); +insert into sys.types values (14, 'int', 'decimal', 9, 1, 10, 10, 2000); +insert into sys.types values (15, 'lng', 'decimal', 18, 1, 10, 10, 2000); +insert into sys.types values (16, 'flt', 'real', 24, 2, 2, 11, 2000); +insert into sys.types values (17, 'dbl', 'double', 53, 2, 2, 11, 2000); +insert into sys.types values (18, 'int', 'month_interval', 32, 0, 2, 8, 2000); +insert into sys.types values (19, 'lng', 'sec_interval', 13, 1, 10, 9, 2000); +insert into sys.types values (20, 'daytime', 'time', 7, 0, 0, 12, 2000); +insert into sys.types values (21, 'daytime', 'timetz', 7, 1, 0, 12, 2000); +insert into sys.types values (22, 'date', 'date', 0, 0, 0, 13, 2000); +insert into sys.types values (23, 'timestamp', 'timestamp', 7, 0, 0, 14, 2000); +insert into sys.types values (24, 'timestamp', 'timestamptz', 7, 1, 0, 14, 2000); +insert into sys.types values (25, 'blob', 'blob', 0, 0, 0, 5, 2000); +insert into sys.types values (28, 'wkb', 'geometry', 0, 0, 0, 15, 2000); +insert into sys.types values (29, 'wkba', 'geometrya', 0, 0, 0, 16, 2000); +insert into sys.types values (30, 'mbr', 'mbr', 0, 0, 0, 16, 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 (26, 'length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22529, 26, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (22530, 26, 'arg_1', 'blob', 0, 0, 1, 1); +insert into sys.functions values (27, 'octet_length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22531, 27, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (22532, 27, 'arg_1', 'blob', 0, 0, 1, 1); +insert into sys.functions values (31, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22533, 31, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22534, 31, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22535, 31, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (32, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22536, 32, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22537, 32, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22538, 32, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (33, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22539, 33, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22540, 33, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22541, 33, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (34, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22542, 34, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22543, 34, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22544, 34, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (35, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22545, 35, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22546, 35, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22547, 35, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (36, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22548, 36, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22549, 36, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22550, 36, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (37, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22551, 37, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22552, 37, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22553, 37, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (38, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22554, 38, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22555, 38, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22556, 38, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (39, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22557, 39, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22558, 39, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22559, 39, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (40, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22560, 40, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22561, 40, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22562, 40, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (41, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22563, 41, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22564, 41, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22565, 41, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (42, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22566, 42, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22567, 42, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22568, 42, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (43, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22569, 43, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22570, 43, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22571, 43, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (44, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22572, 44, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22573, 44, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22574, 44, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (45, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22575, 45, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22576, 45, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22577, 45, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (46, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22578, 46, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22579, 46, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22580, 46, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (47, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22581, 47, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22582, 47, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22583, 47, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (48, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22584, 48, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22585, 48, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22586, 48, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (49, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22587, 49, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22588, 49, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22589, 49, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (50, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22590, 50, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22591, 50, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22592, 50, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (51, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22593, 51, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22594, 51, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22595, 51, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (52, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22596, 52, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22597, 52, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22598, 52, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (53, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22599, 53, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22600, 53, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22601, 53, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (54, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22602, 54, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22603, 54, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22604, 54, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (55, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22605, 55, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (22606, 55, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22607, 55, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (56, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22608, 56, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (22609, 56, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22610, 56, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (57, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22611, 57, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22612, 57, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22613, 57, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (58, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22614, 58, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22615, 58, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22616, 58, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (59, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22617, 59, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22618, 59, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (22619, 59, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (60, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22620, 60, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22621, 60, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (22622, 60, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.functions values (62, 'not_uniques', 'not_uniques', 'sql', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22623, 62, 'res_0', 'oid', 31, 0, 0, 0); +insert into sys.args values (22624, 62, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.functions values (63, 'not_uniques', 'not_uniques', 'sql', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22625, 63, 'res_0', 'oid', 31, 0, 0, 0); +insert into sys.args values (22626, 63, 'arg_1', 'oid', 31, 0, 1, 1); +insert into sys.functions values (64, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22627, 64, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (22628, 64, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (65, 'rotate_xor_hash', 'rotate_xor_hash', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22629, 65, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (22630, 65, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (22631, 65, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (22632, 65, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.functions values (66, '=', '=', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22633, 66, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22634, 66, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (22635, 66, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (67, '<>', '!=', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22636, 67, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22637, 67, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (22638, 67, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (68, 'isnull', 'isnil', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22639, 68, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22640, 68, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (69, '>', '>', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22641, 69, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22642, 69, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (22643, 69, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (70, '>=', '>=', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22644, 70, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22645, 70, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (22646, 70, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (71, '<', '<', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22647, 71, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22648, 71, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (22649, 71, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (72, '<=', '<=', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22650, 72, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22651, 72, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (22652, 72, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (73, 'between', 'between', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22653, 73, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22654, 73, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (22655, 73, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (22656, 73, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.args values (22657, 73, 'arg_4', 'boolean', 1, 0, 1, 4); +insert into sys.args values (22658, 73, 'arg_5', 'boolean', 1, 0, 1, 5); +insert into sys.args values (22659, 73, 'arg_6', 'boolean', 1, 0, 1, 6); +insert into sys.args values (22660, 73, 'arg_7', 'boolean', 1, 0, 1, 7); +insert into sys.functions values (77, 'any', 'any', 'sql', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22661, 77, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22662, 77, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (22663, 77, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.args values (22664, 77, 'arg_3', 'boolean', 1, 0, 1, 3); +insert into sys.functions values (78, 'all', 'all', 'sql', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22665, 78, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22666, 78, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (22667, 78, 'arg_2', 'boolean', 1, 0, 1, 2); +insert into sys.args values (22668, 78, 'arg_3', 'boolean', 1, 0, 1, 3); +insert into sys.functions values (83, 'sql_exists', 'exist', 'aggr', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22669, 83, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22670, 83, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (84, 'sql_not_exists', 'not_exist', 'aggr', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22671, 84, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22672, 84, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (85, 'in', 'in', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22673, 85, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (22674, 85, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (22675, 85, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (86, 'identity', 'identity', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22676, 86, 'res_0', 'oid', 31, 0, 0, 0); +insert into sys.args values (22677, 86, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (87, 'rowid', 'identity', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22678, 87, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (22679, 87, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.functions values (88, 'rowid', 'rowid', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22680, 88, 'res_0', 'oid', 31, 0, 0, 0); +insert into sys.args values (22681, 88, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (22682, 88, 'arg_2', 'varchar', 0, 0, 1, 2); +insert into sys.args values (22683, 88, 'arg_3', 'varchar', 0, 0, 1, 3); +insert into sys.functions values (91, 'sql_min', 'min', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22684, 91, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (22685, 91, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (22686, 91, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (92, 'sql_max', 'max', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22687, 92, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (22688, 92, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (22689, 92, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (93, 'least', 'min_no_nil', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22690, 93, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (22691, 93, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (22692, 93, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (94, 'greatest', 'max_no_nil', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22693, 94, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (22694, 94, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (22695, 94, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.functions values (95, 'ifthenelse', 'ifthenelse', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22696, 95, 'res_0', 'any', 0, 0, 0, 0); +insert into sys.args values (22697, 95, 'arg_1', 'boolean', 1, 0, 1, 1); +insert into sys.args values (22698, 95, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (22699, 95, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.functions values (112, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22700, 112, 'res_0', 'oid', 31, 0, 0, 0); +insert into sys.args values (22701, 112, 'arg_1', 'oid', 31, 0, 1, 1); +insert into sys.args values (22702, 112, 'arg_2', 'oid', 31, 0, 1, 2); +insert into sys.functions values (113, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22703, 113, 'res_0', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (22704, 113, 'arg_1', 'tinyint', 8, 0, 1, 1); +insert into sys.args values (22705, 113, 'arg_2', 'tinyint', 8, 0, 1, 2); +insert into sys.functions values (114, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22706, 114, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (22707, 114, 'arg_1', 'smallint', 16, 0, 1, 1); +insert into sys.args values (22708, 114, 'arg_2', 'smallint', 16, 0, 1, 2); +insert into sys.functions values (115, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22709, 115, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (22710, 115, 'arg_1', 'int', 32, 0, 1, 1); +insert into sys.args values (22711, 115, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.functions values (116, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22712, 116, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (22713, 116, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (22714, 116, 'arg_2', 'bigint', 64, 0, 1, 2); +insert into sys.functions values (117, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22715, 117, 'res_0', 'decimal', 2, 0, 0, 0); +insert into sys.args values (22716, 117, 'arg_1', 'decimal', 2, 0, 1, 1); +insert into sys.args values (22717, 117, 'arg_2', 'decimal', 2, 0, 1, 2); +insert into sys.functions values (118, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22718, 118, 'res_0', 'decimal', 4, 0, 0, 0); +insert into sys.args values (22719, 118, 'arg_1', 'decimal', 4, 0, 1, 1); +insert into sys.args values (22720, 118, 'arg_2', 'decimal', 4, 0, 1, 2); +insert into sys.functions values (119, 'mod', '%', 'calc', 0, 1, false, false, false, 2000, true); +insert into sys.args values (22721, 119, 'res_0', 'decimal', 9, 0, 0, 0); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
