Changeset: 371c29ad6371 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/371c29ad6371 Modified Files: sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.int128 sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 Branch: sqlfuncfix Log Message:
Approvals. diffs (truncated from 28678 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 @@ -37,4106 +37,4106 @@ insert into sys.types values (34, 'mbr', delete from sys.functions where id < 2000; delete from sys.args where func_id not in (select id from sys.functions); insert into sys.functions values (30, 'length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (39506, 30, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (39507, 30, 'arg_1', 'blob', 0, 0, 1, 1); +insert into sys.args values (39527, 30, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (39528, 30, 'arg_1', 'blob', 0, 0, 1, 1); insert into sys.functions values (31, 'octet_length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (39508, 31, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (39509, 31, 'arg_1', 'blob', 0, 0, 1, 1); +insert into sys.args values (39529, 31, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (39530, 31, 'arg_1', 'blob', 0, 0, 1, 1); insert into sys.functions values (35, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39510, 35, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39511, 35, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39512, 35, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39531, 35, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39532, 35, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39533, 35, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (36, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39513, 36, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39514, 36, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39515, 36, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39534, 36, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39535, 36, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39536, 36, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (37, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39516, 37, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39517, 37, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39518, 37, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39537, 37, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39538, 37, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39539, 37, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (38, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39519, 38, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39520, 38, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39521, 38, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39540, 38, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39541, 38, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39542, 38, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (39, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39522, 39, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39523, 39, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39524, 39, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39543, 39, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39544, 39, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39545, 39, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (40, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39525, 40, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39526, 40, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39527, 40, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39546, 40, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39547, 40, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39548, 40, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (41, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39528, 41, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39529, 41, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39530, 41, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39549, 41, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39550, 41, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39551, 41, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (42, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39531, 42, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39532, 42, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39533, 42, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39552, 42, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39553, 42, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39554, 42, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (43, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39534, 43, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39535, 43, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39536, 43, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39555, 43, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39556, 43, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39557, 43, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (44, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39537, 44, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39538, 44, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39539, 44, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39558, 44, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39559, 44, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39560, 44, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (45, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39540, 45, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39541, 45, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39542, 45, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39561, 45, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39562, 45, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39563, 45, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (46, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39543, 46, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39544, 46, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39545, 46, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39564, 46, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39565, 46, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39566, 46, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (47, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39546, 47, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39547, 47, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39548, 47, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39567, 47, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39568, 47, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39569, 47, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (48, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39549, 48, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39550, 48, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39551, 48, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39570, 48, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39571, 48, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39572, 48, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (49, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39552, 49, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39553, 49, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39554, 49, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39573, 49, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39574, 49, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39575, 49, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (50, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39555, 50, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39556, 50, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39557, 50, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39576, 50, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39577, 50, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39578, 50, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (51, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39558, 51, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39559, 51, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39560, 51, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39579, 51, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39580, 51, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39581, 51, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (52, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39561, 52, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39562, 52, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39563, 52, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39582, 52, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39583, 52, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39584, 52, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (53, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39564, 53, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39565, 53, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39566, 53, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39585, 53, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39586, 53, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39587, 53, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (54, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39567, 54, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39568, 54, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39569, 54, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39588, 54, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39589, 54, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39590, 54, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (55, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39570, 55, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39571, 55, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39572, 55, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39591, 55, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39592, 55, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39593, 55, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (56, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39573, 56, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39574, 56, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39575, 56, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39594, 56, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39595, 56, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39596, 56, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (57, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39576, 57, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39577, 57, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39578, 57, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39597, 57, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39598, 57, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39599, 57, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (58, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39579, 58, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39580, 58, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39581, 58, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39600, 58, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39601, 58, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39602, 58, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (59, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39582, 59, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (39583, 59, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39584, 59, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39603, 59, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (39604, 59, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39605, 59, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (60, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39585, 60, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (39586, 60, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39587, 60, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39606, 60, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (39607, 60, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39608, 60, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (61, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39588, 61, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39589, 61, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39590, 61, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39609, 61, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39610, 61, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39611, 61, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (62, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39591, 62, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39592, 62, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39593, 62, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39612, 62, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39613, 62, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39614, 62, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (63, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39594, 63, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39595, 63, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (39596, 63, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (39615, 63, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39616, 63, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (39617, 63, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (64, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39597, 64, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39598, 64, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (39599, 64, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (39618, 64, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39619, 64, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (39620, 64, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (65, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (39600, 65, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (39601, 65, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (39621, 65, 'res_0', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (39622, 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 (39602, 66, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (39603, 66, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (39623, 66, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (39624, 66, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (67, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (39604, 67, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (39605, 67, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (39625, 67, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (39626, 67, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (68, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (39606, 68, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (39607, 68, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (39627, 68, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (39628, 68, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (69, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (39608, 69, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (39609, 69, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (39629, 69, 'res_0', 'hugeint', 128, 0, 0, 0); +insert into sys.args values (39630, 69, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (70, 'not_unique', 'not_unique', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (39610, 70, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39611, 70, 'arg_1', 'oid', 63, 0, 1, 1); +insert into sys.args values (39631, 70, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39632, 70, 'arg_1', 'oid', 63, 0, 1, 1); insert into sys.functions values (71, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39612, 71, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (39613, 71, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (39633, 71, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (39634, 71, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (72, 'rotate_xor_hash', 'rotate_xor_hash', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39614, 72, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (39615, 72, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (39616, 72, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (39617, 72, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.args values (39635, 72, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (39636, 72, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (39637, 72, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (39638, 72, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (73, '=', '=', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (39618, 73, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39619, 73, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (39620, 73, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (39639, 73, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39640, 73, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (39641, 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 (39621, 74, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39622, 74, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (39623, 74, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (39642, 74, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39643, 74, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (39644, 74, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (75, 'isnull', 'isnil', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39624, 75, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39625, 75, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (39645, 75, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39646, 75, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (76, 'isnotnull', 'isnotnil', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (39626, 76, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39627, 76, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (39647, 76, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39648, 76, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (77, '>', '>', 'calc', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (39628, 77, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (39629, 77, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (39630, 77, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (39649, 77, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (39650, 77, 'arg_1', 'any', 0, 0, 1, 1); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
