Changeset: e68392d98ad3 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e68392d98ad3
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/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out.powerpc64.int128
Branch: Apr2019
Log Message:
Properly upgrade procedure sys.times and sys.prod aggrregates on decimals.
diffs (truncated from 137483 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
@@ -1879,41 +1879,31 @@ sql_update_apr2019_sp1(Client c)
}
static str
-sql_update_apr2019_sp2(Client c)
+sql_update_apr2019_sp2(Client c, mvc *sql, const char *prev_schema, bool
*systabfixed)
{
- /* Determine if system function sys.prod(decimal) exists in
sys.functions, if so remove them.
- * see also
https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f93d5290abe4
- */
- char *err = NULL;
- char *qry = "select f.id from sys.functions f where f.name = 'prod' and
func = 'prod'"
- " and mod in ('sql', 'aggr') and language = 0 and f.type in
(3,6) and f.system"
- " and schema_id in (select s.id from sys.schemas s where s.name
= 'sys')"
- " and f.id in (select a.func_id from sys.args a where a.type =
'decimal'"
- " and type_digits in (2,4,9,18,38) and a.name in
('arg','arg_1') and inout = 1 and number = 1);";
- res_table *output = NULL;
+ size_t bufsize = 1000, pos = 0;
+ char *buf = GDKmalloc(bufsize), *err;
+
+ if (buf == NULL)
+ throw(SQL, "sql_update_apr2019_sp2", SQLSTATE(HY001)
MAL_MALLOC_FAIL);
+
+ if (!*systabfixed) {
+ sql_fix_system_tables(c, sql, prev_schema);
+ *systabfixed = true;
+ }
- err = SQLstatementIntern(c, &qry, "update", true, false, &output);
- if (err == NULL) {
- BAT *b = BATdescriptor(output->cols[0].b);
- if (b) {
- if (BATcount(b) > 0) {
- /* found entries, we need to remove them
sys.functions and sys.args */
- char *upd = "delete from sys.functions f where
f.name = 'prod' and func = 'prod'"
- " and mod in ('sql', 'aggr') and
language = 0 and f.type in (3,6) and f.system"
- " and schema_id in (select s.id from
sys.schemas s where s.name = 'sys')"
- " and f.id in (select a.func_id from
sys.args a where a.type = 'decimal'"
- " and type_digits in (2,4,9,18,38) and
a.name in ('arg','arg_1') and inout = 1 and number = 1);\n"
- "delete from sys.args where func_id not
in (select id from sys.functions);\n";
+ pos += snprintf(buf + pos, bufsize - pos, "set schema sys;\n");
+
+ /* 11_times.sql */
+ pos += snprintf(buf + pos, bufsize - pos,
+ "drop procedure sys.times();\n");
- printf("Running database upgrade
commands:\n%s\n", upd);
- err = SQLstatementIntern(c, &upd, "update",
true, false, NULL);
- }
- BBPunfix(b->batCacheid);
- }
- }
- if (output != NULL)
- res_tables_destroy(output);
+ pos += snprintf(buf + pos, bufsize - pos, "set schema \"%s\";\n",
prev_schema);
+ assert(pos < bufsize);
+ printf("Running database upgrade commands:\n%s\n", buf);
+ err = SQLstatementIntern(c, &buf, "update", true, false, NULL);
+ GDKfree(buf);
return err; /* usually MAL_SUCCEED */
}
@@ -2159,10 +2149,13 @@ SQLupgrades(Client c, mvc *m)
freeException(err);
res = -1;
}
- if (!res && (err = sql_update_apr2019_sp2(c)) != NULL) {
- fprintf(stderr, "!%s\n", err);
- freeException(err);
- res = -1;
+
+ if (!res && sql_bind_func(m->sa, s, "times", NULL, NULL, F_PROC)) {
+ if (!res && (err = sql_update_apr2019_sp2(c, m, prev_schema,
&systabfixed)) != NULL) {
+ fprintf(stderr, "!%s\n", err);
+ freeException(err);
+ res = -1;
+ }
}
GDKfree(prev_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,6 +16,5829 @@ 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 (25204, 28, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (25205, 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 (25206, 29, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (25207, 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 (25208, 33, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25209, 33, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25210, 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 (25211, 34, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25212, 34, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25213, 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 (25214, 35, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25215, 35, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25216, 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 (25217, 36, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25218, 36, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25219, 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 (25220, 37, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25221, 37, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25222, 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 (25223, 38, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25224, 38, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25225, 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 (25226, 39, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25227, 39, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25228, 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 (25229, 40, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25230, 40, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25231, 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 (25232, 41, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25233, 41, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25234, 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 (25235, 42, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25236, 42, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25237, 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 (25238, 43, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25239, 43, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25240, 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 (25241, 44, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25242, 44, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25243, 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 (25244, 45, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25245, 45, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25246, 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 (25247, 46, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25248, 46, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25249, 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 (25250, 47, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25251, 47, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25252, 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 (25253, 48, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25254, 48, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25255, 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 (25256, 49, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25257, 49, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25258, 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 (25259, 50, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25260, 50, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25261, 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 (25262, 51, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25263, 51, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25264, 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 (25265, 52, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25266, 52, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25267, 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 (25268, 53, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25269, 53, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25270, 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 (25271, 54, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25272, 54, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25273, 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 (25274, 55, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25275, 55, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25276, 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 (25277, 56, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25278, 56, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25279, 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 (25280, 57, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (25281, 57, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25282, 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 (25283, 58, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (25284, 58, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25285, 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 (25286, 59, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25287, 59, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25288, 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 (25289, 60, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25290, 60, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25291, 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 (25292, 61, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25293, 61, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (25294, 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 (25295, 62, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25296, 62, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (25297, 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 (25298, 64, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (25299, 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 (25300, 65, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (25301, 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 (25302, 66, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (25303, 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 (25304, 67, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (25305, 67, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.args values (25306, 67, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.args values (25307, 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 (25308, 68, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25309, 68, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (25310, 68, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (69, '<>', '!=', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (25311, 69, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25312, 69, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (25313, 69, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (70, 'isnull', 'isnil', 'calc', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (25314, 70, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25315, 70, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (71, '>', '>', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (25316, 71, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25317, 71, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (25318, 71, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (72, '>=', '>=', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (25319, 72, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25320, 72, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (25321, 72, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (73, '<', '<', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (25322, 73, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25323, 73, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (25324, 73, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (74, '<=', '<=', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (25325, 74, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25326, 74, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (25327, 74, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (79, 'sql_exists', 'exist', 'aggr', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (25328, 79, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (25329, 79, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (80, 'sql_not_exists', 'not_exist', 'aggr',
0, 1, false, false, false, 2000, true);
+insert into sys.args values (25330, 80, 'res_0', 'boolean', 1, 0, 0, 0);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
