Changeset: 844e9ef57ce9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=844e9ef57ce9 Modified Files: sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 Branch: default Log Message:
Approve upgrade. diffs (truncated from 18360 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 @@ -5322,7 +5322,7 @@ create aggregate median(val HUGEINT) ret external name "aggr"."median"; create aggregate quantile(val HUGEINT, q DOUBLE) returns HUGEINT external name "aggr"."quantile"; -create aggregate corr(e1 HUGEINT, e2 HUGEINT) returns HUGEINT +create aggregate corr(e1 HUGEINT, e2 HUGEINT) returns DOUBLE external name "aggr"."corr"; create function json.filter(js json, name hugeint) returns json @@ -5350,18 +5350,6 @@ grant execute on function json.filter(js set schema "sys"; Running database upgrade commands: -GRANT SELECT ON sys.keywords TO PUBLIC; -GRANT SELECT ON sys.table_types TO PUBLIC; -GRANT SELECT ON sys.dependency_types TO PUBLIC; -GRANT SELECT ON sys.function_types TO PUBLIC; -GRANT SELECT ON sys.function_languages TO PUBLIC; -GRANT SELECT ON sys.key_types TO PUBLIC; -GRANT SELECT ON sys.index_types TO PUBLIC; -GRANT SELECT ON sys.privilege_codes TO PUBLIC; -GRANT EXECUTE ON FUNCTION sys.environment() TO PUBLIC; -GRANT SELECT ON sys.environment TO PUBLIC; - -Running database upgrade commands: set schema "sys"; create procedure master() external name wlc.master; diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 @@ -62,5239 +62,5239 @@ 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 (7643, 31, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7644, 31, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7645, 31, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7661, 31, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7662, 31, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7663, 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 (7646, 32, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7647, 32, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7648, 32, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7664, 32, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7665, 32, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7666, 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 (7649, 33, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7650, 33, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7651, 33, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7667, 33, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7668, 33, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7669, 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 (7652, 34, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7653, 34, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7654, 34, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7670, 34, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7671, 34, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7672, 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 (7655, 35, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7656, 35, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7657, 35, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7673, 35, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7674, 35, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7675, 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 (7658, 36, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7659, 36, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7660, 36, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7676, 36, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7677, 36, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7678, 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 (7661, 37, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7662, 37, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7663, 37, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7679, 37, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7680, 37, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7681, 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 (7664, 38, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7665, 38, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7666, 38, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7682, 38, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7683, 38, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7684, 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 (7667, 39, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7668, 39, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7669, 39, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7685, 39, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7686, 39, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7687, 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 (7670, 40, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7671, 40, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7672, 40, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7688, 40, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7689, 40, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7690, 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 (7673, 41, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7674, 41, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7675, 41, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7691, 41, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7692, 41, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7693, 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 (7676, 42, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7677, 42, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7678, 42, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7694, 42, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7695, 42, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7696, 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 (7679, 43, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7680, 43, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7681, 43, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7697, 43, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7698, 43, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7699, 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 (7682, 44, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7683, 44, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7684, 44, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7700, 44, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7701, 44, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7702, 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 (7685, 45, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7686, 45, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7687, 45, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7703, 45, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7704, 45, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7705, 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 (7688, 46, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7689, 46, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7690, 46, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7706, 46, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7707, 46, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7708, 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 (7691, 47, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7692, 47, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7693, 47, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7709, 47, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7710, 47, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7711, 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 (7694, 48, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7695, 48, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7696, 48, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7712, 48, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7713, 48, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7714, 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 (7697, 49, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7698, 49, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7699, 49, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7715, 49, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7716, 49, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7717, 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 (7700, 50, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7701, 50, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7702, 50, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7718, 50, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7719, 50, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7720, 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 (7703, 51, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7704, 51, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7705, 51, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7721, 51, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7722, 51, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7723, 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 (7706, 52, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7707, 52, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7708, 52, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7724, 52, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7725, 52, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7726, 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 (7709, 53, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7710, 53, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7711, 53, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7727, 53, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7728, 53, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7729, 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 (7712, 54, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7713, 54, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7714, 54, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7730, 54, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7731, 54, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7732, 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 (7715, 55, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (7716, 55, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7717, 55, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7733, 55, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (7734, 55, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7735, 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 (7718, 56, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (7719, 56, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7720, 56, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7736, 56, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (7737, 56, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7738, 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 (7721, 57, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7722, 57, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7723, 57, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7739, 57, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7740, 57, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7741, 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 (7724, 58, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7725, 58, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7726, 58, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7742, 58, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7743, 58, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7744, 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 (7727, 59, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7728, 59, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7729, 59, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7745, 59, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7746, 59, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7747, 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 (7730, 60, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7731, 60, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7732, 60, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7748, 60, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7749, 60, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7750, 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 (7733, 62, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (7734, 62, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (7751, 62, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (7752, 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 (7735, 63, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (7736, 63, 'arg_1', 'oid', 63, 0, 1, 1); +insert into sys.args values (7753, 63, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (7754, 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 (7737, 64, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (7738, 64, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (7755, 64, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (7756, 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 (7739, 65, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (7740, 65, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (7741, 65, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (7742, 65, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.args values (7757, 65, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (7758, 65, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (7759, 65, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (7760, 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 (7743, 66, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7744, 66, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (7745, 66, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (7761, 66, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7762, 66, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (7763, 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 (7746, 67, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7747, 67, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (7748, 67, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (7764, 67, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7765, 67, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (7766, 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 (7749, 68, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7750, 68, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (7767, 68, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7768, 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 (7751, 69, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7752, 69, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (7753, 69, 'arg_2', 'any', 0, 0, 1, 2); +insert into sys.args values (7769, 69, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7770, 69, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (7771, 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 (7754, 70, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7755, 70, 'arg_1', 'any', 0, 0, 1, 1); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list