Changeset: f5f3c81bb441 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f5f3c81bb441
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/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:
Upgrade.
diffs (truncated from 158093 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
@@ -2331,7 +2331,7 @@ sql_update_oscar(Client c, mvc *sql, con
}
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 = 3000, pos = 0;
char *buf, *err;
@@ -2355,6 +2355,11 @@ sql_update_default(Client c, mvc *sql, c
b = BATdescriptor(output->cols[0].b);
if (b) {
if (BATcount(b) > 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");
@@ -2628,7 +2633,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
@@ -1201,4557 +1201,4677 @@ insert into sys.args values (35653, 299,
insert into sys.args values (35654, 299, 'arg_1', 'hugeint', 128, 0, 1, 1);
insert into sys.args values (35655, 299, 'arg_2', 'bigint', 64, 0, 1, 2);
insert into sys.functions values (300, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35656, 300, 'res_0', 'decimal', 9, 0, 0, 0);
-insert into sys.args values (35657, 300, 'arg_1', 'decimal', 9, 0, 1, 1);
-insert into sys.args values (35658, 300, 'arg_2', 'decimal', 4, 0, 1, 2);
-insert into sys.functions values (301, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35659, 301, 'res_0', 'decimal', 9, 0, 0, 0);
-insert into sys.args values (35660, 301, 'arg_1', 'decimal', 9, 0, 1, 1);
+insert into sys.args values (35656, 300, 'res_0', 'decimal', 4, 0, 0, 0);
+insert into sys.args values (35657, 300, 'arg_1', 'decimal', 4, 0, 1, 1);
+insert into sys.args values (35658, 300, 'arg_2', 'tinyint', 8, 0, 1, 2);
+insert into sys.functions values (301, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35659, 301, 'res_0', 'decimal', 4, 0, 0, 0);
+insert into sys.args values (35660, 301, 'arg_1', 'tinyint', 8, 0, 1, 1);
insert into sys.args values (35661, 301, 'arg_2', 'decimal', 4, 0, 1, 2);
-insert into sys.functions values (302, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35662, 302, 'res_0', 'decimal', 18, 0, 0, 0);
-insert into sys.args values (35663, 302, 'arg_1', 'decimal', 18, 0, 1, 1);
-insert into sys.args values (35664, 302, 'arg_2', 'decimal', 4, 0, 1, 2);
-insert into sys.functions values (303, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35665, 303, 'res_0', 'decimal', 18, 0, 0, 0);
-insert into sys.args values (35666, 303, 'arg_1', 'decimal', 18, 0, 1, 1);
-insert into sys.args values (35667, 303, 'arg_2', 'decimal', 4, 0, 1, 2);
+insert into sys.functions values (302, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35662, 302, 'res_0', 'decimal', 4, 0, 0, 0);
+insert into sys.args values (35663, 302, 'arg_1', 'decimal', 4, 0, 1, 1);
+insert into sys.args values (35664, 302, 'arg_2', 'tinyint', 8, 0, 1, 2);
+insert into sys.functions values (303, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35665, 303, 'res_0', 'decimal', 9, 0, 0, 0);
+insert into sys.args values (35666, 303, 'arg_1', 'decimal', 9, 0, 1, 1);
+insert into sys.args values (35667, 303, 'arg_2', 'tinyint', 8, 0, 1, 2);
insert into sys.functions values (304, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35668, 304, 'res_0', 'decimal', 18, 0, 0, 0);
-insert into sys.args values (35669, 304, 'arg_1', 'decimal', 18, 0, 1, 1);
+insert into sys.args values (35668, 304, 'res_0', 'decimal', 9, 0, 0, 0);
+insert into sys.args values (35669, 304, 'arg_1', 'tinyint', 8, 0, 1, 1);
insert into sys.args values (35670, 304, 'arg_2', 'decimal', 9, 0, 1, 2);
insert into sys.functions values (305, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35671, 305, 'res_0', 'decimal', 18, 0, 0, 0);
-insert into sys.args values (35672, 305, 'arg_1', 'decimal', 18, 0, 1, 1);
-insert into sys.args values (35673, 305, 'arg_2', 'decimal', 9, 0, 1, 2);
+insert into sys.args values (35671, 305, 'res_0', 'decimal', 9, 0, 0, 0);
+insert into sys.args values (35672, 305, 'arg_1', 'decimal', 9, 0, 1, 1);
+insert into sys.args values (35673, 305, 'arg_2', 'tinyint', 8, 0, 1, 2);
insert into sys.functions values (306, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35674, 306, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (35675, 306, 'arg_1', 'decimal', 38, 0, 1, 1);
-insert into sys.args values (35676, 306, 'arg_2', 'decimal', 4, 0, 1, 2);
-insert into sys.functions values (307, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35677, 307, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (35678, 307, 'arg_1', 'decimal', 38, 0, 1, 1);
-insert into sys.args values (35679, 307, 'arg_2', 'decimal', 4, 0, 1, 2);
-insert into sys.functions values (308, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35680, 308, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (35681, 308, 'arg_1', 'decimal', 38, 0, 1, 1);
-insert into sys.args values (35682, 308, 'arg_2', 'decimal', 9, 0, 1, 2);
-insert into sys.functions values (309, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35683, 309, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (35684, 309, 'arg_1', 'decimal', 38, 0, 1, 1);
-insert into sys.args values (35685, 309, 'arg_2', 'decimal', 9, 0, 1, 2);
+insert into sys.args values (35674, 306, 'res_0', 'decimal', 9, 0, 0, 0);
+insert into sys.args values (35675, 306, 'arg_1', 'decimal', 9, 0, 1, 1);
+insert into sys.args values (35676, 306, 'arg_2', 'smallint', 16, 0, 1, 2);
+insert into sys.functions values (307, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35677, 307, 'res_0', 'decimal', 9, 0, 0, 0);
+insert into sys.args values (35678, 307, 'arg_1', 'smallint', 16, 0, 1, 1);
+insert into sys.args values (35679, 307, 'arg_2', 'decimal', 9, 0, 1, 2);
+insert into sys.functions values (308, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35680, 308, 'res_0', 'decimal', 9, 0, 0, 0);
+insert into sys.args values (35681, 308, 'arg_1', 'decimal', 9, 0, 1, 1);
+insert into sys.args values (35682, 308, 'arg_2', 'smallint', 16, 0, 1, 2);
+insert into sys.functions values (309, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35683, 309, 'res_0', 'decimal', 18, 0, 0, 0);
+insert into sys.args values (35684, 309, 'arg_1', 'decimal', 18, 0, 1, 1);
+insert into sys.args values (35685, 309, 'arg_2', 'tinyint', 8, 0, 1, 2);
insert into sys.functions values (310, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35686, 310, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (35687, 310, 'arg_1', 'decimal', 38, 0, 1, 1);
+insert into sys.args values (35686, 310, 'res_0', 'decimal', 18, 0, 0, 0);
+insert into sys.args values (35687, 310, 'arg_1', 'tinyint', 8, 0, 1, 1);
insert into sys.args values (35688, 310, 'arg_2', 'decimal', 18, 0, 1, 2);
insert into sys.functions values (311, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35689, 311, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (35690, 311, 'arg_1', 'decimal', 38, 0, 1, 1);
-insert into sys.args values (35691, 311, 'arg_2', 'decimal', 18, 0, 1, 2);
-insert into sys.functions values (312, 'sql_sub', '-', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35692, 312, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (35693, 312, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.args values (35694, 312, 'arg_2', 'oid', 63, 0, 1, 2);
-insert into sys.functions values (313, 'sql_add', '+', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35695, 313, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (35696, 313, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.args values (35697, 313, 'arg_2', 'oid', 63, 0, 1, 2);
-insert into sys.functions values (314, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35698, 314, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (35699, 314, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.args values (35700, 314, 'arg_2', 'oid', 63, 0, 1, 2);
-insert into sys.functions values (315, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35701, 315, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (35702, 315, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.args values (35703, 315, 'arg_2', 'oid', 63, 0, 1, 2);
-insert into sys.functions values (316, 'bit_and', 'and', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35704, 316, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (35705, 316, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.args values (35706, 316, 'arg_2', 'oid', 63, 0, 1, 2);
-insert into sys.functions values (317, 'bit_or', 'or', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35707, 317, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (35708, 317, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.args values (35709, 317, 'arg_2', 'oid', 63, 0, 1, 2);
-insert into sys.functions values (318, 'bit_xor', 'xor', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35710, 318, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (35711, 318, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.args values (35712, 318, 'arg_2', 'oid', 63, 0, 1, 2);
-insert into sys.functions values (319, 'bit_not', 'not', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35713, 319, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (35714, 319, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.functions values (320, 'left_shift', '<<', 'calc', 0, 1,
false, false, false, 2000, true, false);
-insert into sys.args values (35715, 320, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (35716, 320, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.args values (35717, 320, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.functions values (321, 'right_shift', '>>', 'calc', 0, 1,
false, false, false, 2000, true, false);
-insert into sys.args values (35718, 321, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (35719, 321, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.args values (35720, 321, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.functions values (322, 'sql_neg', '-', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35721, 322, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (35722, 322, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.functions values (323, 'abs', 'abs', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35723, 323, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (35724, 323, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.functions values (324, 'sign', 'sign', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35725, 324, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (35726, 324, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.functions values (325, 'scale_up', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35727, 325, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (35728, 325, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.args values (35729, 325, 'arg_2', 'oid', 63, 0, 1, 2);
-insert into sys.functions values (326, 'scale_down', 'dec_round', 'sql', 0, 1,
false, false, false, 2000, true, false);
-insert into sys.args values (35730, 326, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (35731, 326, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.args values (35732, 326, 'arg_2', 'oid', 63, 0, 1, 2);
+insert into sys.args values (35689, 311, 'res_0', 'decimal', 18, 0, 0, 0);
+insert into sys.args values (35690, 311, 'arg_1', 'decimal', 18, 0, 1, 1);
+insert into sys.args values (35691, 311, 'arg_2', 'tinyint', 8, 0, 1, 2);
+insert into sys.functions values (312, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35692, 312, 'res_0', 'decimal', 18, 0, 0, 0);
+insert into sys.args values (35693, 312, 'arg_1', 'decimal', 18, 0, 1, 1);
+insert into sys.args values (35694, 312, 'arg_2', 'smallint', 16, 0, 1, 2);
+insert into sys.functions values (313, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35695, 313, 'res_0', 'decimal', 18, 0, 0, 0);
+insert into sys.args values (35696, 313, 'arg_1', 'smallint', 16, 0, 1, 1);
+insert into sys.args values (35697, 313, 'arg_2', 'decimal', 18, 0, 1, 2);
+insert into sys.functions values (314, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35698, 314, 'res_0', 'decimal', 18, 0, 0, 0);
+insert into sys.args values (35699, 314, 'arg_1', 'decimal', 18, 0, 1, 1);
+insert into sys.args values (35700, 314, 'arg_2', 'smallint', 16, 0, 1, 2);
+insert into sys.functions values (315, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35701, 315, 'res_0', 'decimal', 18, 0, 0, 0);
+insert into sys.args values (35702, 315, 'arg_1', 'decimal', 18, 0, 1, 1);
+insert into sys.args values (35703, 315, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.functions values (316, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35704, 316, 'res_0', 'decimal', 18, 0, 0, 0);
+insert into sys.args values (35705, 316, 'arg_1', 'int', 32, 0, 1, 1);
+insert into sys.args values (35706, 316, 'arg_2', 'decimal', 18, 0, 1, 2);
+insert into sys.functions values (317, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35707, 317, 'res_0', 'decimal', 18, 0, 0, 0);
+insert into sys.args values (35708, 317, 'arg_1', 'decimal', 18, 0, 1, 1);
+insert into sys.args values (35709, 317, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.functions values (318, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35710, 318, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (35711, 318, 'arg_1', 'decimal', 38, 0, 1, 1);
+insert into sys.args values (35712, 318, 'arg_2', 'tinyint', 8, 0, 1, 2);
+insert into sys.functions values (319, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35713, 319, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (35714, 319, 'arg_1', 'tinyint', 8, 0, 1, 1);
+insert into sys.args values (35715, 319, 'arg_2', 'decimal', 38, 0, 1, 2);
+insert into sys.functions values (320, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35716, 320, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (35717, 320, 'arg_1', 'decimal', 38, 0, 1, 1);
+insert into sys.args values (35718, 320, 'arg_2', 'tinyint', 8, 0, 1, 2);
+insert into sys.functions values (321, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35719, 321, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (35720, 321, 'arg_1', 'decimal', 38, 0, 1, 1);
+insert into sys.args values (35721, 321, 'arg_2', 'smallint', 16, 0, 1, 2);
+insert into sys.functions values (322, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35722, 322, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (35723, 322, 'arg_1', 'smallint', 16, 0, 1, 1);
+insert into sys.args values (35724, 322, 'arg_2', 'decimal', 38, 0, 1, 2);
+insert into sys.functions values (323, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35725, 323, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (35726, 323, 'arg_1', 'decimal', 38, 0, 1, 1);
+insert into sys.args values (35727, 323, 'arg_2', 'smallint', 16, 0, 1, 2);
+insert into sys.functions values (324, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35728, 324, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (35729, 324, 'arg_1', 'decimal', 38, 0, 1, 1);
+insert into sys.args values (35730, 324, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.functions values (325, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35731, 325, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (35732, 325, 'arg_1', 'int', 32, 0, 1, 1);
+insert into sys.args values (35733, 325, 'arg_2', 'decimal', 38, 0, 1, 2);
+insert into sys.functions values (326, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
+insert into sys.args values (35734, 326, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (35735, 326, 'arg_1', 'decimal', 38, 0, 1, 1);
+insert into sys.args values (35736, 326, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.functions values (327, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35733, 327, 'res_0', 'month_interval', 32, 0, 0,
0);
-insert into sys.args values (35734, 327, 'arg_1', 'month_interval', 32, 0, 1,
1);
-insert into sys.args values (35735, 327, 'arg_2', 'oid', 63, 0, 1, 2);
-insert into sys.functions values (328, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35736, 328, 'res_0', 'month_interval', 32, 0, 0,
0);
-insert into sys.args values (35737, 328, 'arg_1', 'month_interval', 32, 0, 1,
1);
-insert into sys.args values (35738, 328, 'arg_2', 'oid', 63, 0, 1, 2);
-insert into sys.functions values (329, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35739, 329, 'res_0', 'sec_interval', 13, 0, 0, 0);
-insert into sys.args values (35740, 329, 'arg_1', 'sec_interval', 13, 0, 1, 1);
-insert into sys.args values (35741, 329, 'arg_2', 'oid', 63, 0, 1, 2);
-insert into sys.functions values (330, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35742, 330, 'res_0', 'sec_interval', 13, 0, 0, 0);
-insert into sys.args values (35743, 330, 'arg_1', 'sec_interval', 13, 0, 1, 1);
-insert into sys.args values (35744, 330, 'arg_2', 'oid', 63, 0, 1, 2);
-insert into sys.functions values (331, 'sql_sub', '-', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35745, 331, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (35746, 331, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.args values (35747, 331, 'arg_2', 'tinyint', 8, 0, 1, 2);
-insert into sys.functions values (332, 'sql_add', '+', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35748, 332, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (35749, 332, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.args values (35750, 332, 'arg_2', 'tinyint', 8, 0, 1, 2);
-insert into sys.functions values (333, 'sql_mul', '*', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35751, 333, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (35752, 333, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.args values (35753, 333, 'arg_2', 'tinyint', 8, 0, 1, 2);
-insert into sys.functions values (334, 'sql_div', '/', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35754, 334, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (35755, 334, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.args values (35756, 334, 'arg_2', 'tinyint', 8, 0, 1, 2);
-insert into sys.functions values (335, 'bit_and', 'and', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35757, 335, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (35758, 335, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.args values (35759, 335, 'arg_2', 'tinyint', 8, 0, 1, 2);
-insert into sys.functions values (336, 'bit_or', 'or', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35760, 336, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (35761, 336, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.args values (35762, 336, 'arg_2', 'tinyint', 8, 0, 1, 2);
-insert into sys.functions values (337, 'bit_xor', 'xor', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35763, 337, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (35764, 337, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.args values (35765, 337, 'arg_2', 'tinyint', 8, 0, 1, 2);
-insert into sys.functions values (338, 'bit_not', 'not', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35766, 338, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (35767, 338, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.functions values (339, 'left_shift', '<<', 'calc', 0, 1,
false, false, false, 2000, true, false);
-insert into sys.args values (35768, 339, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (35769, 339, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.args values (35770, 339, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.functions values (340, 'right_shift', '>>', 'calc', 0, 1,
false, false, false, 2000, true, false);
-insert into sys.args values (35771, 340, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (35772, 340, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.args values (35773, 340, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.functions values (341, 'sql_neg', '-', 'calc', 0, 1, false,
false, false, 2000, true, false);
-insert into sys.args values (35774, 341, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (35775, 341, 'arg_1', 'tinyint', 8, 0, 1, 1);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
