Changeset: 9f1287a18e29 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9f1287a18e29 Modified Files: sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 Branch: default Log Message:
Approve after changeset 2072c4a5a078. diffs (truncated from 19206 to 300 lines): diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 --- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 +++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 @@ -35,5165 +35,5164 @@ insert into sys.types values (8, 'bte', 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, 'lng', 'wrd', 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', 32, 0, 2, 8, 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, 12, 2000); -insert into sys.types values (25, 'date', 'date', 0, 0, 0, 13, 2000); -insert into sys.types values (26, 'timestamp', 'timestamp', 7, 0, 0, 14, 2000); -insert into sys.types values (27, 'timestamp', 'timestamptz', 7, 1, 0, 14, 2000); -insert into sys.types values (28, 'sqlblob', 'blob', 0, 0, 0, 5, 2000); -insert into sys.types values (29, 'wkb', 'geometry', 0, 0, 0, 15, 2000); -insert into sys.types values (30, 'wkba', 'geometrya', 0, 0, 0, 16, 2000); -insert into sys.types values (31, 'mbr', 'mbr', 0, 0, 0, 16, 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', 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, 12, 2000); +insert into sys.types values (24, 'date', 'date', 0, 0, 0, 13, 2000); +insert into sys.types values (25, 'timestamp', 'timestamp', 7, 0, 0, 14, 2000); +insert into sys.types values (26, 'timestamp', 'timestamptz', 7, 1, 0, 14, 2000); +insert into sys.types values (27, 'sqlblob', 'blob', 0, 0, 0, 5, 2000); +insert into sys.types values (28, 'wkb', 'geometry', 0, 0, 0, 15, 2000); +insert into sys.types values (29, 'wkba', 'geometrya', 0, 0, 0, 16, 2000); +insert into sys.types values (30, 'mbr', 'mbr', 0, 0, 0, 16, 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 (31, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000); +insert into sys.args values (12114, 31, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12115, 31, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12116, 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 (12114, 32, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12115, 32, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12116, 32, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (33, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12117, 33, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12118, 33, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12119, 33, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12117, 32, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12118, 32, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12119, 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 (12120, 33, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12121, 33, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12122, 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 (12120, 34, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12121, 34, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12122, 34, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (35, 'mbr_above', 'mbrAbove', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12123, 35, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12124, 35, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12125, 35, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12123, 34, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12124, 34, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12125, 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 (12126, 35, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12127, 35, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12128, 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 (12126, 36, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12127, 36, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12128, 36, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (37, 'mbr_below', 'mbrBelow', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12129, 37, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12130, 37, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12131, 37, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12129, 36, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12130, 36, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12131, 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 (12132, 37, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12133, 37, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12134, 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 (12132, 38, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12133, 38, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12134, 38, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (39, 'mbr_right', 'mbrRight', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12135, 39, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12136, 39, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12137, 39, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12135, 38, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12136, 38, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12137, 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 (12138, 39, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12139, 39, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12140, 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 (12138, 40, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12139, 40, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12140, 40, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (41, 'mbr_left', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12141, 41, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12142, 41, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12143, 41, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12141, 40, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12142, 40, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12143, 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 (12144, 41, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12145, 41, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12146, 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 (12144, 42, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12145, 42, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12146, 42, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (43, 'mbr_overlap_or_above', 'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12147, 43, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12148, 43, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12149, 43, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12147, 42, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12148, 42, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12149, 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 (12150, 43, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12151, 43, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12152, 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 (12150, 44, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12151, 44, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12152, 44, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (45, 'mbr_overlap_or_below', 'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12153, 45, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12154, 45, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12155, 45, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12153, 44, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12154, 44, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12155, 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 (12156, 45, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12157, 45, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12158, 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 (12156, 46, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12157, 46, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12158, 46, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (47, 'mbr_overlap_or_right', 'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12159, 47, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12160, 47, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12161, 47, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12159, 46, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12160, 46, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12161, 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 (12162, 47, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12163, 47, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12164, 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 (12162, 48, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12163, 48, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12164, 48, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (49, 'mbr_overlap_or_left', 'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12165, 49, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12166, 49, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12167, 49, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12165, 48, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12166, 48, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12167, 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 (12168, 49, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12169, 49, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12170, 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 (12168, 50, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12169, 50, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12170, 50, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (51, 'mbr_contains', 'mbrContains', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12171, 51, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12172, 51, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12173, 51, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12171, 50, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12172, 50, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12173, 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 (12174, 51, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12175, 51, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12176, 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 (12174, 52, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12175, 52, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12176, 52, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (53, 'mbr_contained', 'mbrContained', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12177, 53, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12178, 53, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12179, 53, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12177, 52, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12178, 52, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12179, 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 (12180, 53, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12181, 53, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12182, 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 (12180, 54, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12181, 54, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12182, 54, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (55, 'mbr_equal', 'mbrEqual', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12183, 55, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12184, 55, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12185, 55, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12183, 54, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12184, 54, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12185, 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 (12186, 55, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (12187, 55, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12188, 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 (12186, 56, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (12187, 56, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12188, 56, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (57, 'mbr_distance', 'mbrDistance', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12189, 57, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (12190, 57, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12191, 57, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12189, 56, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (12190, 56, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12191, 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 (12192, 57, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12193, 57, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12194, 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 (12192, 58, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12193, 58, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12194, 58, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (59, 'left_shift', 'mbrLeft', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12195, 59, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12196, 59, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12197, 59, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12195, 58, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12196, 58, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12197, 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 (12198, 59, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12199, 59, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (12200, 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 (12198, 60, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12199, 60, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (12200, 60, 'arg_2', 'geometry', 0, 0, 1, 2); -insert into sys.functions values (61, 'right_shift', 'mbrRight', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (12201, 61, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12202, 61, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (12203, 61, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (12201, 60, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (12202, 60, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (12203, 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 (12204, 62, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (12205, 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 (12204, 63, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (12205, 63, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.functions values (64, 'not_uniques', 'not_uniques', 'sql', 0, 1, false, false, false, 2000); -insert into sys.args values (12206, 64, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (12207, 64, 'arg_1', 'oid', 63, 0, 1, 1); -insert into sys.functions values (65, 'hash', 'hash', 'mkey', 0, 1, false, false, false, 2000); -insert into sys.args values (12208, 65, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (12209, 65, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.functions values (66, 'rotate_xor_hash', 'rotate_xor_hash', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (12210, 66, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (12211, 66, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (12212, 66, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (12213, 66, 'arg_3', 'any', 0, 0, 1, 3); -insert into sys.functions values (67, '=', '=', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (12214, 67, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12215, 67, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (12216, 67, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (68, '<>', '!=', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (12217, 68, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (12218, 68, 'arg_1', 'any', 0, 0, 1, 1); -insert into sys.args values (12219, 68, 'arg_2', 'any', 0, 0, 1, 2); -insert into sys.functions values (69, 'isnull', 'isnil', 'calc', 0, 1, false, false, false, 2000); -insert into sys.args values (12220, 69, 'res_0', 'boolean', 1, 0, 0, 0); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
