Changeset: b99603e735a6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b99603e735a6
Modified Files:
clients/mapilib/mapi.c
sql/ChangeLog.Apr2019
sql/common/sql_types.c
sql/server/rel_optimizer.c
sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.sql
sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.stable.out
sql/test/Tests/systemfunctions.stable.out
sql/test/Tests/systemfunctions.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/pg_regress/Tests/float4.sql
sql/test/pg_regress/Tests/float4.stable.err
sql/test/pg_regress/Tests/float4.stable.out
sql/test/pg_regress/Tests/float8.sql
sql/test/pg_regress/Tests/float8.stable.out
sql/test/pg_regress/Tests/float8.stable.out.Windows
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
sql/test/testdb-upgrade/Tests/upgrade.stable.out.powerpc64.int128
Branch: default
Log Message:
Merge with Apr2019 branch.
diffs (truncated from 165020 to 300 lines):
diff --git a/clients/mapilib/mapi.c b/clients/mapilib/mapi.c
--- a/clients/mapilib/mapi.c
+++ b/clients/mapilib/mapi.c
@@ -4171,13 +4171,20 @@ read_into_cache(MapiHdl hdl, int lookahe
} else {
off = strtoul(line, &line, 10);
}
- assert(*line == ' ');
- line++; /* skip one space */
+ if (*line++ != ' ') {
+ mnstr_printf(mid->to,
"!HY000!unrecognized command from server\n");
+ mnstr_flush(mid->to);
+ break;
+ }
read_file(hdl, off, strdup(line),
binary);
break;
}
case 'w':
- line++; /* skip one space */
+ if (*line++ != ' ') {
+ mnstr_printf(mid->to,
"!HY000!unrecognized command from server\n");
+ mnstr_flush(mid->to);
+ break;
+ }
write_file(hdl, strdup(line));
break;
}
diff --git a/sql/ChangeLog.Apr2019 b/sql/ChangeLog.Apr2019
--- a/sql/ChangeLog.Apr2019
+++ b/sql/ChangeLog.Apr2019
@@ -1,6 +1,11 @@
# ChangeLog file for sql
# This file is updated with Maddlog
+* Mon Jan 28 2019 Sjoerd Mullender <[email protected]>
+- Implemented two-argument least/greatest functions. If one argument
+ is NULL, the functions return the other value, otherwise they return
+ the least/greatest of the two arguments.
+
* Wed Jan 23 2019 Sjoerd Mullender <[email protected]>
- Function octet_length now also accepts a BLOB argument and returns
the length of the BLOB (i.e. the same as length when called with a
diff --git a/sql/common/sql_types.c b/sql/common/sql_types.c
--- a/sql/common/sql_types.c
+++ b/sql/common/sql_types.c
@@ -1567,6 +1567,8 @@ sqltypeinit( sql_allocator *sa)
sql_create_aggr(sa, "max", "aggr", "max", ANY, ANY);
sql_create_func(sa, "sql_min", "calc", "min", ANY, ANY, ANY, SCALE_FIX);
sql_create_func(sa, "sql_max", "calc", "max", ANY, ANY, ANY, SCALE_FIX);
+ sql_create_func(sa, "least", "calc", "min_no_nil", ANY, ANY, ANY,
SCALE_FIX);
+ sql_create_func(sa, "greatest", "calc", "max_no_nil", ANY, ANY, ANY,
SCALE_FIX);
sql_create_func3(sa, "ifthenelse", "calc", "ifthenelse", BIT, ANY, ANY,
ANY, SCALE_FIX);
/* sum for numerical and decimals */
diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c
--- a/sql/server/rel_optimizer.c
+++ b/sql/server/rel_optimizer.c
@@ -2961,8 +2961,20 @@ exp_simplify_math( mvc *sql, sql_exp *e,
sql_exp *re = l->h->next->data;
sql_subtype *et = exp_subtype(e);
+ /* if one argument is NULL, return it, EXCEPT
+ * if "_no_nil" is in the name of the
+ * implementation function (currently either
+ * min_no_nil or max_no_nil), in which case we
+ * ignore the NULL and return the other
+ * value */
if (exp_is_atom(le) && exp_is_null(sql, le)) {
(*changes)++;
+ if (f && f->func && f->func->imp &&
strstr(f->func->imp, "_no_nil") != NULL) {
+ exp_setname(sql->sa, re,
exp_relname(e), exp_name(e));
+ if (subtype_cmp(et, exp_subtype(re)) !=
0)
+ re = exp_convert(sql->sa, re,
exp_subtype(re), et);
+ return re;
+ }
exp_setname(sql->sa, le, exp_relname(e),
exp_name(e));
if (subtype_cmp(et, exp_subtype(le)) != 0)
le = exp_convert(sql->sa, le,
exp_subtype(le), et);
@@ -2970,6 +2982,12 @@ exp_simplify_math( mvc *sql, sql_exp *e,
}
if (exp_is_atom(re) && exp_is_null(sql, re)) {
(*changes)++;
+ if (f && f->func && f->func->imp &&
strstr(f->func->imp, "_no_nil") != NULL) {
+ exp_setname(sql->sa, le,
exp_relname(e), exp_name(e));
+ if (subtype_cmp(et, exp_subtype(le)) !=
0)
+ le = exp_convert(sql->sa, le,
exp_subtype(le), et);
+ return le;
+ }
exp_setname(sql->sa, re, exp_relname(e),
exp_name(e));
if (subtype_cmp(et, exp_subtype(re)) != 0)
re = exp_convert(sql->sa, re,
exp_subtype(re), et);
diff --git a/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.sql
b/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.sql
--- a/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.sql
+++ b/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.sql
@@ -2,7 +2,10 @@ CREATE SCHEMA "dropme";
CREATE LOCAL TEMP TABLE "dropme"."temp1" ("id" int, "name" VARCHAR(99));
--error
CREATE GLOBAL TEMP TABLE "dropme"."temp2" ("id" int, "name" VARCHAR(99));
--error
DROP SCHEMA "dropme";
+
START TRANSACTION;
CREATE LOCAL TEMP TABLE "temp1" ("id" int, "name" VARCHAR(99));
CREATE GLOBAL TEMP TABLE "temp2" ("id" int, "name" VARCHAR(99));
+CREATE LOCAL TEMPORARY TABLE tmp."temp3" ("id" int, "name" VARCHAR(99));
+CREATE GLOBAL TEMPORARY TABLE tmp."temp4" ("id" int, "name" VARCHAR(99));
ROLLBACK;
diff --git
a/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.stable.out
b/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.stable.out
--- a/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.stable.out
+++ b/sql/test/BugTracker-2018/Tests/global-temp-tables.Bug-6643.stable.out
@@ -69,6 +69,8 @@ Ready.
#START TRANSACTION;
#CREATE LOCAL TEMP TABLE "temp1" ("id" int, "name" VARCHAR(99));
#CREATE GLOBAL TEMP TABLE "temp2" ("id" int, "name" VARCHAR(99));
+#CREATE LOCAL TEMPORARY TABLE tmp."temp3" ("id" int, "name" VARCHAR(99));
+#CREATE GLOBAL TEMPORARY TABLE tmp."temp4" ("id" int, "name" VARCHAR(99));
#ROLLBACK;
# 16:48:58 >
diff --git a/sql/test/Tests/systemfunctions.stable.out
b/sql/test/Tests/systemfunctions.stable.out
--- a/sql/test/Tests/systemfunctions.stable.out
+++ b/sql/test/Tests/systemfunctions.stable.out
@@ -665,6 +665,9 @@ Ready.
[ "sys", "getroboturl", 1, "url", "" ]
[ "sys", "getuser", 0, "clob", "create function getuser(theurl
url) returns string\n external name url.\"getUser\";" ]
[ "sys", "getuser", 1, "url", "" ]
+[ "sys", "greatest", 0, "any", "max_no_nil" ]
+[ "sys", "greatest", 1, "any", "" ]
+[ "sys", "greatest", 2, "any", "" ]
[ "sys", "group_concat", 0, "clob", "create aggregate
sys.group_concat(str string) returns string external name
\"aggr\".\"str_group_concat\";" ]
[ "sys", "group_concat", 1, "clob", "" ]
[ "sys", "group_concat", 0, "clob", "create aggregate
sys.group_concat(str string, sep string) returns string external name
\"aggr\".\"str_group_concat\";" ]
@@ -873,6 +876,9 @@ Ready.
[ "sys", "lead", 3, "any", "" ]
[ "sys", "lead", 4, "boolean", "" ]
[ "sys", "lead", 5, "boolean", "" ]
+[ "sys", "least", 0, "any", "min_no_nil" ]
+[ "sys", "least", 1, "any", "" ]
+[ "sys", "least", 2, "any", "" ]
[ "sys", "left", 0, "char", "stringleft" ]
[ "sys", "left", 1, "char", "" ]
[ "sys", "left", 2, "int", "" ]
diff --git a/sql/test/Tests/systemfunctions.stable.out.int128
b/sql/test/Tests/systemfunctions.stable.out.int128
--- a/sql/test/Tests/systemfunctions.stable.out.int128
+++ b/sql/test/Tests/systemfunctions.stable.out.int128
@@ -711,6 +711,9 @@ Ready.
[ "sys", "getroboturl", 1, "url", "" ]
[ "sys", "getuser", 0, "clob", "create function getuser(theurl
url) returns string\n external name url.\"getUser\";" ]
[ "sys", "getuser", 1, "url", "" ]
+[ "sys", "greatest", 0, "any", "max_no_nil" ]
+[ "sys", "greatest", 1, "any", "" ]
+[ "sys", "greatest", 2, "any", "" ]
[ "sys", "group_concat", 0, "clob", "create aggregate
sys.group_concat(str string) returns string external name
\"aggr\".\"str_group_concat\";" ]
[ "sys", "group_concat", 1, "clob", "" ]
[ "sys", "group_concat", 0, "clob", "create aggregate
sys.group_concat(str string, sep string) returns string external name
\"aggr\".\"str_group_concat\";" ]
@@ -941,6 +944,9 @@ Ready.
[ "sys", "lead", 3, "any", "" ]
[ "sys", "lead", 4, "boolean", "" ]
[ "sys", "lead", 5, "boolean", "" ]
+[ "sys", "least", 0, "any", "min_no_nil" ]
+[ "sys", "least", 1, "any", "" ]
+[ "sys", "least", 2, "any", "" ]
[ "sys", "left", 0, "char", "stringleft" ]
[ "sys", "left", 1, "char", "" ]
[ "sys", "left", 2, "int", "" ]
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
@@ -282,5599 +282,5607 @@ insert into sys.functions values (88, 's
insert into sys.args values (20821, 88, 'res_0', 'any', 0, 0, 0, 0);
insert into sys.args values (20822, 88, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (20823, 88, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (89, 'ifthenelse', 'ifthenelse', 'calc', 0,
1, false, false, false, 2000, true);
+insert into sys.functions values (89, 'least', 'min_no_nil', 'calc', 0, 1,
false, false, false, 2000, true);
insert into sys.args values (20824, 89, 'res_0', 'any', 0, 0, 0, 0);
-insert into sys.args values (20825, 89, 'arg_1', 'boolean', 1, 0, 1, 1);
+insert into sys.args values (20825, 89, 'arg_1', 'any', 0, 0, 1, 1);
insert into sys.args values (20826, 89, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.args values (20827, 89, 'arg_3', 'any', 0, 0, 1, 3);
-insert into sys.functions values (110, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
-insert into sys.args values (20828, 110, 'res_0', 'oid', 63, 0, 0, 0);
-insert into sys.args values (20829, 110, 'arg_1', 'oid', 63, 0, 1, 1);
-insert into sys.args values (20830, 110, 'arg_2', 'oid', 63, 0, 1, 2);
-insert into sys.functions values (111, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
-insert into sys.args values (20831, 111, 'res_0', 'tinyint', 8, 0, 0, 0);
-insert into sys.args values (20832, 111, 'arg_1', 'tinyint', 8, 0, 1, 1);
-insert into sys.args values (20833, 111, 'arg_2', 'tinyint', 8, 0, 1, 2);
+insert into sys.functions values (90, 'greatest', 'max_no_nil', 'calc', 0, 1,
false, false, false, 2000, true);
+insert into sys.args values (20827, 90, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (20828, 90, 'arg_1', 'any', 0, 0, 1, 1);
+insert into sys.args values (20829, 90, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.functions values (91, 'ifthenelse', 'ifthenelse', 'calc', 0,
1, false, false, false, 2000, true);
+insert into sys.args values (20830, 91, 'res_0', 'any', 0, 0, 0, 0);
+insert into sys.args values (20831, 91, 'arg_1', 'boolean', 1, 0, 1, 1);
+insert into sys.args values (20832, 91, 'arg_2', 'any', 0, 0, 1, 2);
+insert into sys.args values (20833, 91, 'arg_3', 'any', 0, 0, 1, 3);
insert into sys.functions values (112, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
-insert into sys.args values (20834, 112, 'res_0', 'smallint', 16, 0, 0, 0);
-insert into sys.args values (20835, 112, 'arg_1', 'smallint', 16, 0, 1, 1);
-insert into sys.args values (20836, 112, 'arg_2', 'smallint', 16, 0, 1, 2);
+insert into sys.args values (20834, 112, 'res_0', 'oid', 63, 0, 0, 0);
+insert into sys.args values (20835, 112, 'arg_1', 'oid', 63, 0, 1, 1);
+insert into sys.args values (20836, 112, 'arg_2', 'oid', 63, 0, 1, 2);
insert into sys.functions values (113, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
-insert into sys.args values (20837, 113, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.args values (20838, 113, 'arg_1', 'int', 32, 0, 1, 1);
-insert into sys.args values (20839, 113, 'arg_2', 'int', 32, 0, 1, 2);
+insert into sys.args values (20837, 113, 'res_0', 'tinyint', 8, 0, 0, 0);
+insert into sys.args values (20838, 113, 'arg_1', 'tinyint', 8, 0, 1, 1);
+insert into sys.args values (20839, 113, 'arg_2', 'tinyint', 8, 0, 1, 2);
insert into sys.functions values (114, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
-insert into sys.args values (20840, 114, 'res_0', 'bigint', 64, 0, 0, 0);
-insert into sys.args values (20841, 114, 'arg_1', 'bigint', 64, 0, 1, 1);
-insert into sys.args values (20842, 114, 'arg_2', 'bigint', 64, 0, 1, 2);
+insert into sys.args values (20840, 114, 'res_0', 'smallint', 16, 0, 0, 0);
+insert into sys.args values (20841, 114, 'arg_1', 'smallint', 16, 0, 1, 1);
+insert into sys.args values (20842, 114, 'arg_2', 'smallint', 16, 0, 1, 2);
insert into sys.functions values (115, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
-insert into sys.args values (20843, 115, 'res_0', 'hugeint', 128, 0, 0, 0);
-insert into sys.args values (20844, 115, 'arg_1', 'hugeint', 128, 0, 1, 1);
-insert into sys.args values (20845, 115, 'arg_2', 'hugeint', 128, 0, 1, 2);
+insert into sys.args values (20843, 115, 'res_0', 'int', 32, 0, 0, 0);
+insert into sys.args values (20844, 115, 'arg_1', 'int', 32, 0, 1, 1);
+insert into sys.args values (20845, 115, 'arg_2', 'int', 32, 0, 1, 2);
insert into sys.functions values (116, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
-insert into sys.args values (20846, 116, 'res_0', 'decimal', 2, 0, 0, 0);
-insert into sys.args values (20847, 116, 'arg_1', 'decimal', 2, 0, 1, 1);
-insert into sys.args values (20848, 116, 'arg_2', 'decimal', 2, 0, 1, 2);
+insert into sys.args values (20846, 116, 'res_0', 'bigint', 64, 0, 0, 0);
+insert into sys.args values (20847, 116, 'arg_1', 'bigint', 64, 0, 1, 1);
+insert into sys.args values (20848, 116, 'arg_2', 'bigint', 64, 0, 1, 2);
insert into sys.functions values (117, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
-insert into sys.args values (20849, 117, 'res_0', 'decimal', 4, 0, 0, 0);
-insert into sys.args values (20850, 117, 'arg_1', 'decimal', 4, 0, 1, 1);
-insert into sys.args values (20851, 117, 'arg_2', 'decimal', 4, 0, 1, 2);
+insert into sys.args values (20849, 117, 'res_0', 'hugeint', 128, 0, 0, 0);
+insert into sys.args values (20850, 117, 'arg_1', 'hugeint', 128, 0, 1, 1);
+insert into sys.args values (20851, 117, 'arg_2', 'hugeint', 128, 0, 1, 2);
insert into sys.functions values (118, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
-insert into sys.args values (20852, 118, 'res_0', 'decimal', 9, 0, 0, 0);
-insert into sys.args values (20853, 118, 'arg_1', 'decimal', 9, 0, 1, 1);
-insert into sys.args values (20854, 118, 'arg_2', 'decimal', 9, 0, 1, 2);
+insert into sys.args values (20852, 118, 'res_0', 'decimal', 2, 0, 0, 0);
+insert into sys.args values (20853, 118, 'arg_1', 'decimal', 2, 0, 1, 1);
+insert into sys.args values (20854, 118, 'arg_2', 'decimal', 2, 0, 1, 2);
insert into sys.functions values (119, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
-insert into sys.args values (20855, 119, 'res_0', 'decimal', 18, 0, 0, 0);
-insert into sys.args values (20856, 119, 'arg_1', 'decimal', 18, 0, 1, 1);
-insert into sys.args values (20857, 119, 'arg_2', 'decimal', 18, 0, 1, 2);
+insert into sys.args values (20855, 119, 'res_0', 'decimal', 4, 0, 0, 0);
+insert into sys.args values (20856, 119, 'arg_1', 'decimal', 4, 0, 1, 1);
+insert into sys.args values (20857, 119, 'arg_2', 'decimal', 4, 0, 1, 2);
insert into sys.functions values (120, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
-insert into sys.args values (20858, 120, 'res_0', 'decimal', 38, 0, 0, 0);
-insert into sys.args values (20859, 120, 'arg_1', 'decimal', 38, 0, 1, 1);
-insert into sys.args values (20860, 120, 'arg_2', 'decimal', 38, 0, 1, 2);
+insert into sys.args values (20858, 120, 'res_0', 'decimal', 9, 0, 0, 0);
+insert into sys.args values (20859, 120, 'arg_1', 'decimal', 9, 0, 1, 1);
+insert into sys.args values (20860, 120, 'arg_2', 'decimal', 9, 0, 1, 2);
insert into sys.functions values (121, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
-insert into sys.args values (20861, 121, 'res_0', 'real', 24, 0, 0, 0);
-insert into sys.args values (20862, 121, 'arg_1', 'real', 24, 0, 1, 1);
-insert into sys.args values (20863, 121, 'arg_2', 'real', 24, 0, 1, 2);
+insert into sys.args values (20861, 121, 'res_0', 'decimal', 18, 0, 0, 0);
+insert into sys.args values (20862, 121, 'arg_1', 'decimal', 18, 0, 1, 1);
+insert into sys.args values (20863, 121, 'arg_2', 'decimal', 18, 0, 1, 2);
insert into sys.functions values (122, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
-insert into sys.args values (20864, 122, 'res_0', 'double', 53, 0, 0, 0);
-insert into sys.args values (20865, 122, 'arg_1', 'double', 53, 0, 1, 1);
-insert into sys.args values (20866, 122, 'arg_2', 'double', 53, 0, 1, 2);
-insert into sys.functions values (138, 'diff', 'diff', 'sql', 0, 6, false,
false, false, 2000, true);
-insert into sys.args values (20867, 138, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20868, 138, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.functions values (139, 'diff', 'diff', 'sql', 0, 6, false,
false, false, 2000, true);
-insert into sys.args values (20869, 139, 'res_0', 'boolean', 1, 0, 0, 0);
-insert into sys.args values (20870, 139, 'arg_1', 'boolean', 1, 0, 1, 1);
-insert into sys.args values (20871, 139, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.functions values (140, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true);
-insert into sys.args values (20872, 140, 'res_0', 'bigint', 64, 0, 0, 0);
-insert into sys.args values (20873, 140, 'arg_1', 'any', 0, 0, 1, 1);
-insert into sys.args values (20874, 140, 'arg_2', 'int', 32, 0, 1, 2);
-insert into sys.args values (20875, 140, 'arg_3', 'int', 32, 0, 1, 3);
-insert into sys.args values (20876, 140, 'arg_4', 'int', 32, 0, 1, 4);
-insert into sys.args values (20877, 140, 'arg_5', 'tinyint', 8, 0, 1, 5);
-insert into sys.functions values (141, 'window_bound', 'window_bound', 'sql',
0, 6, false, false, false, 2000, true);
-insert into sys.args values (20878, 141, 'res_0', 'bigint', 64, 0, 0, 0);
-insert into sys.args values (20879, 141, 'arg_1', 'boolean', 1, 0, 1, 1);
-insert into sys.args values (20880, 141, 'arg_2', 'any', 0, 0, 1, 2);
-insert into sys.args values (20881, 141, 'arg_3', 'int', 32, 0, 1, 3);
-insert into sys.args values (20882, 141, 'arg_4', 'int', 32, 0, 1, 4);
-insert into sys.args values (20883, 141, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.args values (20884, 141, 'arg_6', 'tinyint', 8, 0, 1, 6);
+insert into sys.args values (20864, 122, 'res_0', 'decimal', 38, 0, 0, 0);
+insert into sys.args values (20865, 122, 'arg_1', 'decimal', 38, 0, 1, 1);
+insert into sys.args values (20866, 122, 'arg_2', 'decimal', 38, 0, 1, 2);
+insert into sys.functions values (123, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20867, 123, 'res_0', 'real', 24, 0, 0, 0);
+insert into sys.args values (20868, 123, 'arg_1', 'real', 24, 0, 1, 1);
+insert into sys.args values (20869, 123, 'arg_2', 'real', 24, 0, 1, 2);
+insert into sys.functions values (124, 'mod', '%', 'calc', 0, 1, false, false,
false, 2000, true);
+insert into sys.args values (20870, 124, 'res_0', 'double', 53, 0, 0, 0);
+insert into sys.args values (20871, 124, 'arg_1', 'double', 53, 0, 1, 1);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
