Changeset: a8e336cb1a87 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a8e336cb1a87 Modified Files: sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.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.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.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.int128 Branch: subjoin Log Message:
merged with default diffs (truncated from 18042 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 @@ -54,7 +54,7 @@ CREATE TABLE sys.function_languages ( language_id SMALLINT NOT NULL PRIMARY KEY, language_name VARCHAR(20) NOT NULL UNIQUE); INSERT INTO sys.function_languages (language_id, language_name) VALUES -(0, 'Internal C'), (1, 'MAL'), (2, 'SQL'), (3, 'R'), (4, 'C'), (5, 'Java'), (6, 'Python'), (7, 'Python Mapped'); +(0, 'Internal C'), (1, 'MAL'), (2, 'SQL'), (3, 'R'), (6, 'Python'), (7, 'Python Mapped'), (8, 'Python2'), (9, 'Python2 Mapped'), (10, 'Python3'), (11, 'Python3 Mapped'); ALTER TABLE sys.function_languages SET READ ONLY; CREATE TABLE sys.key_types ( key_type_id SMALLINT NOT NULL PRIMARY KEY, diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out @@ -54,7 +54,7 @@ CREATE TABLE sys.function_languages ( language_id SMALLINT NOT NULL PRIMARY KEY, language_name VARCHAR(20) NOT NULL UNIQUE); INSERT INTO sys.function_languages (language_id, language_name) VALUES -(0, 'Internal C'), (1, 'MAL'), (2, 'SQL'), (3, 'R'), (4, 'C'), (5, 'Java'), (6, 'Python'), (7, 'Python Mapped'); +(0, 'Internal C'), (1, 'MAL'), (2, 'SQL'), (3, 'R'), (6, 'Python'), (7, 'Python Mapped'), (8, 'Python2'), (9, 'Python2 Mapped'), (10, 'Python3'), (11, 'Python3 Mapped'); ALTER TABLE sys.function_languages SET READ ONLY; CREATE TABLE sys.key_types ( key_type_id SMALLINT NOT NULL PRIMARY KEY, 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 @@ -5282,7 +5282,7 @@ CREATE TABLE sys.function_languages ( language_id SMALLINT NOT NULL PRIMARY KEY, language_name VARCHAR(20) NOT NULL UNIQUE); INSERT INTO sys.function_languages (language_id, language_name) VALUES -(0, 'Internal C'), (1, 'MAL'), (2, 'SQL'), (3, 'R'), (4, 'C'), (5, 'Java'), (6, 'Python'), (7, 'Python Mapped'); +(0, 'Internal C'), (1, 'MAL'), (2, 'SQL'), (3, 'R'), (6, 'Python'), (7, 'Python Mapped'), (8, 'Python2'), (9, 'Python2 Mapped'), (10, 'Python3'), (11, 'Python3 Mapped'); ALTER TABLE sys.function_languages SET READ ONLY; CREATE TABLE sys.key_types ( key_type_id SMALLINT NOT NULL PRIMARY KEY, diff --git a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 @@ -53,7 +53,7 @@ CREATE TABLE sys.function_languages ( language_id SMALLINT NOT NULL PRIMARY KEY, language_name VARCHAR(20) NOT NULL UNIQUE); INSERT INTO sys.function_languages (language_id, language_name) VALUES -(0, 'Internal C'), (1, 'MAL'), (2, 'SQL'), (3, 'R'), (4, 'C'), (5, 'Java'), (6, 'Python'), (7, 'Python Mapped'); +(0, 'Internal C'), (1, 'MAL'), (2, 'SQL'), (3, 'R'), (6, 'Python'), (7, 'Python Mapped'), (8, 'Python2'), (9, 'Python2 Mapped'), (10, 'Python3'), (11, 'Python3 Mapped'); ALTER TABLE sys.function_languages SET READ ONLY; CREATE TABLE sys.key_types ( key_type_id SMALLINT NOT NULL PRIMARY KEY, diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out --- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out +++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out @@ -53,7 +53,7 @@ CREATE TABLE sys.function_languages ( language_id SMALLINT NOT NULL PRIMARY KEY, language_name VARCHAR(20) NOT NULL UNIQUE); INSERT INTO sys.function_languages (language_id, language_name) VALUES -(0, 'Internal C'), (1, 'MAL'), (2, 'SQL'), (3, 'R'), (4, 'C'), (5, 'Java'), (6, 'Python'), (7, 'Python Mapped'); +(0, 'Internal C'), (1, 'MAL'), (2, 'SQL'), (3, 'R'), (6, 'Python'), (7, 'Python Mapped'), (8, 'Python2'), (9, 'Python2 Mapped'), (10, 'Python3'), (11, 'Python3 Mapped'); ALTER TABLE sys.function_languages SET READ ONLY; CREATE TABLE sys.key_types ( key_type_id SMALLINT NOT NULL PRIMARY KEY, 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 @@ -63,5142 +63,5142 @@ insert into sys.types values (31, '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 (32, 'mbr_overlap', 'mbrOverlaps', 'geom', 0, 1, false, false, false, 2000); -insert into sys.args values (7594, 32, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7595, 32, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7596, 32, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7598, 32, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7599, 32, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7600, 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 (7597, 33, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7598, 33, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7599, 33, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7601, 33, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7602, 33, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7603, 33, 'arg_2', 'mbr', 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 (7600, 34, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7601, 34, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7602, 34, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7604, 34, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7605, 34, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7606, 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 (7603, 35, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7604, 35, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7605, 35, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7607, 35, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7608, 35, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7609, 35, 'arg_2', 'mbr', 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 (7606, 36, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7607, 36, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7608, 36, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7610, 36, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7611, 36, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7612, 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 (7609, 37, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7610, 37, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7611, 37, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7613, 37, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7614, 37, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7615, 37, 'arg_2', 'mbr', 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 (7612, 38, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7613, 38, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7614, 38, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7616, 38, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7617, 38, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7618, 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 (7615, 39, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7616, 39, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7617, 39, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7619, 39, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7620, 39, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7621, 39, 'arg_2', 'mbr', 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 (7618, 40, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7619, 40, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7620, 40, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7622, 40, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7623, 40, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7624, 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 (7621, 41, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7622, 41, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7623, 41, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7625, 41, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7626, 41, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7627, 41, 'arg_2', 'mbr', 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 (7624, 42, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7625, 42, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7626, 42, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7628, 42, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7629, 42, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7630, 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 (7627, 43, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7628, 43, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7629, 43, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7631, 43, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7632, 43, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7633, 43, 'arg_2', 'mbr', 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 (7630, 44, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7631, 44, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7632, 44, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7634, 44, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7635, 44, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7636, 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 (7633, 45, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7634, 45, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7635, 45, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7637, 45, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7638, 45, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7639, 45, 'arg_2', 'mbr', 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 (7636, 46, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7637, 46, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7638, 46, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7640, 46, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7641, 46, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7642, 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 (7639, 47, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7640, 47, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7641, 47, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7643, 47, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7644, 47, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7645, 47, 'arg_2', 'mbr', 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 (7642, 48, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7643, 48, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7644, 48, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7646, 48, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7647, 48, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7648, 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 (7645, 49, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7646, 49, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7647, 49, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7649, 49, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7650, 49, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7651, 49, 'arg_2', 'mbr', 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 (7648, 50, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7649, 50, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7650, 50, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7652, 50, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7653, 50, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7654, 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 (7651, 51, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7652, 51, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7653, 51, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7655, 51, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7656, 51, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7657, 51, 'arg_2', 'mbr', 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 (7654, 52, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7655, 52, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7656, 52, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7658, 52, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7659, 52, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7660, 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 (7657, 53, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7658, 53, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7659, 53, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7661, 53, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7662, 53, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7663, 53, 'arg_2', 'mbr', 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 (7660, 54, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7661, 54, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7662, 54, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7664, 54, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7665, 54, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7666, 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 (7663, 55, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7664, 55, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7665, 55, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7667, 55, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7668, 55, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7669, 55, 'arg_2', 'mbr', 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 (7666, 56, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (7667, 56, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7668, 56, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7670, 56, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (7671, 56, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7672, 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 (7669, 57, 'res_0', 'double', 53, 0, 0, 0); -insert into sys.args values (7670, 57, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7671, 57, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7673, 57, 'res_0', 'double', 53, 0, 0, 0); +insert into sys.args values (7674, 57, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7675, 57, 'arg_2', 'mbr', 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 (7672, 58, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7673, 58, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7674, 58, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7676, 58, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7677, 58, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7678, 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 (7675, 59, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7676, 59, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7677, 59, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7679, 59, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7680, 59, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7681, 59, 'arg_2', 'mbr', 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 (7678, 60, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7679, 60, 'arg_1', 'geometry', 0, 0, 1, 1); -insert into sys.args values (7680, 60, 'arg_2', 'geometry', 0, 0, 1, 2); +insert into sys.args values (7682, 60, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7683, 60, 'arg_1', 'geometry', 0, 0, 1, 1); +insert into sys.args values (7684, 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 (7681, 61, 'res_0', 'boolean', 1, 0, 0, 0); -insert into sys.args values (7682, 61, 'arg_1', 'mbr', 0, 0, 1, 1); -insert into sys.args values (7683, 61, 'arg_2', 'mbr', 0, 0, 1, 2); +insert into sys.args values (7685, 61, 'res_0', 'boolean', 1, 0, 0, 0); +insert into sys.args values (7686, 61, 'arg_1', 'mbr', 0, 0, 1, 1); +insert into sys.args values (7687, 61, 'arg_2', 'mbr', 0, 0, 1, 2); insert into sys.functions values (63, 'not_uniques', 'not_uniques', 'sql', 0, 1, false, false, false, 2000); -insert into sys.args values (7684, 63, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (7685, 63, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (7688, 63, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (7689, 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 (7686, 64, 'res_0', 'oid', 63, 0, 0, 0); -insert into sys.args values (7687, 64, 'arg_1', 'oid', 63, 0, 1, 1); +insert into sys.args values (7690, 64, 'res_0', 'oid', 63, 0, 0, 0); +insert into sys.args values (7691, 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 (7688, 65, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (7689, 65, 'arg_1', 'any', 0, 0, 1, 1); +insert into sys.args values (7692, 65, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (7693, 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 (7690, 66, 'res_0', 'bigint', 64, 0, 0, 0); -insert into sys.args values (7691, 66, 'arg_1', 'bigint', 64, 0, 1, 1); -insert into sys.args values (7692, 66, 'arg_2', 'int', 32, 0, 1, 2); -insert into sys.args values (7693, 66, 'arg_3', 'any', 0, 0, 1, 3); +insert into sys.args values (7694, 66, 'res_0', 'bigint', 64, 0, 0, 0); +insert into sys.args values (7695, 66, 'arg_1', 'bigint', 64, 0, 1, 1); +insert into sys.args values (7696, 66, 'arg_2', 'int', 32, 0, 1, 2); +insert into sys.args values (7697, 66, 'arg_3', 'any', 0, 0, 1, 3); _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
