Changeset: c495a64dab0d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c495a64dab0d Modified Files: sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128 Branch: Aug2018 Log Message:
Approved. diffs (truncated from 9123 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 @@ -54,5241 +54,5241 @@ insert into sys.types values (30, '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 (31, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (18511, 31, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18512, 31, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18513, 31, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18514, 32, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18515, 32, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18516, 32, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18517, 33, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18518, 33, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18519, 33, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18520, 34, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18521, 34, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18522, 34, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18523, 35, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18524, 35, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18525, 35, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18526, 36, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18527, 36, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18528, 36, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18529, 37, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18530, 37, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18531, 37, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18532, 38, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18533, 38, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18534, 38, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18535, 39, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18536, 39, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18537, 39, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18538, 40, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18539, 40, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18540, 40, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18541, 41, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18542, 41, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18543, 41, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18544, 42, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18545, 42, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18546, 42, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18547, 43, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18548, 43, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18549, 43, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18550, 44, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18551, 44, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18552, 44, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18553, 45, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18554, 45, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18555, 45, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18556, 46, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18557, 46, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18558, 46, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18559, 47, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18560, 47, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18561, 47, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18562, 48, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18563, 48, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18564, 48, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18565, 49, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18566, 49, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18567, 49, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18568, 50, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18569, 50, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18570, 50, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18571, 51, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18572, 51, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18573, 51, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18574, 52, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18575, 52, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18576, 52, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18577, 53, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18578, 53, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18579, 53, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18580, 54, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18581, 54, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18582, 54, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18583, 55, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (18584, 55, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18585, 55, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18586, 56, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (18587, 56, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18588, 56, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18589, 57, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18590, 57, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18591, 57, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18592, 58, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18593, 58, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18594, 58, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18595, 59, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18596, 59, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18597, 59, 'arg_2', 'geometry', 0, 0, 1, 2); +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 (18598, 60, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18599, 60, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18600, 60, 'arg_2', 'mbr', 0, 0, 1, 2); +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 (18601, 62, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (18602, 62, 'arg_1', 'bigint', 64, 0, 1, 1); +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 (18603, 63, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (18604, 63, 'arg_1', 'oid', 63, 0, 1, 1); +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 (18605, 64, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (18606, 64, 'arg_1', 'any', 0, 0, 1, 1); +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 (18607, 65, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (18608, 65, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (18609, 65, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (18610, 65, 'arg_3', 'any', 0, 0, 1, 3); +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 (18611, 66, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18612, 66, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18613, 66, 'arg_2', 'any', 0, 0, 1, 2); +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 (18614, 67, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18615, 67, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18616, 67, 'arg_2', 'any', 0, 0, 1, 2); +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 (18617, 68, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18618, 68, 'arg_1', 'any', 0, 0, 1, 1); +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 (18619, 69, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18620, 69, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18621, 69, 'arg_2', 'any', 0, 0, 1, 2); +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 (18622, 70, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18623, 70, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18624, 70, 'arg_2', 'any', 0, 0, 1, 2); +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 (18625, 71, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18626, 71, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18627, 71, 'arg_2', 'any', 0, 0, 1, 2); +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 (18628, 72, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18629, 72, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18630, 72, 'arg_2', 'any', 0, 0, 1, 2); +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 (18631, 77, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18632, 77, 'arg_1', 'any', 0, 0, 1, 1); +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 (18633, 78, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18634, 78, 'arg_1', 'any', 0, 0, 1, 1); +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 (18635, 79, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18636, 79, 'arg_1', 'any', 0, 0, 1, 1); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list