Changeset: 1a2b9ef9c047 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1a2b9ef9c047
Added Files:
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
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.32bit
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/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-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
Branch: default
Log Message:
Update system tables during upgrade.
diffs (truncated from 69597 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
@@ -2206,6 +2206,7 @@ SQLupgrades(Client c, mvc *m)
sql_schema *s = mvc_bind_schema(m, "sys");
sql_table *t;
sql_column *col;
+ bool hugeint_upgraded = false;
#ifdef HAVE_HGE
if (have_hge) {
@@ -2215,6 +2216,7 @@ SQLupgrades(Client c, mvc *m)
fprintf(stderr, "!%s\n", err);
freeException(err);
}
+ hugeint_upgraded = true;
}
}
#endif
@@ -2409,6 +2411,12 @@ SQLupgrades(Client c, mvc *m)
fprintf(stderr, "!%s\n", err);
freeException(err);
}
+ if (!hugeint_upgraded) {
+ if ((err = sql_fix_system_tables(c, m)) != NULL) {
+ fprintf(stderr, "!%s\n", err);
+ freeException(err);
+ }
+ }
}
/* when function storagemodel() exists and views tablestorage
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
@@ -36,6 +36,5808 @@ set schema "sys";
commit;
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, 'sqlblob', 'blob', 0, 0, 0, 5, 2000);
+insert into sys.types values (28, 'wkb', 'geometry', 0, 0, 0, 15, 2000);
+insert into sys.types values (29, 'wkba', 'geometrya', 0, 0, 0, 16, 2000);
+insert into sys.types values (30, '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 (31, 'mbr_overlap', 'mbrOverlaps', 'geom', 0,
1, false, false, false, 2000, true);
+insert into sys.args values (20675, 31, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20676, 31, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20677, 31, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (32, 'mbr_overlap', 'mbrOverlaps', 'geom', 0,
1, false, false, false, 2000, true);
+insert into sys.args values (20678, 32, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20679, 32, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20680, 32, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (33, 'mbr_above', 'mbrAbove', 'geom', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20681, 33, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20682, 33, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20683, 33, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (34, 'mbr_above', 'mbrAbove', 'geom', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20684, 34, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20685, 34, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20686, 34, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (35, 'mbr_below', 'mbrBelow', 'geom', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20687, 35, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20688, 35, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20689, 35, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (36, 'mbr_below', 'mbrBelow', 'geom', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20690, 36, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20691, 36, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20692, 36, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (37, 'mbr_right', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20693, 37, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20694, 37, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20695, 37, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (38, 'mbr_right', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20696, 38, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20697, 38, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20698, 38, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (39, 'mbr_left', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20699, 39, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20700, 39, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20701, 39, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (40, 'mbr_left', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20702, 40, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20703, 40, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20704, 40, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (41, 'mbr_overlap_or_above',
'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (20705, 41, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20706, 41, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20707, 41, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (42, 'mbr_overlap_or_above',
'mbrOverlapOrAbove', 'geom', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (20708, 42, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20709, 42, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20710, 42, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (43, 'mbr_overlap_or_below',
'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (20711, 43, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20712, 43, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20713, 43, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (44, 'mbr_overlap_or_below',
'mbrOverlapOrBelow', 'geom', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (20714, 44, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20715, 44, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20716, 44, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (45, 'mbr_overlap_or_right',
'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (20717, 45, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20718, 45, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20719, 45, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (46, 'mbr_overlap_or_right',
'mbrOverlapOrRight', 'geom', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (20720, 46, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20721, 46, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20722, 46, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (47, 'mbr_overlap_or_left',
'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (20723, 47, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20724, 47, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20725, 47, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (48, 'mbr_overlap_or_left',
'mbrOverlapOrLeft', 'geom', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (20726, 48, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20727, 48, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20728, 48, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (49, 'mbr_contains', 'mbrContains', 'geom',
0, 1, false, false, false, 2000, true);
+insert into sys.args values (20729, 49, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20730, 49, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20731, 49, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (50, 'mbr_contains', 'mbrContains', 'geom',
0, 1, false, false, false, 2000, true);
+insert into sys.args values (20732, 50, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20733, 50, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20734, 50, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (51, 'mbr_contained', 'mbrContained', 'geom',
0, 1, false, false, false, 2000, true);
+insert into sys.args values (20735, 51, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20736, 51, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20737, 51, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (52, 'mbr_contained', 'mbrContained', 'geom',
0, 1, false, false, false, 2000, true);
+insert into sys.args values (20738, 52, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20739, 52, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20740, 52, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (53, 'mbr_equal', 'mbrEqual', 'geom', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20741, 53, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20742, 53, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20743, 53, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (54, 'mbr_equal', 'mbrEqual', 'geom', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20744, 54, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20745, 54, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20746, 54, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (55, 'mbr_distance', 'mbrDistance', 'geom',
0, 1, false, false, false, 2000, true);
+insert into sys.args values (20747, 55, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (20748, 55, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20749, 55, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (56, 'mbr_distance', 'mbrDistance', 'geom',
0, 1, false, false, false, 2000, true);
+insert into sys.args values (20750, 56, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (20751, 56, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20752, 56, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (57, 'left_shift', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20753, 57, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20754, 57, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20755, 57, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (58, 'left_shift', 'mbrLeft', 'geom', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20756, 58, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20757, 58, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20758, 58, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (59, 'right_shift', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20759, 59, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20760, 59, 'arg_1', 'geometry', 0, 0, 1, 1);
+insert into sys.args values (20761, 59, 'arg_2', 'geometry', 0, 0, 1, 2);
+insert into sys.functions values (60, 'right_shift', 'mbrRight', 'geom', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20762, 60, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20763, 60, 'arg_1', 'mbr', 0, 0, 1, 1);
+insert into sys.args values (20764, 60, 'arg_2', 'mbr', 0, 0, 1, 2);
+insert into sys.functions values (62, 'not_uniques', 'not_uniques', 'sql', 0,
1, false, false, false, 2000, true);
+insert into sys.args values (20765, 62, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (20766, 62, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.functions values (63, 'not_uniques', 'not_uniques', 'sql', 0,
1, false, false, false, 2000, true);
+insert into sys.args values (20767, 63, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (20768, 63, 'arg_1', 'oid', 63, 0, 1, 1);
+insert into sys.functions values (64, 'hash', 'hash', 'mkey', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (20769, 64, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (20770, 64, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (65, 'rotate_xor_hash', 'rotate_xor_hash',
'calc', 0, 1, false, false, false, 2000, true);
+insert into sys.args values (20771, 65, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (20772, 65, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.args values (20773, 65, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.args values (20774, 65, 'arg_3', 'any', 0, 0, 1, 3);
+insert into sys.functions values (66, '=', '=', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20775, 66, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20776, 66, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (20777, 66, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (67, '<>', '!=', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20778, 67, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20779, 67, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (20780, 67, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (68, 'isnull', 'isnil', 'calc', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (20781, 68, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20782, 68, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (69, '>', '>', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20783, 69, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20784, 69, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (20785, 69, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (70, '>=', '>=', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20786, 70, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20787, 70, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (20788, 70, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (71, '<', '<', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20789, 71, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20790, 71, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (20791, 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 (20792, 72, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20793, 72, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (20794, 72, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (77, 'sql_exists', 'exist', 'aggr', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20795, 77, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20796, 77, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (78, 'sql_not_exists', 'not_exist', 'aggr',
0, 1, false, false, false, 2000, true);
+insert into sys.args values (20797, 78, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20798, 78, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (79, 'in', 'in', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20799, 79, 'res_0', 'boolean', 1, 0, 0, 0);
+insert into sys.args values (20800, 79, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (20801, 79, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (80, 'identity', 'identity', 'calc', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20802, 80, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (20803, 80, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (81, 'rowid', 'identity', 'calc', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20804, 81, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (20805, 81, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.functions values (82, 'rowid', 'rowid', 'calc', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (20806, 82, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (20807, 82, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (20808, 82, 'arg_2', 'varchar', 0, 0, 1, 2);
+insert into sys.args values (20809, 82, 'arg_3', 'varchar', 0, 0, 1, 3);
+insert into sys.functions values (85, 'sql_min', 'min', 'calc', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (20810, 85, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (20811, 85, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (20812, 85, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (86, 'sql_max', 'max', 'calc', 0, 1, false,
false, false, 2000, true);
+insert into sys.args values (20813, 86, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (20814, 86, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (20815, 86, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (87, 'ifthenelse', 'ifthenelse', 'calc', 0,
1, false, false, false, 2000, true);
+insert into sys.args values (20816, 87, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (20817, 87, 'arg_1', 'boolean', 1, 0, 1, 1);
+insert into sys.args values (20818, 87, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.args values (20819, 87, 'arg_3', 'any', 0, 0, 1, 3);
+insert into sys.functions values (108, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20820, 108, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (20821, 108, 'arg_1', 'oid', 63, 0, 1, 1);
+insert into sys.args values (20822, 108, 'arg_2', 'oid', 63, 0, 1, 2);
+insert into sys.functions values (109, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20823, 109, 'res_0', 'tinyint', 8, 0, 0, 0);
+insert into sys.args values (20824, 109, 'arg_1', 'tinyint', 8, 0, 1, 1);
+insert into sys.args values (20825, 109, 'arg_2', 'tinyint', 8, 0, 1, 2);
+insert into sys.functions values (110, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20826, 110, 'res_0', 'smallint', 16, 0, 0, 0);
+insert into sys.args values (20827, 110, 'arg_1', 'smallint', 16, 0, 1, 1);
+insert into sys.args values (20828, 110, 'arg_2', 'smallint', 16, 0, 1, 2);
+insert into sys.functions values (111, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20829, 111, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (20830, 111, 'arg_1', 'int', 32, 0, 1, 1);
+insert into sys.args values (20831, 111, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.functions values (112, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20832, 112, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (20833, 112, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.args values (20834, 112, 'arg_2', 'bigint', 64, 0, 1, 2);
+insert into sys.functions values (113, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20835, 113, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (20836, 113, 'arg_1', 'hugeint', 128, 0, 1, 1);
+insert into sys.args values (20837, 113, 'arg_2', 'hugeint', 128, 0, 1, 2);
+insert into sys.functions values (114, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20838, 114, 'res_0', 'decimal', 2, 0, 0, 0);
+insert into sys.args values (20839, 114, 'arg_1', 'decimal', 2, 0, 1, 1);
+insert into sys.args values (20840, 114, 'arg_2', 'decimal', 2, 0, 1, 2);
+insert into sys.functions values (115, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20841, 115, 'res_0', 'decimal', 4, 0, 0, 0);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
