Changeset: 8ad9a1fcfab2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8ad9a1fcfab2 Modified Files: sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 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.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit 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-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 Branch: Oct2020 Log Message:
Approve upgrades. diffs (truncated from 145909 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 @@ -40,4031 +40,4260 @@ insert into sys.types values (16, 'lng', insert into sys.types values (17, 'hge', 'decimal', 38, 1, 10, 10, 2000); insert into sys.types values (18, 'flt', 'real', 24, 2, 2, 11, 2000); insert into sys.types values (19, 'dbl', 'double', 53, 2, 2, 11, 2000); -insert into sys.types values (20, 'int', 'month_interval', 32, 0, 2, 8, 2000); -insert into sys.types values (21, 'lng', 'sec_interval', 13, 1, 10, 9, 2000); -insert into sys.types values (22, 'daytime', 'time', 7, 0, 0, 12, 2000); -insert into sys.types values (23, 'daytime', 'timetz', 7, 1, 0, 13, 2000); -insert into sys.types values (24, 'date', 'date', 0, 0, 0, 14, 2000); -insert into sys.types values (25, 'timestamp', 'timestamp', 7, 0, 0, 15, 2000); -insert into sys.types values (26, 'timestamp', 'timestamptz', 7, 1, 0, 16, 2000); -insert into sys.types values (27, 'blob', 'blob', 0, 0, 0, 5, 2000); -insert into sys.types values (30, 'wkb', 'geometry', 0, 0, 0, 17, 2000); -insert into sys.types values (31, 'wkba', 'geometrya', 0, 0, 0, 18, 2000); -insert into sys.types values (32, 'mbr', 'mbr', 0, 0, 0, 18, 2000); +insert into sys.types values (20, 'int', 'month_interval', 3, 0, 10, 8, 2000); +insert into sys.types values (21, 'lng', 'day_interval', 4, 0, 10, 9, 2000); +insert into sys.types values (22, 'lng', 'sec_interval', 13, 1, 10, 9, 2000); +insert into sys.types values (23, 'daytime', 'time', 7, 0, 0, 12, 2000); +insert into sys.types values (24, 'daytime', 'timetz', 7, 1, 0, 13, 2000); +insert into sys.types values (25, 'date', 'date', 0, 0, 0, 14, 2000); +insert into sys.types values (26, 'timestamp', 'timestamp', 7, 0, 0, 15, 2000); +insert into sys.types values (27, 'timestamp', 'timestamptz', 7, 1, 0, 16, 2000); +insert into sys.types values (28, 'blob', 'blob', 0, 0, 0, 5, 2000); +insert into sys.types values (31, 'wkb', 'geometry', 0, 0, 0, 17, 2000); +insert into sys.types values (32, 'wkba', 'geometrya', 0, 0, 0, 18, 2000); +insert into sys.types values (33, 'mbr', 'mbr', 0, 0, 0, 18, 2000); delete from sys.functions where id < 2000; delete from sys.args where func_id not in (select id from sys.functions); -insert into sys.functions values (28, 'length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (34778, 28, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (34779, 28, 'arg_1', 'blob', 0, 0, 1, 1); -insert into sys.functions values (29, 'octet_length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (34780, 29, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (34781, 29, 'arg_1', 'blob', 0, 0, 1, 1); -insert into sys.functions values (33, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34782, 33, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34783, 33, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34784, 33, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (29, 'length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (34778, 29, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (34779, 29, 'arg_1', 'blob', 0, 0, 1, 1); +insert into sys.functions values (30, 'octet_length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (34780, 30, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (34781, 30, 'arg_1', 'blob', 0, 0, 1, 1); insert into sys.functions values (34, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34785, 34, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34786, 34, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34787, 34, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (35, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34788, 35, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34789, 35, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34790, 35, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (34782, 34, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34783, 34, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34784, 34, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (35, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (34785, 35, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34786, 35, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34787, 35, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (36, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34791, 36, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34792, 36, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34793, 36, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (37, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34794, 37, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34795, 37, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34796, 37, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (34788, 36, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34789, 36, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34790, 36, 'arg_2', 'geometry', 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 (34791, 37, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34792, 37, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34793, 37, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (38, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34797, 38, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34798, 38, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34799, 38, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (39, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34800, 39, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34801, 39, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34802, 39, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (34794, 38, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34795, 38, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34796, 38, 'arg_2', 'geometry', 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 (34797, 39, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34798, 39, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34799, 39, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (40, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34803, 40, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34804, 40, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34805, 40, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (41, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34806, 41, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34807, 41, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34808, 41, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (34800, 40, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34801, 40, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34802, 40, 'arg_2', 'geometry', 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 (34803, 41, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34804, 41, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34805, 41, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (42, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34809, 42, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34810, 42, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34811, 42, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (43, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34812, 43, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34813, 43, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34814, 43, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (34806, 42, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34807, 42, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34808, 42, 'arg_2', 'geometry', 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 (34809, 43, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34810, 43, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34811, 43, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (44, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34815, 44, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34816, 44, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34817, 44, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (45, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34818, 45, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34819, 45, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34820, 45, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (34812, 44, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34813, 44, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34814, 44, 'arg_2', 'geometry', 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 (34815, 45, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34816, 45, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34817, 45, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (46, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34821, 46, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34822, 46, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34823, 46, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (47, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34824, 47, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34825, 47, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34826, 47, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (34818, 46, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34819, 46, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34820, 46, 'arg_2', 'geometry', 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 (34821, 47, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34822, 47, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34823, 47, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (48, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34827, 48, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34828, 48, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34829, 48, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (49, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34830, 49, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34831, 49, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34832, 49, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (34824, 48, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34825, 48, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34826, 48, 'arg_2', 'geometry', 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 (34827, 49, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34828, 49, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34829, 49, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (50, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34833, 50, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34834, 50, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34835, 50, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (51, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34836, 51, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34837, 51, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34838, 51, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (34830, 50, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34831, 50, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34832, 50, 'arg_2', 'geometry', 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 (34833, 51, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34834, 51, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34835, 51, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (52, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34839, 52, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34840, 52, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34841, 52, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (53, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34842, 53, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34843, 53, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34844, 53, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (34836, 52, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34837, 52, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34838, 52, 'arg_2', 'geometry', 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 (34839, 53, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34840, 53, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34841, 53, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (54, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34845, 54, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34846, 54, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34847, 54, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (55, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34848, 55, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34849, 55, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34850, 55, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (34842, 54, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34843, 54, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34844, 54, 'arg_2', 'geometry', 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 (34845, 55, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34846, 55, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34847, 55, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (56, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34851, 56, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34852, 56, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34853, 56, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (57, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34854, 57, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (34855, 57, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34856, 57, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (34848, 56, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34849, 56, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34850, 56, 'arg_2', 'geometry', 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 (34851, 57, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34852, 57, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34853, 57, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (58, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34857, 58, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (34858, 58, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34859, 58, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (59, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34860, 59, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34861, 59, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34862, 59, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (34854, 58, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (34855, 58, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34856, 58, 'arg_2', 'geometry', 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 (34857, 59, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (34858, 59, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34859, 59, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (60, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34863, 60, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34864, 60, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34865, 60, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (61, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34866, 61, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34867, 61, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (34868, 61, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (34860, 60, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34861, 60, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34862, 60, 'arg_2', 'geometry', 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 (34863, 61, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34864, 61, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34865, 61, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (62, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34869, 62, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34870, 62, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (34871, 62, 'arg_2', 'mbr', 0, 0, 1, 2); -insert into sys.functions values (63, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (34872, 63, 'res_0', 'tinyint', 8, 0, 0, 0); -insert into sys.args values (34873, 63, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (34866, 62, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34867, 62, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (34868, 62, 'arg_2', 'geometry', 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 (34869, 63, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (34870, 63, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (34871, 63, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (64, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (34874, 64, 'res_0', 'smallint', 16, 0, 0, 0); -insert into sys.args values (34875, 64, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (34872, 64, 'res_0', 'tinyint', 8, 0, 0, 0); +insert into sys.args values (34873, 64, 'arg_1', 'any', 0, 0, 1, 1); insert into sys.functions values (65, 'grouping', '', '', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (34876, 65, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (34877, 65, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (34874, 65, 'res_0', 'smallint', 16, 0, 0, 0); +insert into sys.args values (34875, 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 (34878, 66, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (34879, 66, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (34876, 66, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (34877, 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 (34880, 67, 'res_0', 'hugeint', 128, 0, 0, 0); -insert into sys.args values (34881, 67, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (68, 'not_unique', 'not_unique', 'aggr', 0, 3, false, false, false, 2000, true, true); -insert into sys.args values (34882, 68, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (34883, 68, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.functions values (69, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34884, 69, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (34885, 69, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (70, 'rotate_xor_hash', 'rotate_xor_hash', 'calc', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (34886, 70, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (34887, 70, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (34888, 70, 'arg_2', 'int', 32, 0, 1, 2); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
