Changeset: 9100cdc12799 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9100cdc12799 Modified Files: sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 Branch: default Log Message:
Approve ppc64 upgrades. diffs (truncated from 24979 to 300 lines): diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 @@ -2,4208 +2,4222 @@ Running database upgrade commands: set schema "sys"; delete from sys.dependencies where id < 2000; delete from sys.types where id < 2000; -insert into sys.types values (0, 'void', 'any', 0, 0, 0, 0, 2000); -insert into sys.types values (1, 'bat', 'table', 0, 0, 0, 1, 2000); -insert into sys.types values (2, 'ptr', 'ptr', 0, 0, 0, 1, 2000); -insert into sys.types values (3, 'bit', 'boolean', 1, 0, 2, 2, 2000); -insert into sys.types values (4, 'str', 'char', 0, 0, 0, 3, 2000); -insert into sys.types values (5, 'str', 'varchar', 0, 0, 0, 4, 2000); -insert into sys.types values (6, 'str', 'clob', 0, 0, 0, 4, 2000); -insert into sys.types values (7, 'oid', 'oid', 63, 0, 2, 6, 2000); -insert into sys.types values (8, 'bte', 'tinyint', 8, 1, 2, 7, 2000); -insert into sys.types values (9, 'sht', 'smallint', 16, 1, 2, 7, 2000); -insert into sys.types values (10, 'int', 'int', 32, 1, 2, 7, 2000); -insert into sys.types values (11, 'lng', 'bigint', 64, 1, 2, 7, 2000); -insert into sys.types values (12, 'hge', 'hugeint', 128, 1, 2, 7, 2000); -insert into sys.types values (13, 'bte', 'decimal', 2, 1, 10, 10, 2000); -insert into sys.types values (14, 'sht', 'decimal', 4, 1, 10, 10, 2000); -insert into sys.types values (15, 'int', 'decimal', 9, 1, 10, 10, 2000); -insert into sys.types values (16, 'lng', 'decimal', 18, 1, 10, 10, 2000); -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', 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); +insert into sys.types values (1, 'void', 'any', 0, 0, 0, 0, 2000); +insert into sys.types values (2, 'bat', 'table', 0, 0, 0, 1, 2000); +insert into sys.types values (3, 'ptr', 'ptr', 0, 0, 0, 1, 2000); +insert into sys.types values (4, 'bit', 'boolean', 1, 0, 2, 2, 2000); +insert into sys.types values (5, 'str', 'clob', 0, 0, 0, 4, 2000); +insert into sys.types values (6, 'str', 'varchar', 0, 0, 0, 4, 2000); +insert into sys.types values (7, 'str', 'char', 0, 0, 0, 3, 2000); +insert into sys.types values (8, 'oid', 'oid', 63, 0, 2, 6, 2000); +insert into sys.types values (9, 'bte', 'tinyint', 8, 1, 2, 7, 2000); +insert into sys.types values (10, 'sht', 'smallint', 16, 1, 2, 7, 2000); +insert into sys.types values (11, 'int', 'int', 32, 1, 2, 7, 2000); +insert into sys.types values (12, 'lng', 'bigint', 64, 1, 2, 7, 2000); +insert into sys.types values (13, 'hge', 'hugeint', 128, 1, 2, 7, 2000); +insert into sys.types values (14, 'bte', 'decimal', 2, 1, 10, 10, 2000); +insert into sys.types values (15, 'sht', 'decimal', 4, 1, 10, 10, 2000); +insert into sys.types values (16, 'int', 'decimal', 9, 1, 10, 10, 2000); +insert into sys.types values (17, 'lng', 'decimal', 18, 1, 10, 10, 2000); +insert into sys.types values (18, 'hge', 'decimal', 38, 1, 10, 10, 2000); +insert into sys.types values (19, 'flt', 'real', 24, 2, 2, 11, 2000); +insert into sys.types values (20, 'dbl', 'double', 53, 2, 2, 11, 2000); +insert into sys.types values (21, 'int', 'month_interval', 3, 0, 10, 8, 2000); +insert into sys.types values (22, 'lng', 'day_interval', 4, 0, 10, 9, 2000); +insert into sys.types values (23, 'lng', 'sec_interval', 13, 1, 10, 9, 2000); +insert into sys.types values (24, 'daytime', 'time', 7, 0, 0, 12, 2000); +insert into sys.types values (25, 'daytime', 'timetz', 7, 1, 0, 13, 2000); +insert into sys.types values (26, 'date', 'date', 0, 0, 0, 14, 2000); +insert into sys.types values (27, 'timestamp', 'timestamp', 7, 0, 0, 15, 2000); +insert into sys.types values (28, 'timestamp', 'timestamptz', 7, 1, 0, 16, 2000); +insert into sys.types values (29, 'blob', 'blob', 0, 0, 0, 5, 2000); +insert into sys.types values (32, 'wkb', 'geometry', 0, 0, 0, 17, 2000); +insert into sys.types values (33, 'wkba', 'geometrya', 0, 0, 0, 18, 2000); +insert into sys.types values (34, '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 (29, 'length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true, false); -insert into sys.args values (41370, 29, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (41371, 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 (41372, 30, 'res_0', 'int', 32, 0, 0, 0); -insert into sys.args values (41373, 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 (41374, 34, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41375, 34, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41376, 34, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (30, 'length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (41391, 30, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (41392, 30, 'arg_1', 'blob', 0, 0, 1, 1); +insert into sys.functions values (31, 'octet_length', 'nitems', 'blob', 0, 1, false, false, false, 2000, true, false); +insert into sys.args values (41393, 31, 'res_0', 'int', 32, 0, 0, 0); +insert into sys.args values (41394, 31, 'arg_1', 'blob', 0, 0, 1, 1); insert into sys.functions values (35, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (41377, 35, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41378, 35, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (41379, 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 (41380, 36, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41381, 36, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41382, 36, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (41395, 35, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41396, 35, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (41397, 35, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (36, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (41398, 36, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41399, 36, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (41400, 36, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (37, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (41383, 37, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41384, 37, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (41385, 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 (41386, 38, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41387, 38, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41388, 38, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (41401, 37, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41402, 37, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (41403, 37, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (38, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (41404, 38, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41405, 38, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (41406, 38, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (39, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (41389, 39, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41390, 39, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (41391, 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 (41392, 40, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41393, 40, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41394, 40, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (41407, 39, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41408, 39, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (41409, 39, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (40, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (41410, 40, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41411, 40, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (41412, 40, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (41, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (41395, 41, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41396, 41, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (41397, 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 (41398, 42, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41399, 42, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41400, 42, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (41413, 41, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41414, 41, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (41415, 41, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (42, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (41416, 42, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41417, 42, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (41418, 42, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (43, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (41401, 43, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41402, 43, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (41403, 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 (41404, 44, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41405, 44, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41406, 44, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (41419, 43, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41420, 43, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (41421, 43, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (44, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (41422, 44, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41423, 44, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (41424, 44, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (45, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (41407, 45, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41408, 45, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (41409, 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 (41410, 46, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41411, 46, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41412, 46, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (41425, 45, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41426, 45, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (41427, 45, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (46, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (41428, 46, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41429, 46, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (41430, 46, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (47, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (41413, 47, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41414, 47, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (41415, 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 (41416, 48, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41417, 48, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41418, 48, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (41431, 47, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41432, 47, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (41433, 47, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (48, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (41434, 48, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41435, 48, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (41436, 48, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (49, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (41419, 49, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41420, 49, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (41421, 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 (41422, 50, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41423, 50, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41424, 50, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (41437, 49, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41438, 49, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (41439, 49, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (50, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (41440, 50, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41441, 50, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (41442, 50, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (51, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (41425, 51, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41426, 51, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (41427, 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 (41428, 52, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41429, 52, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41430, 52, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (41443, 51, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41444, 51, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (41445, 51, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (52, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (41446, 52, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41447, 52, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (41448, 52, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (53, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (41431, 53, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41432, 53, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (41433, 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 (41434, 54, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41435, 54, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41436, 54, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (41449, 53, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41450, 53, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (41451, 53, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (54, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (41452, 54, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41453, 54, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (41454, 54, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (55, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (41437, 55, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41438, 55, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (41439, 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 (41440, 56, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41441, 56, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41442, 56, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (41455, 55, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41456, 55, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (41457, 55, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (56, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (41458, 56, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41459, 56, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (41460, 56, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (57, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (41443, 57, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41444, 57, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (41445, 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 (41446, 58, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (41447, 58, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41448, 58, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (41461, 57, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41462, 57, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (41463, 57, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (58, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (41464, 58, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41465, 58, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (41466, 58, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (59, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (41449, 59, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (41450, 59, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (41451, 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 (41452, 60, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41453, 60, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41454, 60, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (41467, 59, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (41468, 59, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (41469, 59, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (60, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (41470, 60, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (41471, 60, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (41472, 60, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (61, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); -insert into sys.args values (41455, 61, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41456, 61, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (41457, 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 (41458, 62, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (41459, 62, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (41460, 62, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (41473, 61, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41474, 61, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (41475, 61, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.functions values (62, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000, true, true); +insert into sys.args values (41476, 62, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (41477, 62, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (41478, 62, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (63, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000, true, true); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
