Changeset: 66f57162aab4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=66f57162aab4 Modified Files: sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 Branch: Jun2020 Log Message:
Approve upgrade. diffs (truncated from 5613 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 @@ -16,5609 +16,6 @@ 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', 63, 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, 13, 2000); -insert into sys.types values (22, 'date', 'date', 0, 0, 0, 14, 2000); -insert into sys.types values (23, 'timestamp', 'timestamp', 7, 0, 0, 15, 2000); -insert into sys.types values (24, 'timestamp', 'timestamptz', 7, 1, 0, 16, 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, 17, 2000); -insert into sys.types values (29, 'wkba', 'geometrya', 0, 0, 0, 18, 2000); -insert into sys.types values (30, '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 (26, 'length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (26504, 26, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (26505, 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, false); -insert into sys.args values (26506, 27, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (26507, 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, true); -insert into sys.args values (26508, 31, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26509, 31, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26510, 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, true); -insert into sys.args values (26511, 32, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26512, 32, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26513, 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, true); -insert into sys.args values (26514, 33, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26515, 33, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26516, 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, true); -insert into sys.args values (26517, 34, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26518, 34, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26519, 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, true); -insert into sys.args values (26520, 35, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26521, 35, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26522, 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, true); -insert into sys.args values (26523, 36, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26524, 36, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26525, 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, true); -insert into sys.args values (26526, 37, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26527, 37, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26528, 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, true); -insert into sys.args values (26529, 38, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26530, 38, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26531, 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, true); -insert into sys.args values (26532, 39, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26533, 39, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26534, 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, true); -insert into sys.args values (26535, 40, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26536, 40, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26537, 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, true); -insert into sys.args values (26538, 41, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26539, 41, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26540, 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, true); -insert into sys.args values (26541, 42, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26542, 42, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26543, 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, true); -insert into sys.args values (26544, 43, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26545, 43, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26546, 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, true); -insert into sys.args values (26547, 44, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26548, 44, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26549, 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, true); -insert into sys.args values (26550, 45, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26551, 45, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26552, 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, true); -insert into sys.args values (26553, 46, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26554, 46, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26555, 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, true); -insert into sys.args values (26556, 47, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26557, 47, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26558, 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, true); -insert into sys.args values (26559, 48, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26560, 48, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26561, 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, true); -insert into sys.args values (26562, 49, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26563, 49, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26564, 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, true); -insert into sys.args values (26565, 50, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26566, 50, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26567, 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, true); -insert into sys.args values (26568, 51, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26569, 51, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26570, 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, true); -insert into sys.args values (26571, 52, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26572, 52, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26573, 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, true); -insert into sys.args values (26574, 53, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26575, 53, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26576, 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, true); -insert into sys.args values (26577, 54, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26578, 54, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26579, 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, true); -insert into sys.args values (26580, 55, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (26581, 55, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26582, 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, true); -insert into sys.args values (26583, 56, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (26584, 56, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26585, 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, true); -insert into sys.args values (26586, 57, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26587, 57, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26588, 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, true); -insert into sys.args values (26589, 58, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26590, 58, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26591, 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, true); -insert into sys.args values (26592, 59, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26593, 59, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (26594, 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, true); -insert into sys.args values (26595, 60, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26596, 60, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (26597, 60, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (61, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (26598, 61, 'res', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (26599, 61, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (62, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (26600, 62, 'res', 'smallint', 16, 0, 0, 0); -insert into sys.args values (26601, 62, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (63, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (26602, 63, 'res', 'int', 32, 0, 0, 0); -insert into sys.args values (26603, 63, 'arg', '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 (26604, 64, 'res', 'bigint', 64, 0, 0, 0); -insert into sys.args values (26605, 64, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (65, 'not_unique', 'not_unique', 'sql', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (26606, 65, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26607, 65, 'arg', 'oid', 63, 0, 1, 1); -insert into sys.functions values (66, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26608, 66, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (26609, 66, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (67, 'rotate_xor_hash', 'rotate_xor_hash', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26610, 67, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (26611, 67, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (26612, 67, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (26613, 67, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (68, '=', '=', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26614, 68, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26615, 68, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (26616, 68, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (69, '<>', '!=', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26617, 69, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26618, 69, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (26619, 69, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (70, 'isnull', 'isnil', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26620, 70, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26621, 70, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (71, '>', '>', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (26622, 71, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26623, 71, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (26624, 71, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (72, '>=', '>=', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (26625, 72, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26626, 72, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (26627, 72, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (73, '<', '<', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (26628, 73, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26629, 73, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (26630, 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 (26631, 74, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26632, 74, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (26633, 74, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (75, 'between', 'between', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26634, 75, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26635, 75, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (26636, 75, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (26637, 75, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.args values (26638, 75, 'arg_4', 'boolean', 1, 0, 1, 4); -insert into sys.args values (26639, 75, 'arg_5', 'boolean', 1, 0, 1, 5); -insert into sys.args values (26640, 75, 'arg_6', 'boolean', 1, 0, 1, 6); -insert into sys.args values (26641, 75, 'arg_7', 'boolean', 1, 0, 1, 7); -insert into sys.args values (26642, 75, 'arg_8', 'boolean', 1, 0, 1, 8); -insert into sys.functions values (76, 'zero_or_one', 'zero_or_one', 'sql', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (26643, 76, 'res', 'any', 0, 0, 0, 0); -insert into sys.args values (26644, 76, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (77, 'all', 'all', 'sql', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (26645, 77, 'res', 'any', 0, 0, 0, 0); -insert into sys.args values (26646, 77, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (78, 'null', 'null', 'sql', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (26647, 78, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26648, 78, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (79, 'any', 'any', 'sql', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26649, 79, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26650, 79, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (26651, 79, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.args values (26652, 79, 'arg_3', 'boolean', 1, 0, 1, 3); -insert into sys.functions values (80, 'all', 'all', 'sql', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26653, 80, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26654, 80, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (26655, 80, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.args values (26656, 80, 'arg_3', 'boolean', 1, 0, 1, 3); -insert into sys.functions values (81, 'anyequal', 'anyequal', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (26657, 81, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26658, 81, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (82, 'allnotequal', 'allnotequal', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (26659, 82, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26660, 82, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (83, 'sql_anyequal', 'anyequal', 'aggr', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26661, 83, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26662, 83, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (26663, 83, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (84, 'sql_not_anyequal', 'not_anyequal', 'aggr', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26664, 84, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26665, 84, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (26666, 84, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (85, 'exist', 'exist', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (26667, 85, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26668, 85, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (86, 'not_exist', 'not_exist', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (26669, 86, 'res', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26670, 86, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (87, 'sql_exists', 'exist', 'aggr', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26671, 87, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26672, 87, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (88, 'sql_not_exists', 'not_exist', 'aggr', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26673, 88, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (26674, 88, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (89, 'identity', 'identity', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26675, 89, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (26676, 89, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (90, 'rowid', 'identity', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26677, 90, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (26678, 90, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (91, 'rowid', 'rowid', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (26679, 91, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (26680, 91, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (26681, 91, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.args values (26682, 91, 'arg_3', 'varchar', 0, 0, 1, 3); -insert into sys.functions values (92, 'min', 'min', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (26683, 92, 'res', 'any', 0, 0, 0, 0); -insert into sys.args values (26684, 92, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (93, 'max', 'max', 'aggr', 0, 3, false, false, false, 2000, true, false); -insert into sys.args values (26685, 93, 'res', 'any', 0, 0, 0, 0); -insert into sys.args values (26686, 93, 'arg', 'any', 0, 0, 1, 1); -insert into sys.functions values (94, 'sql_min', 'min', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (26687, 94, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (26688, 94, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (26689, 94, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (95, 'sql_max', 'max', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (26690, 95, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (26691, 95, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (26692, 95, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (96, 'least', 'min_no_nil', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (26693, 96, 'res_0', 'any', 0, 0, 0, 0); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
