Changeset: ad1bf4ec935d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ad1bf4ec935d
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/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: default
Log Message:
Fix upgrade code.
diffs (truncated from 75853 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
@@ -2352,13 +2352,18 @@ sql_update_nov2019_sp1_hugeint(Client c,
#endif
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)
{
sql_table *t;
size_t bufsize = 8192, pos = 0;
char *err = NULL, *buf = GDKmalloc(bufsize);
sql_schema *sys = mvc_bind_schema(sql, "sys");
+ if (!*systabfixed &&
+ (err = sql_fix_system_tables(c, sql, prev_schema)) != NULL)
+ return err;
+ *systabfixed = true;
+
if (buf == NULL)
throw(SQL, __func__, SQLSTATE(HY013) MAL_MALLOC_FAIL);
@@ -2448,7 +2453,9 @@ sql_update_default(Client c, mvc *sql, c
"\"statement\" string,\n"
"\"created\" timestamp)\n"
" external name sql.prepared_statements;\n"
+ "grant execute on function sys.prepared_statements to
public;\n"
"create view sys.prepared_statements as select * from
sys.prepared_statements();\n"
+ "grant select on sys.prepared_statements to public;\n"
"create function sys.prepared_statements_args()\n"
"returns table(\n"
"\"statementid\" int,\n"
@@ -2461,7 +2468,9 @@ sql_update_default(Client c, mvc *sql, c
"\"table\" string,\n"
"\"column\" string)\n"
" external name sql.prepared_statements_args;\n"
- "create view sys.prepared_statements_args as select *
from sys.prepared_statements_args();\n");
+ "grant execute on function sys.prepared_statements_args
to public;\n"
+ "create view sys.prepared_statements_args as select *
from sys.prepared_statements_args();\n"
+ "grant select on sys.prepared_statements_args to
public;\n");
pos += snprintf(buf + pos, bufsize - pos,
"update sys.functions set system = true where schema_id
= (select id from sys.schemas where name = 'sys')"
@@ -2848,7 +2857,7 @@ SQLupgrades(Client c, mvc *m)
#endif
if (!res && !sql_bind_func(m->sa, s, "suspend_log_flushing", NULL,
NULL, F_PROC)) {
- if ((err = sql_update_default(c, m, prev_schema)) != NULL) {
+ if ((err = sql_update_default(c, m, prev_schema, &systabfixed))
!= NULL) {
fprintf(stderr, "!%s\n", err);
freeException(err);
res = -1;
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,5888 @@ 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, 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 (29760, 28, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (29761, 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 (29762, 29, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (29763, 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 (29764, 33, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29765, 33, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29766, 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 (29767, 34, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29768, 34, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29769, 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 (29770, 35, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29771, 35, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29772, 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 (29773, 36, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29774, 36, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29775, 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 (29776, 37, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29777, 37, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29778, 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 (29779, 38, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29780, 38, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29781, 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 (29782, 39, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29783, 39, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29784, 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 (29785, 40, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29786, 40, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29787, 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 (29788, 41, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29789, 41, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29790, 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 (29791, 42, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29792, 42, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29793, 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 (29794, 43, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29795, 43, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29796, 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 (29797, 44, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29798, 44, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29799, 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 (29800, 45, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29801, 45, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29802, 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 (29803, 46, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29804, 46, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29805, 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 (29806, 47, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29807, 47, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29808, 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 (29809, 48, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29810, 48, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29811, 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 (29812, 49, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29813, 49, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29814, 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 (29815, 50, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29816, 50, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29817, 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 (29818, 51, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29819, 51, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29820, 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 (29821, 52, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29822, 52, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29823, 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 (29824, 53, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29825, 53, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29826, 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 (29827, 54, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29828, 54, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29829, 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 (29830, 55, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29831, 55, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29832, 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 (29833, 56, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29834, 56, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29835, 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 (29836, 57, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (29837, 57, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29838, 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 (29839, 58, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (29840, 58, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29841, 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 (29842, 59, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29843, 59, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29844, 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 (29845, 60, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29846, 60, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29847, 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 (29848, 61, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29849, 61, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (29850, 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 (29851, 62, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29852, 62, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (29853, 62, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (69, 'not_uniques', 'not_uniques', 'sql', 0,
1, false, false, false, 2000, true);
+insert into sys.args values (29854, 69, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (29855, 69, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.functions values (70, 'not_uniques', 'not_uniques', 'sql', 0,
1, false, false, false, 2000, true);
+insert into sys.args values (29856, 70, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (29857, 70, 'arg_1', 'oid', 63, 0, 1, 1);
+insert into sys.functions values (71, 'hash', 'hash', 'mkey', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (29858, 71, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (29859, 71, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (72, 'rotate_xor_hash', 'rotate_xor_hash',
'calc', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (29860, 72, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (29861, 72, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.args values (29862, 72, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.args values (29863, 72, 'arg_3', 'any', 0, 0, 1, 3);
+insert into sys.functions values (73, '=', '=', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (29864, 73, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29865, 73, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (29866, 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 (29867, 74, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29868, 74, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (29869, 74, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (75, 'isnull', 'isnil', 'calc', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (29870, 75, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29871, 75, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (76, '>', '>', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (29872, 76, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29873, 76, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (29874, 76, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (77, '>=', '>=', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (29875, 77, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29876, 77, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (29877, 77, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (78, '<', '<', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (29878, 78, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29879, 78, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (29880, 78, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (79, '<=', '<=', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (29881, 79, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29882, 79, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (29883, 79, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (80, 'between', 'between', 'calc', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (29884, 80, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29885, 80, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (29886, 80, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.args values (29887, 80, 'arg_3', 'any', 0, 0, 1, 3);
+insert into sys.args values (29888, 80, 'arg_4', 'boolean', 1, 0, 1, 4);
+insert into sys.args values (29889, 80, 'arg_5', 'boolean', 1, 0, 1, 5);
+insert into sys.args values (29890, 80, 'arg_6', 'boolean', 1, 0, 1, 6);
+insert into sys.args values (29891, 80, 'arg_7', 'boolean', 1, 0, 1, 7);
+insert into sys.args values (29892, 80, 'arg_8', 'boolean', 1, 0, 1, 8);
+insert into sys.functions values (84, 'any', 'any', 'sql', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (29893, 84, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29894, 84, 'arg_1', 'boolean', 1, 0, 1, 1);
+insert into sys.args values (29895, 84, 'arg_2', 'boolean', 1, 0, 1, 2);
+insert into sys.args values (29896, 84, 'arg_3', 'boolean', 1, 0, 1, 3);
+insert into sys.functions values (85, 'all', 'all', 'sql', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (29897, 85, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29898, 85, 'arg_1', 'boolean', 1, 0, 1, 1);
+insert into sys.args values (29899, 85, 'arg_2', 'boolean', 1, 0, 1, 2);
+insert into sys.args values (29900, 85, 'arg_3', 'boolean', 1, 0, 1, 3);
+insert into sys.functions values (88, 'sql_anyequal', 'anyequal', 'aggr', 0,
1, false, false, false, 2000, true);
+insert into sys.args values (29901, 88, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29902, 88, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (29903, 88, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (89, 'sql_not_anyequal', 'not_anyequal',
'aggr', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (29904, 89, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29905, 89, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (29906, 89, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (92, 'sql_exists', 'exist', 'aggr', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (29907, 92, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29908, 92, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (93, 'sql_not_exists', 'not_exist', 'aggr',
0, 1, false, false, false, 2000, true);
+insert into sys.args values (29909, 93, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29910, 93, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (94, 'in', 'in', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (29911, 94, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (29912, 94, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (29913, 94, 'arg_2', 'any', 0, 0, 1, 2);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
