Changeset: f8ff7a641d3b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f8ff7a641d3b
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: Jul2017
Log Message:
Added upgrade code for triggers system_update_{schemas,tables}.
diffs (truncated from 39668 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
@@ -1526,6 +1526,54 @@ sql_update_jul2017_sp2(Client c)
return err; /* usually NULL */
}
+static str
+sql_update_jul2017_sp3(Client c, mvc *sql)
+{
+ char *err = NULL;
+ sql_schema *sys;
+ sql_table *tab;
+ sql_column *col;
+ oid rid;
+
+ /* if there is no value "sys_update_schemas" in
+ * sys.functions.name, we need to update the sys.functions
+ * table */
+ sys = find_sql_schema(sql->session->tr, "sys");
+ tab = find_sql_table(sys, "functions");
+ col = find_sql_column(tab, "name");
+ rid = table_funcs.column_find_row(sql->session->tr, col,
"sys_update_schemas", NULL);
+ if (rid == oid_nil) {
+ err = sql_fix_system_tables(c, sql);
+ if (err != NULL)
+ return err;
+ }
+ /* if there is no value "system_update_schemas" in
+ * sys.triggers.name, we need to add the triggers */
+ tab = find_sql_table(sys, "triggers");
+ col = find_sql_column(tab, "name");
+ rid = table_funcs.column_find_row(sql->session->tr, col,
"system_update_schemas", NULL);
+ if (rid == oid_nil) {
+ char *schema = stack_get_string(sql, "current_schema");
+ size_t bufsize = 1024, pos = 0;
+ char *buf = GDKmalloc(bufsize);
+ if (buf == NULL)
+ throw(SQL, "sql_update_jul2017_sp3", MAL_MALLOC_FAIL);
+ pos += snprintf(
+ buf + pos,
+ bufsize - pos,
+ "set schema \"sys\";\n"
+ "create trigger system_update_schemas after update on
sys.schemas for each statement call sys_update_schemas();\n"
+ "create trigger system_update_tables after update on
sys._tables for each statement call sys_update_tables();\n");
+ if (schema)
+ pos += snprintf(buf + pos, bufsize - pos, "set schema
\"%s\";\n", schema);
+ assert(pos < bufsize);
+ printf("Running database upgrade commands:\n%s\n", buf);
+ err = SQLstatementIntern(c, &buf, "update", 1, 0, NULL);
+ GDKfree(buf);
+ }
+ return err;
+}
+
void
SQLupgrades(Client c, mvc *m)
{
@@ -1658,4 +1706,9 @@ SQLupgrades(Client c, mvc *m)
fprintf(stderr, "!%s\n", err);
freeException(err);
}
+
+ if ((err = sql_update_jul2017_sp3(c, m)) != NULL) {
+ fprintf(stderr, "!%s\n", err);
+ freeException(err);
+ }
}
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
@@ -24,10 +24,5285 @@ stdout of test 'upgrade` in directory 's
# MonetDB/R module loaded
Ready.
+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, 'lng', 'wrd', 64, 1, 2, 7, 2000);
+insert into sys.types values (13, 'hge', 'hugeint', 128, 1, 2, 7, 2000);
+insert into sys.types values (14, 'bte', 'decimal', 2, 1, 10, 10, 2000);
+insert into sys.types values (15, 'sht', 'decimal', 4, 1, 10, 10, 2000);
+insert into sys.types values (16, 'int', 'decimal', 9, 1, 10, 10, 2000);
+insert into sys.types values (17, 'lng', 'decimal', 18, 1, 10, 10, 2000);
+insert into sys.types values (18, 'hge', 'decimal', 38, 1, 10, 10, 2000);
+insert into sys.types values (19, 'flt', 'real', 24, 2, 2, 11, 2000);
+insert into sys.types values (20, 'dbl', 'double', 53, 2, 2, 11, 2000);
+insert into sys.types values (21, 'int', 'month_interval', 32, 0, 2, 8, 2000);
+insert into sys.types values (22, 'lng', 'sec_interval', 13, 1, 10, 9, 2000);
+insert into sys.types values (23, 'daytime', 'time', 7, 0, 0, 12, 2000);
+insert into sys.types values (24, 'daytime', 'timetz', 7, 1, 0, 12, 2000);
+insert into sys.types values (25, 'date', 'date', 0, 0, 0, 13, 2000);
+insert into sys.types values (26, 'timestamp', 'timestamp', 7, 0, 0, 14, 2000);
+insert into sys.types values (27, 'timestamp', 'timestamptz', 7, 1, 0, 14,
2000);
+insert into sys.types values (28, 'sqlblob', 'blob', 0, 0, 0, 5, 2000);
+insert into sys.types values (29, 'wkb', 'geometry', 0, 0, 0, 15, 2000);
+insert into sys.types values (30, 'wkba', 'geometrya', 0, 0, 0, 16, 2000);
+insert into sys.types values (31, '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 (32, 'mbr_overlap', 'mbrOverlaps', 'geom', 0,
1, false, false, false, 2000);
+insert into sys.args values (12437, 32, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12438, 32, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12439, 32, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (33, 'mbr_overlap', 'mbrOverlaps', 'geom', 0,
1, false, false, false, 2000);
+insert into sys.args values (12440, 33, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12441, 33, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12442, 33, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (34, 'mbr_above', 'mbrAbove', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12443, 34, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12444, 34, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12445, 34, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (35, 'mbr_above', 'mbrAbove', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12446, 35, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12447, 35, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12448, 35, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (36, 'mbr_below', 'mbrBelow', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12449, 36, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12450, 36, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12451, 36, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (37, 'mbr_below', 'mbrBelow', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12452, 37, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12453, 37, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12454, 37, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (38, 'mbr_right', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12455, 38, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12456, 38, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12457, 38, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (39, 'mbr_right', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12458, 39, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12459, 39, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12460, 39, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (40, 'mbr_left', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12461, 40, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12462, 40, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12463, 40, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (41, 'mbr_left', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12464, 41, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12465, 41, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12466, 41, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (42, 'mbr_overlap_or_above',
'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000);
+insert into sys.args values (12467, 42, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12468, 42, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12469, 42, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (43, 'mbr_overlap_or_above',
'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000);
+insert into sys.args values (12470, 43, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12471, 43, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12472, 43, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (44, 'mbr_overlap_or_below',
'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000);
+insert into sys.args values (12473, 44, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12474, 44, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12475, 44, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (45, 'mbr_overlap_or_below',
'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000);
+insert into sys.args values (12476, 45, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12477, 45, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12478, 45, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (46, 'mbr_overlap_or_right',
'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000);
+insert into sys.args values (12479, 46, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12480, 46, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12481, 46, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (47, 'mbr_overlap_or_right',
'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000);
+insert into sys.args values (12482, 47, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12483, 47, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12484, 47, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (48, 'mbr_overlap_or_left',
'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000);
+insert into sys.args values (12485, 48, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12486, 48, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12487, 48, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (49, 'mbr_overlap_or_left',
'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000);
+insert into sys.args values (12488, 49, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12489, 49, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12490, 49, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (50, 'mbr_contains', 'mbrContains', 'geom',
0, 1, false, false, false, 2000);
+insert into sys.args values (12491, 50, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12492, 50, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12493, 50, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (51, 'mbr_contains', 'mbrContains', 'geom',
0, 1, false, false, false, 2000);
+insert into sys.args values (12494, 51, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12495, 51, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12496, 51, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (52, 'mbr_contained', 'mbrContained', 'geom',
0, 1, false, false, false, 2000);
+insert into sys.args values (12497, 52, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12498, 52, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12499, 52, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (53, 'mbr_contained', 'mbrContained', 'geom',
0, 1, false, false, false, 2000);
+insert into sys.args values (12500, 53, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12501, 53, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12502, 53, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (54, 'mbr_equal', 'mbrEqual', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12503, 54, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12504, 54, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12505, 54, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (55, 'mbr_equal', 'mbrEqual', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12506, 55, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12507, 55, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12508, 55, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (56, 'mbr_distance', 'mbrDistance', 'geom',
0, 1, false, false, false, 2000);
+insert into sys.args values (12509, 56, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (12510, 56, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12511, 56, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (57, 'mbr_distance', 'mbrDistance', 'geom',
0, 1, false, false, false, 2000);
+insert into sys.args values (12512, 57, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (12513, 57, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12514, 57, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (58, 'left_shift', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12515, 58, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12516, 58, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12517, 58, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (59, 'left_shift', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12518, 59, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12519, 59, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12520, 59, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (60, 'right_shift', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12521, 60, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12522, 60, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (12523, 60, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (61, 'right_shift', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12524, 61, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12525, 61, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (12526, 61, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (63, 'not_uniques', 'not_uniques', 'sql', 0,
1, false, false, false, 2000);
+insert into sys.args values (12527, 63, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (12528, 63, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.functions values (64, 'not_uniques', 'not_uniques', 'sql', 0,
1, false, false, false, 2000);
+insert into sys.args values (12529, 64, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (12530, 64, 'arg_1', 'oid', 63, 0, 1, 1);
+insert into sys.functions values (65, 'hash', 'hash', 'mkey', 0, 1, false,
false, false, 2000);
+insert into sys.args values (12531, 65, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (12532, 65, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (66, 'rotate_xor_hash', 'rotate_xor_hash',
'calc', 0, 1, false, false, false, 2000);
+insert into sys.args values (12533, 66, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (12534, 66, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.args values (12535, 66, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.args values (12536, 66, 'arg_3', 'any', 0, 0, 1, 3);
+insert into sys.functions values (67, '=', '=', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (12537, 67, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12538, 67, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (12539, 67, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (68, '<>', '!=', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (12540, 68, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12541, 68, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (12542, 68, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (69, 'isnull', 'isnil', 'calc', 0, 1, false,
false, false, 2000);
+insert into sys.args values (12543, 69, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12544, 69, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (70, '>', '>', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (12545, 70, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12546, 70, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (12547, 70, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (71, '>=', '>=', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (12548, 71, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12549, 71, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (12550, 71, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (72, '<', '<', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (12551, 72, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12552, 72, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (12553, 72, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (73, '<=', '<=', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (12554, 73, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12555, 73, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (12556, 73, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (78, 'sql_exists', 'exist', 'aggr', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12557, 78, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12558, 78, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (79, 'sql_not_exists', 'not_exist', 'aggr',
0, 1, false, false, false, 2000);
+insert into sys.args values (12559, 79, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12560, 79, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (80, 'in', 'in', 'calc', 0, 1, false, false,
false, 2000);
+insert into sys.args values (12561, 80, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (12562, 80, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (12563, 80, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (81, 'identity', 'identity', 'calc', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12564, 81, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (12565, 81, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (82, 'rowid', 'identity', 'calc', 0, 1,
false, false, false, 2000);
+insert into sys.args values (12566, 82, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (12567, 82, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (83, 'rowid', 'rowid', 'calc', 0, 1, false,
false, false, 2000);
+insert into sys.args values (12568, 83, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (12569, 83, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (12570, 83, 'arg_2', 'varchar', 0, 0, 1, 2);
+insert into sys.args values (12571, 83, 'arg_3', 'varchar', 0, 0, 1, 3);
+insert into sys.functions values (86, 'sql_min', 'min', 'calc', 0, 1, false,
false, false, 2000);
+insert into sys.args values (12572, 86, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (12573, 86, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (12574, 86, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (87, 'sql_max', 'max', 'calc', 0, 1, false,
false, false, 2000);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
