Changeset: 7d1528ea4e94 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7d1528ea4e94
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.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.powerpc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.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/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/dump.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/dump.stable.out
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
sql/test/testdb-upgrade/Tests/upgrade.stable.out.powerpc64.int128
Branch: Apr2019
Log Message:
Fix and approve upgrade from Apr2018 release.
diffs (truncated from 142633 to 300 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -191,7 +191,6 @@ sql_update_hugeint(Client c, mvc *sql)
size_t bufsize = 8192, pos = 0;
char *buf, *err;
char *schema;
- sql_schema *s;
if ((err = sql_fix_system_tables(c, sql)) != NULL)
return err;
@@ -201,21 +200,18 @@ sql_update_hugeint(Client c, mvc *sql)
schema = stack_get_string(sql, "current_schema");
- s = mvc_bind_schema(sql, "sys");
-
pos += snprintf(buf + pos, bufsize - pos, "set schema \"sys\";\n");
+ /* 80_udf_hge.sql */
pos += snprintf(buf + pos, bufsize - pos,
"create function fuse(one bigint, two bigint)\n"
- "returns hugeint\n"
- "external name udf.fuse;\n");
+ "returns hugeint external name udf.fuse;\n");
+ /* 90_generator_hge.sql */
pos += snprintf(buf + pos, bufsize - pos,
"create function sys.generate_series(first hugeint,
\"limit\" hugeint)\n"
"returns table (value hugeint)\n"
- "external name generator.series;\n");
-
- pos += snprintf(buf + pos, bufsize - pos,
+ "external name generator.series;\n"
"create function sys.generate_series(first hugeint,
\"limit\" hugeint, stepsize hugeint)\n"
"returns table (value hugeint)\n"
"external name generator.series;\n");
@@ -223,58 +219,36 @@ sql_update_hugeint(Client c, mvc *sql)
/* 39_analytics_hge.sql */
pos += snprintf(buf + pos, bufsize - pos,
"create aggregate stddev_samp(val HUGEINT) returns
DOUBLE\n"
- " external name \"aggr\".\"stdev\";\n"
+ "\texternal name \"aggr\".\"stdev\";\n"
+ "GRANT EXECUTE ON AGGREGATE stddev_samp(HUGEINT) TO
PUBLIC;\n"
"create aggregate stddev_pop(val HUGEINT) returns
DOUBLE\n"
- " external name \"aggr\".\"stdevp\";\n"
+ "\texternal name \"aggr\".\"stdevp\";\n"
+ "GRANT EXECUTE ON AGGREGATE stddev_pop(HUGEINT) TO
PUBLIC;\n"
"create aggregate var_samp(val HUGEINT) returns
DOUBLE\n"
- " external name \"aggr\".\"variance\";\n"
+ "\texternal name \"aggr\".\"variance\";\n"
+ "GRANT EXECUTE ON AGGREGATE var_samp(HUGEINT) TO
PUBLIC;\n"
"create aggregate var_pop(val HUGEINT) returns DOUBLE\n"
- " external name \"aggr\".\"variancep\";\n"
+ "\texternal name \"aggr\".\"variancep\";\n"
+ "GRANT EXECUTE ON AGGREGATE var_pop(HUGEINT) TO
PUBLIC;\n"
"create aggregate median(val HUGEINT) returns HUGEINT\n"
- " external name \"aggr\".\"median\";\n"
+ "\texternal name \"aggr\".\"median\";\n"
+ "GRANT EXECUTE ON AGGREGATE median(HUGEINT) TO
PUBLIC;\n"
"create aggregate quantile(val HUGEINT, q DOUBLE)
returns HUGEINT\n"
- " external name \"aggr\".\"quantile\";\n"
+ "\texternal name \"aggr\".\"quantile\";\n"
+ "GRANT EXECUTE ON AGGREGATE quantile(HUGEINT, DOUBLE)
TO PUBLIC;\n"
"create aggregate corr(e1 HUGEINT, e2 HUGEINT) returns
DOUBLE\n"
- " external name \"aggr\".\"corr\";\n");
+ "\texternal name \"aggr\".\"corr\";\n"
+ "GRANT EXECUTE ON AGGREGATE corr(HUGEINT, HUGEINT) TO
PUBLIC;\n");
/* 40_json_hge.sql */
pos += snprintf(buf + pos, bufsize - pos,
"create function json.filter(js json, name hugeint)\n"
- "returns json\n"
- "external name json.filter;\n");
-
- pos += snprintf(buf + pos, bufsize - pos,
- "drop view sys.tablestoragemodel;\n"
- "create view sys.tablestoragemodel\n"
- "as select \"schema\",\"table\",max(count) as
\"count\",\n"
- " sum(columnsize) as columnsize,\n"
- " sum(heapsize) as heapsize,\n"
- " sum(hashes) as hashes,\n"
- " sum(\"imprints\") as \"imprints\",\n"
- " sum(case when sorted = false then 8 * count else 0
end) as auxiliary\n"
- "from sys.storagemodel() group by
\"schema\",\"table\";\n");
+ "returns json external name json.filter;\n"
+ "GRANT EXECUTE ON FUNCTION json.filter(json, hugeint)
TO PUBLIC;\n");
pos += snprintf(buf + pos, bufsize - pos,
"update sys.functions set system = true where name in
('fuse', 'generate_series', 'stddev_samp', 'stddev_pop', 'var_samp', 'var_pop',
'median', 'quantile', 'corr') and schema_id = (select id from sys.schemas where
name = 'sys');\n"
- "update sys.functions set system = true where name =
'filter' and schema_id = (select id from sys.schemas where name = 'json');\n"
- "update sys._tables set system = true where name =
'tablestoragemodel' and schema_id = (select id from sys.schemas where name =
'sys');\n");
-
- if (s != NULL) {
- sql_table *t;
-
- if ((t = mvc_bind_table(sql, s, "tablestoragemodel")) != NULL)
- t->system = 0;
- }
-
- pos += snprintf(buf + pos, bufsize - pos,
- "grant execute on aggregate sys.stddev_samp(hugeint) to
public;\n"
- "grant execute on aggregate sys.stddev_pop(hugeint) to
public;\n"
- "grant execute on aggregate sys.var_samp(hugeint) to
public;\n"
- "grant execute on aggregate sys.var_pop(hugeint) to
public;\n"
- "grant execute on aggregate sys.median(hugeint) to
public;\n"
- "grant execute on aggregate sys.quantile(hugeint,
double) to public;\n"
- "grant execute on aggregate sys.corr(hugeint, hugeint)
to public;\n"
- "grant execute on function json.filter(json, hugeint)
to public;\n");
+ "update sys.functions set system = true where name =
'filter' and schema_id = (select id from sys.schemas where name = 'json');\n");
if (schema)
pos += snprintf(buf + pos, bufsize - pos, "set schema
\"%s\";\n", schema);
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
@@ -16,6166 +16,6 @@ stdout of test 'upgrade` in directory 's
# Listening for connection requests on mapi:monetdb://madrid.da.cwi.nl:39660/
# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-30908/.s.monetdb.39660
# MonetDB/GIS module loaded
-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', 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, 'blob', 'blob', 0, 0, 0, 5, 2000);
-insert into sys.types values (30, 'wkb', 'geometry', 0, 0, 0, 15, 2000);
-insert into sys.types values (31, 'wkba', 'geometrya', 0, 0, 0, 16, 2000);
-insert into sys.types values (32, '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 (28, 'length', 'nitems', 'blob', 0, 1, false,
false, false, 2000, true);
-insert into sys.args values (20672, 28, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (20673, 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);
-insert into sys.args values (20674, 29, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (20675, 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);
-insert into sys.args values (20676, 33, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20677, 33, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20678, 33, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (34, 'mbr_overlap', 'mbrOverlaps', 'geom', 0,
1, false, false, false, 2000, true);
-insert into sys.args values (20679, 34, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20680, 34, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20681, 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);
-insert into sys.args values (20682, 35, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20683, 35, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20684, 35, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (36, 'mbr_above', 'mbrAbove', 'geom', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (20685, 36, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20686, 36, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20687, 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);
-insert into sys.args values (20688, 37, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20689, 37, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20690, 37, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (38, 'mbr_below', 'mbrBelow', 'geom', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (20691, 38, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20692, 38, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20693, 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);
-insert into sys.args values (20694, 39, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20695, 39, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20696, 39, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (40, 'mbr_right', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (20697, 40, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20698, 40, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20699, 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);
-insert into sys.args values (20700, 41, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20701, 41, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20702, 41, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (42, 'mbr_left', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (20703, 42, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20704, 42, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20705, 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);
-insert into sys.args values (20706, 43, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20707, 43, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20708, 43, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (44, 'mbr_overlap_or_above',
'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (20709, 44, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20710, 44, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20711, 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);
-insert into sys.args values (20712, 45, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20713, 45, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20714, 45, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (46, 'mbr_overlap_or_below',
'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (20715, 46, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20716, 46, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20717, 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);
-insert into sys.args values (20718, 47, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20719, 47, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20720, 47, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (48, 'mbr_overlap_or_right',
'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (20721, 48, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20722, 48, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20723, 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);
-insert into sys.args values (20724, 49, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20725, 49, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20726, 49, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (50, 'mbr_overlap_or_left',
'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (20727, 50, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20728, 50, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20729, 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);
-insert into sys.args values (20730, 51, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20731, 51, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20732, 51, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (52, 'mbr_contains', 'mbrContains', 'geom',
0, 1, false, false, false, 2000, true);
-insert into sys.args values (20733, 52, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20734, 52, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20735, 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);
-insert into sys.args values (20736, 53, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20737, 53, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20738, 53, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (54, 'mbr_contained', 'mbrContained', 'geom',
0, 1, false, false, false, 2000, true);
-insert into sys.args values (20739, 54, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20740, 54, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20741, 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);
-insert into sys.args values (20742, 55, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20743, 55, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20744, 55, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (56, 'mbr_equal', 'mbrEqual', 'geom', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (20745, 56, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20746, 56, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20747, 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);
-insert into sys.args values (20748, 57, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (20749, 57, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20750, 57, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (58, 'mbr_distance', 'mbrDistance', 'geom',
0, 1, false, false, false, 2000, true);
-insert into sys.args values (20751, 58, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (20752, 58, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20753, 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);
-insert into sys.args values (20754, 59, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20755, 59, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20756, 59, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (60, 'left_shift', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (20757, 60, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20758, 60, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20759, 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);
-insert into sys.args values (20760, 61, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20761, 61, 'arg_1', 'geometry', 0, 0, 1, 1);
-insert into sys.args values (20762, 61, 'arg_2', 'geometry', 0, 0, 1, 2);
-insert into sys.functions values (62, 'right_shift', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000, true);
-insert into sys.args values (20763, 62, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20764, 62, 'arg_1', 'mbr', 0, 0, 1, 1);
-insert into sys.args values (20765, 62, 'arg_2', 'mbr', 0, 0, 1, 2);
-insert into sys.functions values (64, 'not_uniques', 'not_uniques', 'sql', 0,
1, false, false, false, 2000, true);
-insert into sys.args values (20766, 64, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (20767, 64, 'arg_1', 'bigint', 64, 0, 1, 1);
-insert into sys.functions values (65, 'not_uniques', 'not_uniques', 'sql', 0,
1, false, false, false, 2000, true);
-insert into sys.args values (20768, 65, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (20769, 65, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.functions values (66, 'hash', 'hash', 'mkey', 0, 1, false,
false, false, 2000, true);
-insert into sys.args values (20770, 66, 'res_0', 'bigint', 64, 0, 0, 0);
-insert into sys.args values (20771, 66, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (67, 'rotate_xor_hash', 'rotate_xor_hash',
'calc', 0, 1, false, false, false, 2000, true);
-insert into sys.args values (20772, 67, 'res_0', 'bigint', 64, 0, 0, 0);
-insert into sys.args values (20773, 67, 'arg_1', 'bigint', 64, 0, 1, 1);
-insert into sys.args values (20774, 67, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.args values (20775, 67, 'arg_3', 'any', 0, 0, 1, 3);
-insert into sys.functions values (68, '=', '=', 'calc', 0, 1, false, false,
false, 2000, true);
-insert into sys.args values (20776, 68, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20777, 68, 'arg_1', 'any', 0, 0, 1, 1);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
