Changeset: ae8f0ab448d9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ae8f0ab448d9
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: default
Log Message:
Fix and approve upgrade.
diffs (truncated from 124417 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
@@ -2554,14 +2554,14 @@ sql_update_default(Client c, mvc *sql, c
if ((buf = GDKmalloc(bufsize)) == NULL)
throw(SQL, __func__, SQLSTATE(HY013) MAL_MALLOC_FAIL);
- /* if there are 6 'lpad' functions of the same name in the catalog: ((1
or 2 string inputs) * (char or varchar or clob)), then upgrade */
+ /* if the keyword STREAM is in the list of keywords, upgrade */
pos += snprintf(buf + pos, bufsize - pos,
- "select id from sys.functions where
name = 'lpad' and mod = 'str' and func = 'lpad' and system = true;\n");
+ "select keyword from sys.keywords where
keyword = 'STREAM';\n");
assert(pos < bufsize);
if ((err = SQLstatementIntern(c, buf, "update", true, false, &output)))
goto bailout;
if ((b = BATdescriptor(output->cols[0].b))) {
- if (BATcount(b) == 6) {
+ if (BATcount(b) == 1) {
if (!*systabfixed && (err = sql_fix_system_tables(c,
sql, prev_schema)) != NULL)
goto bailout;
*systabfixed = true;
@@ -2582,7 +2582,7 @@ sql_update_default(Client c, mvc *sql, c
printf("Running database upgrade commands:\n%s\n", buf);
if ((err = SQLstatementIntern(c, buf, "update", true,
false, NULL)) != MAL_SUCCEED)
goto bailout;
-
+
pos = snprintf(buf, bufsize, "set schema \"sys\";\n"
"ALTER TABLE sys.keywords SET READ
ONLY;\n"
"ALTER TABLE sys.table_types SET READ
ONLY;\n");
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
@@ -532,14 +532,14 @@ insert into sys.args values (38554, 165,
insert into sys.args values (38555, 165, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38556, 165, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.functions values (166, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38557, 166, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38557, 166, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38558, 166, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38559, 166, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38560, 166, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38561, 166, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38562, 166, 'arg_5', 'tinyint', 8, 0, 1, 5);
insert into sys.functions values (167, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38563, 167, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38563, 167, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38564, 167, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38565, 167, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.args values (38566, 167, 'arg_3', 'int', 32, 0, 1, 3);
@@ -547,14 +547,14 @@ insert into sys.args values (38567, 167,
insert into sys.args values (38568, 167, 'arg_5', 'int', 32, 0, 1, 5);
insert into sys.args values (38569, 167, 'arg_6', 'tinyint', 8, 0, 1, 6);
insert into sys.functions values (168, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38570, 168, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38570, 168, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38571, 168, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38572, 168, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38573, 168, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38574, 168, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38575, 168, 'arg_5', 'smallint', 16, 0, 1, 5);
insert into sys.functions values (169, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38576, 169, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38576, 169, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38577, 169, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38578, 169, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.args values (38579, 169, 'arg_3', 'int', 32, 0, 1, 3);
@@ -562,14 +562,14 @@ insert into sys.args values (38580, 169,
insert into sys.args values (38581, 169, 'arg_5', 'int', 32, 0, 1, 5);
insert into sys.args values (38582, 169, 'arg_6', 'smallint', 16, 0, 1, 6);
insert into sys.functions values (170, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38583, 170, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38583, 170, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38584, 170, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38585, 170, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38586, 170, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38587, 170, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38588, 170, 'arg_5', 'int', 32, 0, 1, 5);
insert into sys.functions values (171, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38589, 171, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38589, 171, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38590, 171, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38591, 171, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.args values (38592, 171, 'arg_3', 'int', 32, 0, 1, 3);
@@ -577,14 +577,14 @@ insert into sys.args values (38593, 171,
insert into sys.args values (38594, 171, 'arg_5', 'int', 32, 0, 1, 5);
insert into sys.args values (38595, 171, 'arg_6', 'int', 32, 0, 1, 6);
insert into sys.functions values (172, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38596, 172, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38596, 172, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38597, 172, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38598, 172, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38599, 172, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38600, 172, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38601, 172, 'arg_5', 'bigint', 64, 0, 1, 5);
insert into sys.functions values (173, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38602, 173, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38602, 173, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38603, 173, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38604, 173, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.args values (38605, 173, 'arg_3', 'int', 32, 0, 1, 3);
@@ -592,134 +592,134 @@ insert into sys.args values (38606, 173,
insert into sys.args values (38607, 173, 'arg_5', 'int', 32, 0, 1, 5);
insert into sys.args values (38608, 173, 'arg_6', 'bigint', 64, 0, 1, 6);
insert into sys.functions values (174, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38609, 174, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38609, 174, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38610, 174, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38611, 174, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38612, 174, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38613, 174, 'arg_4', 'int', 32, 0, 1, 4);
-insert into sys.args values (38614, 174, 'arg_5', 'real', 24, 0, 1, 5);
+insert into sys.args values (38614, 174, 'arg_5', 'hugeint', 128, 0, 1, 5);
insert into sys.functions values (175, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38615, 175, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38615, 175, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38616, 175, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38617, 175, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.args values (38618, 175, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38619, 175, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38620, 175, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.args values (38621, 175, 'arg_6', 'real', 24, 0, 1, 6);
+insert into sys.args values (38621, 175, 'arg_6', 'hugeint', 128, 0, 1, 6);
insert into sys.functions values (176, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38622, 176, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38622, 176, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38623, 176, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38624, 176, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38625, 176, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38626, 176, 'arg_4', 'int', 32, 0, 1, 4);
-insert into sys.args values (38627, 176, 'arg_5', 'double', 53, 0, 1, 5);
+insert into sys.args values (38627, 176, 'arg_5', 'decimal', 2, 0, 1, 5);
insert into sys.functions values (177, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38628, 177, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38628, 177, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38629, 177, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38630, 177, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.args values (38631, 177, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38632, 177, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38633, 177, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.args values (38634, 177, 'arg_6', 'double', 53, 0, 1, 6);
+insert into sys.args values (38634, 177, 'arg_6', 'decimal', 2, 0, 1, 6);
insert into sys.functions values (178, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38635, 178, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38635, 178, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38636, 178, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38637, 178, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38638, 178, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38639, 178, 'arg_4', 'int', 32, 0, 1, 4);
-insert into sys.args values (38640, 178, 'arg_5', 'hugeint', 128, 0, 1, 5);
+insert into sys.args values (38640, 178, 'arg_5', 'decimal', 4, 0, 1, 5);
insert into sys.functions values (179, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38641, 179, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38641, 179, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38642, 179, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38643, 179, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.args values (38644, 179, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38645, 179, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38646, 179, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.args values (38647, 179, 'arg_6', 'hugeint', 128, 0, 1, 6);
+insert into sys.args values (38647, 179, 'arg_6', 'decimal', 4, 0, 1, 6);
insert into sys.functions values (180, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38648, 180, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38648, 180, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38649, 180, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38650, 180, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38651, 180, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38652, 180, 'arg_4', 'int', 32, 0, 1, 4);
-insert into sys.args values (38653, 180, 'arg_5', 'decimal', 2, 0, 1, 5);
+insert into sys.args values (38653, 180, 'arg_5', 'decimal', 9, 0, 1, 5);
insert into sys.functions values (181, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38654, 181, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38654, 181, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38655, 181, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38656, 181, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.args values (38657, 181, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38658, 181, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38659, 181, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.args values (38660, 181, 'arg_6', 'decimal', 2, 0, 1, 6);
+insert into sys.args values (38660, 181, 'arg_6', 'decimal', 9, 0, 1, 6);
insert into sys.functions values (182, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38661, 182, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38661, 182, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38662, 182, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38663, 182, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38664, 182, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38665, 182, 'arg_4', 'int', 32, 0, 1, 4);
-insert into sys.args values (38666, 182, 'arg_5', 'decimal', 4, 0, 1, 5);
+insert into sys.args values (38666, 182, 'arg_5', 'decimal', 18, 0, 1, 5);
insert into sys.functions values (183, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38667, 183, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38667, 183, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38668, 183, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38669, 183, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.args values (38670, 183, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38671, 183, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38672, 183, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.args values (38673, 183, 'arg_6', 'decimal', 4, 0, 1, 6);
+insert into sys.args values (38673, 183, 'arg_6', 'decimal', 18, 0, 1, 6);
insert into sys.functions values (184, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38674, 184, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38674, 184, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38675, 184, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38676, 184, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38677, 184, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38678, 184, 'arg_4', 'int', 32, 0, 1, 4);
-insert into sys.args values (38679, 184, 'arg_5', 'decimal', 9, 0, 1, 5);
+insert into sys.args values (38679, 184, 'arg_5', 'decimal', 38, 0, 1, 5);
insert into sys.functions values (185, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38680, 185, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38680, 185, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38681, 185, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38682, 185, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.args values (38683, 185, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38684, 185, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38685, 185, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.args values (38686, 185, 'arg_6', 'decimal', 9, 0, 1, 6);
+insert into sys.args values (38686, 185, 'arg_6', 'decimal', 38, 0, 1, 6);
insert into sys.functions values (186, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38687, 186, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38687, 186, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38688, 186, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38689, 186, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38690, 186, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38691, 186, 'arg_4', 'int', 32, 0, 1, 4);
-insert into sys.args values (38692, 186, 'arg_5', 'decimal', 18, 0, 1, 5);
+insert into sys.args values (38692, 186, 'arg_5', 'real', 24, 0, 1, 5);
insert into sys.functions values (187, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38693, 187, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38693, 187, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38694, 187, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38695, 187, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.args values (38696, 187, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38697, 187, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38698, 187, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.args values (38699, 187, 'arg_6', 'decimal', 18, 0, 1, 6);
+insert into sys.args values (38699, 187, 'arg_6', 'real', 24, 0, 1, 6);
insert into sys.functions values (188, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38700, 188, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38700, 188, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38701, 188, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38702, 188, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38703, 188, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38704, 188, 'arg_4', 'int', 32, 0, 1, 4);
-insert into sys.args values (38705, 188, 'arg_5', 'decimal', 38, 0, 1, 5);
+insert into sys.args values (38705, 188, 'arg_5', 'double', 53, 0, 1, 5);
insert into sys.functions values (189, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38706, 189, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38706, 189, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38707, 189, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38708, 189, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.args values (38709, 189, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38710, 189, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38711, 189, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.args values (38712, 189, 'arg_6', 'decimal', 38, 0, 1, 6);
+insert into sys.args values (38712, 189, 'arg_6', 'double', 53, 0, 1, 6);
insert into sys.functions values (190, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38713, 190, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38713, 190, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38714, 190, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38715, 190, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38716, 190, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38717, 190, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38718, 190, 'arg_5', 'month_interval', 3, 0, 1,
5);
insert into sys.functions values (191, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38719, 191, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38719, 191, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38720, 191, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38721, 191, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.args values (38722, 191, 'arg_3', 'int', 32, 0, 1, 3);
@@ -727,14 +727,14 @@ insert into sys.args values (38723, 191,
insert into sys.args values (38724, 191, 'arg_5', 'int', 32, 0, 1, 5);
insert into sys.args values (38725, 191, 'arg_6', 'month_interval', 3, 0, 1,
6);
insert into sys.functions values (192, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38726, 192, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38726, 192, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38727, 192, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38728, 192, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38729, 192, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38730, 192, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38731, 192, 'arg_5', 'day_interval', 4, 0, 1, 5);
insert into sys.functions values (193, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38732, 193, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38732, 193, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38733, 193, 'arg_1', 'boolean', 1, 0, 1, 1);
insert into sys.args values (38734, 193, 'arg_2', 'any', 0, 0, 1, 2);
insert into sys.args values (38735, 193, 'arg_3', 'int', 32, 0, 1, 3);
@@ -742,14 +742,14 @@ insert into sys.args values (38736, 193,
insert into sys.args values (38737, 193, 'arg_5', 'int', 32, 0, 1, 5);
insert into sys.args values (38738, 193, 'arg_6', 'day_interval', 4, 0, 1, 6);
insert into sys.functions values (194, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38739, 194, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (38739, 194, 'res_0', 'oid', 63, 0, 0, 0);
insert into sys.args values (38740, 194, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (38741, 194, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.args values (38742, 194, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38743, 194, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38744, 194, 'arg_5', 'sec_interval', 13, 0, 1, 5);
insert into sys.functions values (195, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true, true);
-insert into sys.args values (38745, 195, 'res_0', 'bigint', 64, 0, 0, 0);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
