Changeset: dc559b235c2d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dc559b235c2d Modified Files: sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 sql/test/emptydb-upgrade/Tests/upgrade.stable.out sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit Branch: Apr2019 Log Message:
Approve upgrades. diffs (truncated from 78264 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out @@ -85,4980 +85,4980 @@ insert into sys.types values (28, '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 (29, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18593, 29, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18594, 29, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18595, 29, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18597, 29, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18598, 29, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18599, 29, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (30, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18596, 30, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18597, 30, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18598, 30, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18600, 30, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18601, 30, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18602, 30, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (31, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18599, 31, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18600, 31, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18601, 31, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18603, 31, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18604, 31, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18605, 31, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (32, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18602, 32, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18603, 32, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18604, 32, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18606, 32, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18607, 32, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18608, 32, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (33, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18605, 33, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18606, 33, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18607, 33, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18609, 33, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18610, 33, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18611, 33, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (34, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18608, 34, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18609, 34, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18610, 34, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18612, 34, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18613, 34, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18614, 34, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (35, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18611, 35, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18612, 35, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18613, 35, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18615, 35, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18616, 35, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18617, 35, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (36, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18614, 36, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18615, 36, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18616, 36, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18618, 36, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18619, 36, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18620, 36, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (37, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18617, 37, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18618, 37, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18619, 37, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18621, 37, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18622, 37, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18623, 37, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (38, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18620, 38, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18621, 38, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18622, 38, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18624, 38, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18625, 38, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18626, 38, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (39, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18623, 39, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18624, 39, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18625, 39, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18627, 39, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18628, 39, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18629, 39, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (40, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18626, 40, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18627, 40, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18628, 40, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18630, 40, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18631, 40, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18632, 40, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (41, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18629, 41, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18630, 41, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18631, 41, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18633, 41, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18634, 41, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18635, 41, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (42, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18632, 42, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18633, 42, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18634, 42, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18636, 42, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18637, 42, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18638, 42, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (43, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18635, 43, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18636, 43, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18637, 43, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18639, 43, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18640, 43, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18641, 43, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (44, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18638, 44, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18639, 44, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18640, 44, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18642, 44, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18643, 44, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18644, 44, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (45, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18641, 45, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18642, 45, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18643, 45, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18645, 45, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18646, 45, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18647, 45, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (46, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18644, 46, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18645, 46, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18646, 46, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18648, 46, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18649, 46, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18650, 46, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (47, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18647, 47, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18648, 47, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18649, 47, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18651, 47, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18652, 47, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18653, 47, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (48, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18650, 48, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18651, 48, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18652, 48, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18654, 48, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18655, 48, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18656, 48, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (49, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18653, 49, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18654, 49, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18655, 49, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18657, 49, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18658, 49, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18659, 49, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (50, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18656, 50, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18657, 50, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18658, 50, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18660, 50, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18661, 50, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18662, 50, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (51, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18659, 51, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18660, 51, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18661, 51, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18663, 51, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18664, 51, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18665, 51, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (52, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18662, 52, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18663, 52, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18664, 52, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18666, 52, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18667, 52, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18668, 52, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (53, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18665, 53, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (18666, 53, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18667, 53, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18669, 53, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (18670, 53, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18671, 53, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (54, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18668, 54, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (18669, 54, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18670, 54, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18672, 54, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (18673, 54, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18674, 54, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (55, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18671, 55, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18672, 55, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18673, 55, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18675, 55, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18676, 55, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18677, 55, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (56, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18674, 56, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18675, 56, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18676, 56, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18678, 56, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18679, 56, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18680, 56, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (57, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18677, 57, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18678, 57, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (18679, 57, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (18681, 57, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18682, 57, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (18683, 57, 'arg_2', 'geometry', 0, 0, 1, 2); insert into sys.functions values (58, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18680, 58, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18681, 58, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (18682, 58, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (18684, 58, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18685, 58, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (18686, 58, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (60, 'not_uniques', 'not_uniques', 'sql', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18683, 60, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (18684, 60, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (18687, 60, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (18688, 60, 'arg_1', 'bigint', 64, 0, 1, 1); insert into sys.functions values (61, 'not_uniques', 'not_uniques', 'sql', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18685, 61, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (18686, 61, 'arg_1', 'oid', 63, 0, 1, 1); +insert into sys.args values (18689, 61, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (18690, 61, 'arg_1', 'oid', 63, 0, 1, 1); insert into sys.functions values (62, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18687, 62, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (18688, 62, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18691, 62, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (18692, 62, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (63, 'rotate_xor_hash', 'rotate_xor_hash', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18689, 63, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (18690, 63, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (18691, 63, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (18692, 63, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.args values (18693, 63, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (18694, 63, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (18695, 63, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (18696, 63, 'arg_3', 'any', 0, 0, 1, 3); insert into sys.functions values (64, '=', '=', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18693, 64, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18694, 64, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18695, 64, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (18697, 64, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18698, 64, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18699, 64, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (65, '<>', '!=', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18696, 65, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18697, 65, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18698, 65, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (18700, 65, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18701, 65, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18702, 65, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (66, 'isnull', 'isnil', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18699, 66, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18700, 66, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18703, 66, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18704, 66, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (67, '>', '>', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18701, 67, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18702, 67, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18703, 67, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (18705, 67, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18706, 67, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18707, 67, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (68, '>=', '>=', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18704, 68, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18705, 68, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18706, 68, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (18708, 68, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18709, 68, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18710, 68, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (69, '<', '<', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18707, 69, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18708, 69, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18709, 69, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (18711, 69, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18712, 69, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18713, 69, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (70, '<=', '<=', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18710, 70, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18711, 70, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (18712, 70, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (18714, 70, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18715, 70, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18716, 70, 'arg_2', 'any', 0, 0, 1, 2); insert into sys.functions values (75, 'sql_exists', 'exist', 'aggr', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18713, 75, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18714, 75, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18717, 75, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18718, 75, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (76, 'sql_not_exists', 'not_exist', 'aggr', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18715, 76, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18716, 76, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (18719, 76, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (18720, 76, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (77, 'in', 'in', 'calc', 0, 1, false, false, false, 2000, true); -insert into sys.args values (18717, 77, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (18718, 77, 'arg_1', 'any', 0, 0, 1, 1); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
