Changeset: b5fd166d974e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b5fd166d974e
Branch: ppbench
Log Message:
merged with pp_hashjion
diffs (truncated from 392 to 300 lines):
diff --git a/clients/Tests/MAL-signatures-hge.test
b/clients/Tests/MAL-signatures-hge.test
--- a/clients/Tests/MAL-signatures-hge.test
+++ b/clients/Tests/MAL-signatures-hge.test
@@ -269,11 +269,6 @@ command aggr.cardinality(X_0:bat[:any_2]
ALGcard
Return the cardinality of the BAT tail values.
aggr
-cde
-command aggr.cde(X_0:bat[:any_1]):int
-AGGRcde
-(empty)
-aggr
cnull
command aggr.cnull(X_0:bat[:oid], X_1:bat[:bit], X_2:ptr,
X_3:bat[:oid]):bat[:bit]
LALGcnull
@@ -3429,6 +3424,11 @@ pattern aggr.sum(X_0:bat[:oid], X_1:bat[
LALGsum_float
Kahan/Neumaier summation per group.
aggr
+uniques_guess
+command aggr.uniques_guess(X_0:bat[:any_1]):lng
+uniques_guess
+(empty)
+aggr
variance
command aggr.variance(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl]
AGGRvariance3_dbl
@@ -48088,11 +48088,6 @@ sum_no_nil
unsafe pattern lockedaggr.sum_no_nil(X_0:any_1):bat[:any_1]
LOCKEDAGGRsum_no_nil1
sum values into bat (bat has value, update), using the bat lock
-lockedalgebra
-projection
-command lockedalgebra.projection(X_0:ptr, X_1:bat[:oid],
X_2:bat[:any_1]):bat[:any_1]
-LALGprojection
-Project left input onto right input.
lockedgroup
group
command lockedgroup.group(X_0:bat[:any_1]) (X_1:bat[:oid], X_2:bat[:oid],
X_3:bat[:lng])
diff --git a/clients/Tests/MAL-signatures.test
b/clients/Tests/MAL-signatures.test
--- a/clients/Tests/MAL-signatures.test
+++ b/clients/Tests/MAL-signatures.test
@@ -249,11 +249,6 @@ command aggr.cardinality(X_0:bat[:any_2]
ALGcard
Return the cardinality of the BAT tail values.
aggr
-cde
-command aggr.cde(X_0:bat[:any_1]):int
-AGGRcde
-(empty)
-aggr
cnull
command aggr.cnull(X_0:bat[:oid], X_1:bat[:bit], X_2:ptr,
X_3:bat[:oid]):bat[:bit]
LALGcnull
@@ -2874,6 +2869,11 @@ pattern aggr.sum(X_0:bat[:oid], X_1:bat[
LALGsum_float
Kahan/Neumaier summation per group.
aggr
+uniques_guess
+command aggr.uniques_guess(X_0:bat[:any_1]):lng
+uniques_guess
+(empty)
+aggr
variance
command aggr.variance(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl]
AGGRvariance3_dbl
@@ -36463,11 +36463,6 @@ sum
unsafe pattern lockedaggr.sum(X_0:any_1):bat[:any_1]
LOCKEDAGGRsum1
sum values into bat (bat has value, update), using the bat lock
-lockedalgebra
-projection
-command lockedalgebra.projection(X_0:ptr, X_1:bat[:oid],
X_2:bat[:any_1]):bat[:any_1]
-LALGprojection
-Project left input onto right input.
lockedgroup
group
command lockedgroup.group(X_0:bat[:any_1]) (X_1:bat[:oid], X_2:bat[:oid],
X_3:bat[:lng])
diff --git a/monetdb5/mal/mal_client.c b/monetdb5/mal/mal_client.c
--- a/monetdb5/mal/mal_client.c
+++ b/monetdb5/mal/mal_client.c
@@ -274,6 +274,8 @@ MCinitClientRecord(Client c, oid user, b
char name[MT_NAME_LEN];
snprintf(name, sizeof(name), "Client%d->s", (int) (c - mal_clients));
MT_sema_init(&c->s, 0, name);
+ snprintf(name, sizeof(name), "Client%d-errlock", (int) (c -
mal_clients));
+ MT_lock_init(&c->error_lock, name);
return c;
}
@@ -407,6 +409,7 @@ MCcloseClient(Client c)
MT_thread_set_qry_ctx(NULL);
//assert(strcmp(MT_thread_getname(), "main-thread") == 0 ||
c->qryctx.datasize == 0);
MT_sema_destroy(&c->s);
+ MT_lock_destroy(&c->error_lock);
MT_lock_set(&mal_contextLock);
c->idle = c->login = c->lastcmd = 0;
ma_destroy(c->qryctx.errorallocator);
diff --git a/monetdb5/modules/mal/pp_algebra.c
b/monetdb5/modules/mal/pp_algebra.c
--- a/monetdb5/modules/mal/pp_algebra.c
+++ b/monetdb5/modules/mal/pp_algebra.c
@@ -918,18 +918,6 @@ LOCKEDAGGRnull(Client ctx, bat *result,
return err;
}
-static str
-LALGprojection(Client ctx, bat *result, const ptr *h, const bat *lid, const
bat *rid)
-{
- Pipeline *p = (Pipeline*)*h;
- str res;
-
- pipeline_lock(p);
- res = ALGprojection(ctx, result, lid, rid);
- pipeline_unlock(p);
- return res;
-}
-
#define unique_(Type, BaseType, INIT_ALLOCATOR, INIT_ITER, NEW_VAL, HASH_VAL,
VAL_NOT_EQUAL, VAL_ASSIGN, ITER_NEXT, NEXTK) \
if (tt == TYPE_##Type) { \
int slots = 0; \
@@ -2530,9 +2518,9 @@ LALGproject(Client ctx, bat *rid, bat *g
aproject_(str)
} else {
aproject(str,1,uint8_t)
- aproject(str,2,uint16_t)
- aproject(str,4,uint32_t)
- aproject(str,8,var_t)
+ aproject(str,2,uint16_t)
+ aproject(str,4,uint32_t)
+ aproject(str,8,var_t)
}
TIMEOUT_CHECK(qry_ctx, err = createException(SQL, "pp
algebra.projection", RUNTIME_QRY_TIMEOUT));
}
@@ -4934,7 +4922,6 @@ static mel_func pp_algebra_init_funcs[]
pattern("lockedaggr", "min", LOCKEDAGGRmin, true, "min values into bat (bat
has value, update), using the bat lock", args(1,2, sharedbatargany("", 1),
argany("val", 1))),
pattern("lockedaggr", "max", LOCKEDAGGRmax, true, "max values into bat (bat
has value, update), using the bat lock", args(1,2, sharedbatargany("", 1),
argany("val", 1))),
command("lockedaggr", "null", LOCKEDAGGRnull, true, "Returns true or false if
the input contains a NULL or not, nil if the input is empty..", args(1,2,
sharedbatarg("",bit),arg("hadnull",bit))),
- command("lockedalgebra", "projection", LALGprojection, false, "Project left
input onto right input.", args(1,4, batargany("",1), arg("pipeline", ptr),
batarg("left",oid),batargany("right",1))),
command("algebra", "unique", LALGunique, false, "Unique rows.", args(2,5,
batarg("gid", oid), batargany("",1), arg("pipeline", ptr), batargany("b",1),
batarg("s",oid))),
command("algebra", "unique", LALGgroup_unique, false, "Unique per group
rows.", args(2,6, batarg("ngid", oid), batargany("",1), arg("pipeline", ptr),
batargany("b",1), batarg("s",oid), batarg("gid",oid))),
@@ -4994,8 +4981,6 @@ static mel_func pp_algebra_init_funcs[]
command("aggr", "avg", ALGfsum, false, "Return the Kahan/Neumaier
summation.", args(3,4, arg("rsum", dbl), arg("rcom", dbl), arg("rcnt", lng),
batarg("b", dbl))),
command("aggr", "avg", ALGfsum_skipnil, false, "Return the Kahan/Neumaier
summation or nil.", args(3,5, arg("rsum", dbl), arg("rcom", dbl), arg("rcnt",
lng), batarg("b", dbl), arg("skipnil",bit))),
command("aggr", "ord_quantile", LALGquantile, false, "Return the p-th's
quantile per group, where p is between 0 and 100", args(1,4,
batargany("quantile", 1), batarg("gid", oid), batargany("i", 1), arg("p",
bte))),
- //command("aggr", "quantile", LALGquantile, false, "Return the p-th's
quantile per group, where p is between 0 and 100", args(1,5,
batargany("quantile", 1), batarg("gid", oid), batargany("i", 1),
arg("pipeline", ptr), batarg("pid", oid))),
- /* in combine we return the pth row (or avg) */
{ .imp=NULL }
};
#include "mal_import.h"
diff --git a/monetdb5/modules/mal/pp_mat.c b/monetdb5/modules/mal/pp_mat.c
--- a/monetdb5/modules/mal/pp_mat.c
+++ b/monetdb5/modules/mal/pp_mat.c
@@ -311,7 +311,7 @@ PARTpartition(Client ctx, bat *pos, cons
}
\
if (BATcount(mt->bat[i]) < (BUN)(curpos[i]+lp[i]))
\
BATsetcount(mt->bat[i], curpos[i]+lp[i]);
\
- mt->bat[i]->ttype = TYPE_fstr; \
+ /*mt->bat[i]->ttype = TYPE_fstr;*/ \
}
\
if (err == NULL) {
\
BATiter di = bat_iterator(d); \
diff --git a/sql/backends/monet5/rel_physical.c
b/sql/backends/monet5/rel_physical.c
--- a/sql/backends/monet5/rel_physical.c
+++ b/sql/backends/monet5/rel_physical.c
@@ -1448,7 +1448,7 @@ rel_push_down_topn(visitor *v, sql_rel *
assert(obe->type == e_column);
sql_exp *ne = exps_bind_nid(oexps, obe->nid);
- if (ne && ne->type == e_func)
+ if (ne && (ne->type == e_func || ne->type ==
e_cmp || ne->type == e_convert))
return rel;
}
orderby->exps = pexps;
diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c
--- a/sql/server/rel_unnest.c
+++ b/sql/server/rel_unnest.c
@@ -3619,8 +3619,11 @@ rewrite_column(visitor *v, sql_exp *e, s
{
sql_exp *ne = repr_find(v, info->repr, e);
if (ne && ne != e && ne->alias.label > 0) {
- if (e->freevar && e->alias.label == e->nid)
+ if (e->freevar && e->alias.label == e->nid) {
e->alias = ne->alias;
+ e->l = ne->l;
+ e->r = ne->r;
+ }
e->nid = ne->alias.label;
e->freevar = 0;
}
diff --git a/sql/test/copy/Tests/parse-besteffort.py
b/sql/test/copy/Tests/parse-besteffort.py
--- a/sql/test/copy/Tests/parse-besteffort.py
+++ b/sql/test/copy/Tests/parse-besteffort.py
@@ -3,7 +3,8 @@
import decimal
from decimal import Decimal
import sys
-
+import os
+sys.path.append(os.getenv('TSTSRCDIR'))
from parsetest_support import setup_suite, TestCase
dec = Decimal
diff --git a/sql/test/copy/Tests/parse-decimal.py
b/sql/test/copy/Tests/parse-decimal.py
--- a/sql/test/copy/Tests/parse-decimal.py
+++ b/sql/test/copy/Tests/parse-decimal.py
@@ -3,7 +3,8 @@
import decimal
from decimal import Decimal
import sys
-
+import os
+sys.path.append(os.getenv('TSTSRCDIR'))
from parsetest_support import setup_suite, TestCase
suite = setup_suite()
@@ -102,7 +103,7 @@ run_test(testcase.replace(3, '41|43x').e
# Decimal overflow
-max_digits = 38 if suite.have_hge else 19
+max_digits = 38 if suite.have_hge else 18
decprec = decimal.getcontext().prec
decimal.getcontext().prec = max_digits + 2
for d in range(1, max_digits + 1):
diff --git a/sql/test/copy/Tests/parse-integer.py
b/sql/test/copy/Tests/parse-integer.py
--- a/sql/test/copy/Tests/parse-integer.py
+++ b/sql/test/copy/Tests/parse-integer.py
@@ -3,7 +3,8 @@
import decimal
from decimal import Decimal
import sys
-
+import os
+sys.path.append(os.getenv('TSTSRCDIR'))
from parsetest_support import setup_suite, TestCase
suite = setup_suite()
diff --git a/sql/test/copy/Tests/parse-misc.py
b/sql/test/copy/Tests/parse-misc.py
--- a/sql/test/copy/Tests/parse-misc.py
+++ b/sql/test/copy/Tests/parse-misc.py
@@ -3,7 +3,8 @@
import decimal
from decimal import Decimal
import sys
-
+import os
+sys.path.append(os.getenv('TSTSRCDIR'))
from parsetest_support import setup_suite, TestCase
suite = setup_suite()
diff --git a/sql/test/copy/Tests/parsetest_support.py
b/sql/test/copy/Tests/parsetest_support.py
--- a/sql/test/copy/Tests/parsetest_support.py
+++ b/sql/test/copy/Tests/parsetest_support.py
@@ -275,7 +275,7 @@ class TestSuite:
cursor = conn.cursor()
try:
cursor.execute('SELECT CAST(1 AS HUGEINT)')
- except pymonetdb.OperationError:
+ except pymonetdb.OperationalError:
self.have_hge = False
self.conn.rollback()
finally:
diff --git a/sql/test/emptydb/Tests/check.stable.out
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -1839,9 +1839,6 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "btrim", "SYSTEM", "trim2",
"str", "Internal C", "Scalar function", false, false, false, false,
NULL, "res_0", "varchar", 0, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "varchar", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "cbrt", "SYSTEM", "cbrt", "mmath",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "cbrt", "SYSTEM", "cbrt", "mmath",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "real", 24, 0, "out", "arg_1", "real", 24,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys.functions", "sys", "cde", "SYSTEM", "create aggregate cde(c
bigint) returns integer external name aggr.cde;", "aggr", "MAL",
"Aggregate function", false, false, false, true, NULL, "result",
"int", 31, 0, "out", "c", "bigint", 63, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys.functions", "sys", "cde", "SYSTEM", "create aggregate cde(c
integer) returns integer external name aggr.cde;", "aggr", "MAL",
"Aggregate function", false, false, false, true, NULL, "result",
"int", 31, 0, "out", "c", "int", 31, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "cde", "SYSTEM", "create aggregate cde(c
varchar) returns integer external name aggr.cde;", "aggr", "MAL",
"Aggregate function", false, false, false, true, NULL, "result",
"int", 31, 0, "out", "c", "varchar", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "ceil", "SYSTEM", "ceil", "mmath",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "ceil", "SYSTEM", "ceil", "mmath",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "real", 24, 0, "out", "arg_1", "real", 24,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "ceiling", "SYSTEM", "ceil",
"mmath", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "double", 53, 0, "out",
"arg_1", "double", 53, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -2845,6 +2842,9 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "truncate", "SYSTEM", "stringleft",
"str", "Internal C", "Scalar function", false, false, false, false,
NULL, "res_0", "varchar", 0, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "int", 31, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "ucase", "SYSTEM", "toUpper",
"str", "Internal C", "Scalar function", false, false, false, false,
NULL, "res_0", "varchar", 0, 0, "out", "arg_1",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "unclosed_result_sets", "SYSTEM", "create
function sys.unclosed_result_sets() returns table(\"query_id\" oid, \"res_id\"
int) external name sql.unclosed_result_sets;", "sql", "MAL", "Function
returning a table", false, false, false, true, NULL, "query_id",
"oid", 63, 0, "out", "res_id", "int", 31, 0, "out",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
+[ "sys.functions", "sys", "uniques_guess", "SYSTEM", "create
aggregate uniques_guess(c bigint) returns bigint external name
aggr.uniques_guess;", "aggr", "MAL", "Aggregate function", false, false,
false, true, NULL, "result", "bigint", 63, 0, "out",
"c", "bigint", 63, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "uniques_guess", "SYSTEM", "create
aggregate uniques_guess(c integer) returns bigint external name
aggr.uniques_guess;", "aggr", "MAL", "Aggregate function", false, false,
false, true, NULL, "result", "bigint", 63, 0, "out",
"c", "int", 31, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "uniques_guess", "SYSTEM", "create
aggregate uniques_guess(c varchar) returns bigint external name
aggr.uniques_guess;", "aggr", "MAL", "Aggregate function", false, false,
false, true, NULL, "result", "bigint", 63, 0, "out",
"c", "varchar", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "upper", "SYSTEM", "toUpper",
"str", "Internal C", "Scalar function", false, false, false, false,
NULL, "res_0", "varchar", 0, 0, "out", "arg_1",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "url_extract_host", "SYSTEM", "create
function sys.url_extract_host(url string, no_www bool) returns string external
name url.\"extractURLHost\";", "url", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "varchar", 0, 0,
"out", "url", "varchar", 0, 0, "in", "no_www",
"boolean", 1, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "user_statistics", "SYSTEM", "create
function sys.user_statistics() returns table(username string, querycount
bigint, totalticks bigint, started timestamp, finished timestamp, maxticks
bigint, maxquery string) external name sysmon.user_statistics;", "sysmon",
"MAL", "Function returning a table", false, false, false, true,
NULL, "username", "varchar", 0, 0, "out", "querycount",
"bigint", 63, 0, "out", "totalticks", "bigint", 63,
0, "out", "started", "timestamp", 7, 0, "out",
"finished", "timestamp", 7, 0, "out", "maxticks",
"bigint", 63, 0, "out", "maxquery", "varchar", 0,
0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -4752,9 +4752,6 @@ select 'null in fkeys.delete_action', de
[ "grant on function", "sys", "bit_xor", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "bit_xor", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "broadcast", "public", "EXECUTE",
"monetdb", 0 ]
-[ "grant on function", "sys", "cde", "public", "EXECUTE",
"monetdb", 0 ]
-[ "grant on function", "sys", "cde", "public", "EXECUTE",
"monetdb", 0 ]
-[ "grant on function", "sys", "cde", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "check_constraint", "public",
"EXECUTE", "monetdb", 0 ]
[ "grant on function", "sys", "contains", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "contains", "public", "EXECUTE",
"monetdb", 0 ]
@@ -5138,6 +5135,9 @@ select 'null in fkeys.delete_action', de
[ "grant on function", "sys", "to_hex", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "tracelog", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "unclosed_result_sets", "public",
"EXECUTE", "monetdb", 0 ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
