Changeset: c3923b578a3c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c3923b578a3c Modified Files: sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128 Branch: default Log Message:
Merge heads. diffs (truncated from 10537 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128 b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128 --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128 +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128 @@ -53,5244 +53,5242 @@ insert into sys.types values (29, 'wkba' 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 (31, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18532, 31, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18533, 31, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18534, 31, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (32, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18535, 32, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18536, 32, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18537, 32, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (33, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18538, 33, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18539, 33, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18540, 33, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (34, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18541, 34, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18542, 34, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18543, 34, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (35, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18544, 35, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18545, 35, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18546, 35, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (36, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18547, 36, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18548, 36, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18549, 36, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (37, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18550, 37, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18551, 37, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18552, 37, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (38, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18553, 38, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18554, 38, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18555, 38, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (39, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18556, 39, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18557, 39, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18558, 39, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (40, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18559, 40, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18560, 40, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18561, 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); -insert into sys.args values (18562, 41, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18563, 41, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18564, 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); -insert into sys.args values (18565, 42, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18566, 42, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18567, 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); -insert into sys.args values (18568, 43, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18569, 43, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18570, 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); -insert into sys.args values (18571, 44, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18572, 44, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18573, 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); -insert into sys.args values (18574, 45, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18575, 45, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18576, 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); -insert into sys.args values (18577, 46, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18578, 46, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18579, 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); -insert into sys.args values (18580, 47, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18581, 47, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18582, 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); -insert into sys.args values (18583, 48, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18584, 48, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18585, 48, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (49, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18586, 49, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18587, 49, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18588, 49, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (50, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18589, 50, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18590, 50, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18591, 50, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (51, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18592, 51, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18593, 51, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18594, 51, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (52, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18595, 52, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18596, 52, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18597, 52, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (53, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18598, 53, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18599, 53, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18600, 53, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (54, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18601, 54, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18602, 54, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18603, 54, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (55, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18604, 55, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (18605, 55, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18606, 55, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (56, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18607, 56, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (18608, 56, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18609, 56, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (57, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18610, 57, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18611, 57, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18612, 57, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (58, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18613, 58, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18614, 58, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18615, 58, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (59, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18616, 59, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18617, 59, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18618, 59, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (60, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18619, 60, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18620, 60, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18621, 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); -insert into sys.args values (18622, 62, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (18623, 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); -insert into sys.args values (18624, 63, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (18625, 63, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.functions values (64, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000); -insert into sys.args values (18626, 64, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (18627, 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); -insert into sys.args values (18628, 65, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (18629, 65, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (18630, 65, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (18631, 65, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (66, '=', '=', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18632, 66, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18633, 66, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18634, 66, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (67, '<>', '!=', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18635, 67, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18636, 67, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18637, 67, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (68, 'isnull', 'isnil', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18638, 68, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18639, 68, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (69, '>', '>', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18640, 69, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18641, 69, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18642, 69, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (70, '>=', '>=', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18643, 70, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18644, 70, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18645, 70, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (71, '<', '<', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18646, 71, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18647, 71, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18648, 71, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (72, '<=', '<=', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18649, 72, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18650, 72, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18651, 72, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (77, 'sql_exists', 'exist', 'aggr', 0, 1, false, false, false, 2000); -insert into sys.args values (18652, 77, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18653, 77, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (78, 'sql_not_exists', 'not_exist', 'aggr', 0, 1, false, false, false, 2000); -insert into sys.args values (18654, 78, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18655, 78, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (79, 'in', 'in', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18656, 79, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18657, 79, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18658, 79, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (80, 'identity', 'identity', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18659, 80, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (18660, 80, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (81, 'rowid', 'identity', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18661, 81, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (18662, 81, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (82, 'rowid', 'rowid', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18663, 82, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (18664, 82, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18665, 82, 'arg_2', 'varchar', 0, 0, 1, 2); -insert into sys.args values (18666, 82, 'arg_3', 'varchar', 0, 0, 1, 3); -insert into sys.functions values (85, 'sql_min', 'min', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18667, 85, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (18668, 85, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18669, 85, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (86, 'sql_max', 'max', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18670, 86, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (18671, 86, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18672, 86, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (87, 'ifthenelse', 'ifthenelse', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18673, 87, 'res_0', 'any', 0, 0, 0, 0); -insert into sys.args values (18674, 87, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (18675, 87, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.args values (18676, 87, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (108, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18677, 108, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (18678, 108, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.args values (18679, 108, 'arg_2', 'oid', 63, 0, 1, 2); -insert into sys.functions values (109, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18680, 109, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (18681, 109, 'arg_1', 'tinyint', 8, 0, 1, 1); -insert into sys.args values (18682, 109, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.functions values (110, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18683, 110, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (18684, 110, 'arg_1', 'smallint', 16, 0, 1, 1); -insert into sys.args values (18685, 110, 'arg_2', 'smallint', 16, 0, 1, 2); -insert into sys.functions values (111, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18686, 111, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (18687, 111, 'arg_1', 'int', 32, 0, 1, 1); -insert into sys.args values (18688, 111, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.functions values (112, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18689, 112, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (18690, 112, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (18691, 112, 'arg_2', 'bigint', 64, 0, 1, 2); -insert into sys.functions values (113, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18692, 113, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (18693, 113, 'arg_1', 'hugeint', 128, 0, 1, 1); -insert into sys.args values (18694, 113, 'arg_2', 'hugeint', 128, 0, 1, 2); -insert into sys.functions values (114, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18695, 114, 'res_0', 'decimal', 2, 0, 0, 0); -insert into sys.args values (18696, 114, 'arg_1', 'decimal', 2, 0, 1, 1); -insert into sys.args values (18697, 114, 'arg_2', 'decimal', 2, 0, 1, 2); -insert into sys.functions values (115, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18698, 115, 'res_0', 'decimal', 4, 0, 0, 0); -insert into sys.args values (18699, 115, 'arg_1', 'decimal', 4, 0, 1, 1); -insert into sys.args values (18700, 115, 'arg_2', 'decimal', 4, 0, 1, 2); -insert into sys.functions values (116, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18701, 116, 'res_0', 'decimal', 9, 0, 0, 0); -insert into sys.args values (18702, 116, 'arg_1', 'decimal', 9, 0, 1, 1); -insert into sys.args values (18703, 116, 'arg_2', 'decimal', 9, 0, 1, 2); -insert into sys.functions values (117, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18704, 117, 'res_0', 'decimal', 18, 0, 0, 0); -insert into sys.args values (18705, 117, 'arg_1', 'decimal', 18, 0, 1, 1); -insert into sys.args values (18706, 117, 'arg_2', 'decimal', 18, 0, 1, 2); -insert into sys.functions values (118, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18707, 118, 'res_0', 'decimal', 38, 0, 0, 0); -insert into sys.args values (18708, 118, 'arg_1', 'decimal', 38, 0, 1, 1); -insert into sys.args values (18709, 118, 'arg_2', 'decimal', 38, 0, 1, 2); -insert into sys.functions values (119, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18710, 119, 'res_0', 'real', 24, 0, 0, 0); -insert into sys.args values (18711, 119, 'arg_1', 'real', 24, 0, 1, 1); -insert into sys.args values (18712, 119, 'arg_2', 'real', 24, 0, 1, 2); -insert into sys.functions values (120, 'mod', '%', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18713, 120, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (18714, 120, 'arg_1', 'double', 53, 0, 1, 1); -insert into sys.args values (18715, 120, 'arg_2', 'double', 53, 0, 1, 2); -insert into sys.functions values (136, 'diff', 'diff', 'sql', 0, 6, false, false, false, 2000); -insert into sys.args values (18716, 136, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18717, 136, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (137, 'diff', 'diff', 'sql', 0, 6, false, false, false, 2000); -insert into sys.args values (18718, 137, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18719, 137, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (18720, 137, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (138, 'rank', 'rank', 'sql', 0, 6, false, false, false, 2000); -insert into sys.args values (18721, 138, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (18722, 138, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18723, 138, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.args values (18724, 138, 'arg_3', 'boolean', 1, 0, 1, 3); -insert into sys.functions values (139, 'dense_rank', 'dense_rank', 'sql', 0, 6, false, false, false, 2000); -insert into sys.args values (18725, 139, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (18726, 139, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18727, 139, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.args values (18728, 139, 'arg_3', 'boolean', 1, 0, 1, 3); -insert into sys.functions values (140, 'row_number', 'row_number', 'sql', 0, 6, false, false, false, 2000); -insert into sys.args values (18729, 140, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (18730, 140, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18731, 140, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.args values (18732, 140, 'arg_3', 'boolean', 1, 0, 1, 3); -insert into sys.functions values (141, 'and', 'and', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18733, 141, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18734, 141, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (18735, 141, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (142, 'or', 'or', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18736, 142, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18737, 142, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (18738, 142, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (143, 'xor', 'xor', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18739, 143, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18740, 143, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.args values (18741, 143, 'arg_2', 'boolean', 1, 0, 1, 2); -insert into sys.functions values (144, 'not', 'not', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18742, 144, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18743, 144, 'arg_1', 'boolean', 1, 0, 1, 1); -insert into sys.functions values (145, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18744, 145, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (18745, 145, 'arg_1', 'smallint', 16, 0, 1, 1); -insert into sys.args values (18746, 145, 'arg_2', 'tinyint', 8, 0, 1, 2); -insert into sys.functions values (146, 'sql_mul', '*', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (18747, 146, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (18748, 146, 'arg_1', 'tinyint', 8, 0, 1, 1); -insert into sys.args values (18749, 146, 'arg_2', 'smallint', 16, 0, 1, 2); -insert into sys.functions values (147, 'sql_div', '/', 'calc', 0, 1, false, false, false, 2000); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
