Changeset: 105cfd056e79 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=105cfd056e79
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.ppc64.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.ppc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.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
Branch: oscar
Log Message:
Fix upgrade of radians and degrees functions.
diffs (truncated from 126781 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
@@ -2153,7 +2153,7 @@ sql_update_default_lidar(Client c)
}
static str
-sql_update_default(Client c, mvc *sql, const char *prev_schema)
+sql_update_default(Client c, mvc *sql, const char *prev_schema, bool
*systabfixed)
{
size_t bufsize = 8192, pos = 0;
char *err = NULL, *buf = GDKmalloc(bufsize);
@@ -2176,6 +2176,11 @@ sql_update_default(Client c, mvc *sql, c
if (b) {
BATiter bi = bat_iterator(b);
if (BATcount(b) > 0 && strcmp(BUNtail(bi, 0), "progress") == 0)
{
+ if (!*systabfixed &&
+ (err = sql_fix_system_tables(c, sql,
prev_schema)) != NULL)
+ return err;
+ *systabfixed = true;
+
pos = 0;
pos += snprintf(buf + pos, bufsize - pos,
"set schema \"sys\";\n");
@@ -2287,16 +2292,6 @@ sql_update_default(Client c, mvc *sql, c
pos += snprintf(buf + pos, bufsize - pos,
"delete from args where id in (select
args.id from args left join functions on args.func_id = functions.id where
functions.id is null);\n");
- list *functions = sa_list(sql->sa);
- /* Adding fixed versions of degrees and radians
functions */
- sql_subtype *flt_types[2] = {sql_bind_localtype("flt"),
sql_bind_localtype("dbl")};
- for (int i = 0; i < 2; i++) {
- sql_subtype *next = flt_types[i];
- list_append(functions, sql_create_func(sql->sa,
"degrees", "mmath", "degrees", FALSE, FALSE, SCALE_FIX, 0, next->type, 1,
next->type));
- list_append(functions, sql_create_func(sql->sa,
"radians", "mmath", "radians", FALSE, FALSE, SCALE_FIX, 0, next->type, 1,
next->type));
- }
- insert_functions(sql->session->tr, mvc_bind_table(sql,
sys, "functions"), functions, mvc_bind_table(sql, sys, "args"));
-
pos += snprintf(buf + pos, bufsize - pos,
"update sys.functions set semantics = false
where type <> 6 and ((func not ilike '%%CREATE FUNCTION%%' and name in
('length','octet_length','>','>=','<','<=','min','max','sql_min','sql_max','least','greatest','sum','prod','mod','and',\n"
"'xor','not','sql_mul','sql_div','sql_sub','sql_add','bit_and','bit_or','bit_xor','bit_not','left_shift','right_shift','abs','sign','scale_up','scale_down','round','power','floor','ceil','ceiling','sin','cos','tan','asin',\n"
@@ -2548,7 +2543,7 @@ SQLupgrades(Client c, mvc *m)
return -1;
}
- if ((err = sql_update_default(c, m, prev_schema)) != NULL) {
+ if ((err = sql_update_default(c, m, prev_schema, &systabfixed)) !=
NULL) {
TRC_CRITICAL(SQL_PARSER, "%s\n", err);
freeException(err);
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
@@ -18,6 +18,5721 @@ stdout of test 'upgrade` in directory 's
# 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, 13, 2000);
+insert into sys.types values (24, 'date', 'date', 0, 0, 0, 14, 2000);
+insert into sys.types values (25, 'timestamp', 'timestamp', 7, 0, 0, 15, 2000);
+insert into sys.types values (26, 'timestamp', 'timestamptz', 7, 1, 0, 16,
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, 17, 2000);
+insert into sys.types values (31, 'wkba', 'geometrya', 0, 0, 0, 18, 2000);
+insert into sys.types values (32, 'mbr', 'mbr', 0, 0, 0, 18, 2000);
+delete from sys.functions where id < 2000;
+delete from sys.args where func_id not in (select id from sys.functions);
+insert into sys.functions values (28, 'length', 'nitems', 'blob', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (34778, 28, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (34779, 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, false);
+insert into sys.args values (34780, 29, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (34781, 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, true);
+insert into sys.args values (34782, 33, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34783, 33, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34784, 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, true);
+insert into sys.args values (34785, 34, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34786, 34, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34787, 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, true);
+insert into sys.args values (34788, 35, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34789, 35, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34790, 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, true);
+insert into sys.args values (34791, 36, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34792, 36, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34793, 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, true);
+insert into sys.args values (34794, 37, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34795, 37, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34796, 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, true);
+insert into sys.args values (34797, 38, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34798, 38, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34799, 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, true);
+insert into sys.args values (34800, 39, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34801, 39, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34802, 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, true);
+insert into sys.args values (34803, 40, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34804, 40, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34805, 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, true);
+insert into sys.args values (34806, 41, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34807, 41, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34808, 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, true);
+insert into sys.args values (34809, 42, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34810, 42, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34811, 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, true);
+insert into sys.args values (34812, 43, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34813, 43, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34814, 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, true);
+insert into sys.args values (34815, 44, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34816, 44, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34817, 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, true);
+insert into sys.args values (34818, 45, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34819, 45, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34820, 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, true);
+insert into sys.args values (34821, 46, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34822, 46, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34823, 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, true);
+insert into sys.args values (34824, 47, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34825, 47, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34826, 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, true);
+insert into sys.args values (34827, 48, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34828, 48, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34829, 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, true);
+insert into sys.args values (34830, 49, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34831, 49, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34832, 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, true);
+insert into sys.args values (34833, 50, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34834, 50, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34835, 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, true);
+insert into sys.args values (34836, 51, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34837, 51, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34838, 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, true);
+insert into sys.args values (34839, 52, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34840, 52, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34841, 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, true);
+insert into sys.args values (34842, 53, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34843, 53, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34844, 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, true);
+insert into sys.args values (34845, 54, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34846, 54, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34847, 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, true);
+insert into sys.args values (34848, 55, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34849, 55, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34850, 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, true);
+insert into sys.args values (34851, 56, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34852, 56, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34853, 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, true);
+insert into sys.args values (34854, 57, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (34855, 57, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34856, 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, true);
+insert into sys.args values (34857, 58, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (34858, 58, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34859, 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, true);
+insert into sys.args values (34860, 59, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34861, 59, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34862, 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, true);
+insert into sys.args values (34863, 60, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34864, 60, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34865, 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, true);
+insert into sys.args values (34866, 61, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34867, 61, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (34868, 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, true);
+insert into sys.args values (34869, 62, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34870, 62, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (34871, 62, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (63, 'grouping', '', '', 0, 3, false, false,
false, 2000, true, true);
+insert into sys.args values (34872, 63, 'res_0', 'tinyint', 8, 0, 0, 0);
+insert into sys.args values (34873, 63, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (64, 'grouping', '', '', 0, 3, false, false,
false, 2000, true, true);
+insert into sys.args values (34874, 64, 'res_0', 'smallint', 16, 0, 0, 0);
+insert into sys.args values (34875, 64, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (65, 'grouping', '', '', 0, 3, false, false,
false, 2000, true, true);
+insert into sys.args values (34876, 65, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (34877, 65, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (66, 'grouping', '', '', 0, 3, false, false,
false, 2000, true, true);
+insert into sys.args values (34878, 66, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (34879, 66, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (67, 'grouping', '', '', 0, 3, false, false,
false, 2000, true, true);
+insert into sys.args values (34880, 67, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (34881, 67, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (68, 'not_unique', 'not_unique', 'aggr', 0,
3, false, false, false, 2000, true, true);
+insert into sys.args values (34882, 68, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34883, 68, 'arg_1', 'oid', 63, 0, 1, 1);
+insert into sys.functions values (69, 'hash', 'hash', 'mkey', 0, 1, false,
false, false, 2000, true, true);
+insert into sys.args values (34884, 69, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (34885, 69, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (70, 'rotate_xor_hash', 'rotate_xor_hash',
'calc', 0, 1, false, false, false, 2000, true, true);
+insert into sys.args values (34886, 70, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (34887, 70, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.args values (34888, 70, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.args values (34889, 70, 'arg_3', 'any', 0, 0, 1, 3);
+insert into sys.functions values (71, '=', '=', 'calc', 0, 1, false, false,
false, 2000, true, true);
+insert into sys.args values (34890, 71, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34891, 71, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (34892, 71, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (72, '<>', '!=', 'calc', 0, 1, false, false,
false, 2000, true, true);
+insert into sys.args values (34893, 72, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34894, 72, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (34895, 72, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (73, 'isnull', 'isnil', 'calc', 0, 1, false,
false, false, 2000, true, true);
+insert into sys.args values (34896, 73, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34897, 73, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (74, 'isnotnull', 'isnotnil', 'calc', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (34898, 74, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34899, 74, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (75, '>', '>', 'calc', 0, 1, false, false,
false, 2000, true, false);
+insert into sys.args values (34900, 75, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34901, 75, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (34902, 75, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (76, '>=', '>=', 'calc', 0, 1, false, false,
false, 2000, true, false);
+insert into sys.args values (34903, 76, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34904, 76, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (34905, 76, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (77, '<', '<', 'calc', 0, 1, false, false,
false, 2000, true, false);
+insert into sys.args values (34906, 77, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34907, 77, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (34908, 77, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (78, '<=', '<=', 'calc', 0, 1, false, false,
false, 2000, true, false);
+insert into sys.args values (34909, 78, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34910, 78, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (34911, 78, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (79, 'between', 'between', 'calc', 0, 1,
false, false, false, 2000, true, true);
+insert into sys.args values (34912, 79, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34913, 79, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (34914, 79, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.args values (34915, 79, 'arg_3', 'any', 0, 0, 1, 3);
+insert into sys.args values (34916, 79, 'arg_4', 'boolean', 1, 0, 1, 4);
+insert into sys.args values (34917, 79, 'arg_5', 'boolean', 1, 0, 1, 5);
+insert into sys.args values (34918, 79, 'arg_6', 'boolean', 1, 0, 1, 6);
+insert into sys.args values (34919, 79, 'arg_7', 'boolean', 1, 0, 1, 7);
+insert into sys.args values (34920, 79, 'arg_8', 'boolean', 1, 0, 1, 8);
+insert into sys.functions values (80, 'zero_or_one', 'zero_or_one', 'aggr', 0,
3, false, false, false, 2000, true, true);
+insert into sys.args values (34921, 80, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (34922, 80, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (81, 'all', 'all', 'aggr', 0, 3, false,
false, false, 2000, true, true);
+insert into sys.args values (34923, 81, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (34924, 81, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (82, 'null', 'null', 'aggr', 0, 3, false,
false, false, 2000, true, true);
+insert into sys.args values (34925, 82, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34926, 82, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (83, 'any', 'any', 'sql', 0, 1, false, false,
false, 2000, true, true);
+insert into sys.args values (34927, 83, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (34928, 83, 'arg_1', 'boolean', 1, 0, 1, 1);
+insert into sys.args values (34929, 83, 'arg_2', 'boolean', 1, 0, 1, 2);
+insert into sys.args values (34930, 83, 'arg_3', 'boolean', 1, 0, 1, 3);
+insert into sys.functions values (84, 'all', 'all', 'sql', 0, 1, false, false,
false, 2000, true, true);
+insert into sys.args values (34931, 84, 'res_0', 'boolean', 1, 0, 0, 0);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
