Changeset: 3e50fb75fe60 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/3e50fb75fe60
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/storage/bat/bat_logger.c
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.int128
Branch: ordered-set-aggregates
Log Message:
Fix upgrade code; approve emptydb/check output.
diffs (truncated from 598 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
@@ -78,18 +78,19 @@ sql_fix_system_tables(Client c, mvc *sql
continue;
pos += snprintf(buf + pos, bufsize - pos,
- "insert into sys.functions values"
- " (%d, '%s', '%s', '%s',"
- " %d, %d, %s, %s, %s, %d, %s, %s);\n",
- func->base.id, func->base.name,
- sql_func_imp(func), sql_func_mod(func), (int)
FUNC_LANG_INT,
- (int) func->type,
- boolnames[func->side_effect],
- boolnames[func->varres],
- boolnames[func->vararg],
- func->s ? func->s->base.id : s->base.id,
- boolnames[func->system],
- boolnames[func->semantics]);
+ "insert into sys.functions
values"
+ " (%d, '%s', '%s', '%s',"
+ " %d, %d, %s, %s, %s, %d, %s,
%s, %d);\n",
+ func->base.id, func->base.name,
+ sql_func_imp(func),
sql_func_mod(func), (int) FUNC_LANG_INT,
+ (int) func->type,
+ boolnames[func->side_effect],
+ boolnames[func->varres],
+ boolnames[func->vararg],
+ func->s ? func->s->base.id :
s->base.id,
+ boolnames[func->system],
+ boolnames[func->semantics],
+ func->order_required ? 2 :
func->opt_order ? 1 : 0);
if (func->res) {
for (m = func->res->h; m; m = m->next, number++) {
arg = m->data;
diff --git a/sql/storage/bat/bat_logger.c b/sql/storage/bat/bat_logger.c
--- a/sql/storage/bat/bat_logger.c
+++ b/sql/storage/bat/bat_logger.c
@@ -693,59 +693,59 @@ bl_postversion(void *Store, logger *lg)
#ifdef CATALOG_SEP2022
if (store->catalog_version <= CATALOG_SEP2022) {
- /* new STRING column sys.keys.check */
- BAT *b = log_temp_descriptor(log_find_bat(lg, 2088));
/* sys.keys.id */
- if (b == NULL)
- return GDK_FAIL;
- BAT *check = BATconstant(b->hseqbase, TYPE_str,
ATOMnilptr(TYPE_str), BATcount(b), PERSISTENT);
- bat_destroy(b);
- if (check == NULL)
- return GDK_FAIL;
- if ((check = BATsetaccess(check, BAT_READ)) == NULL ||
- /* 2165 is sys.keys.check */
- BUNappend(lg->catalog_id, &(int) {2165}, true)
!= GDK_SUCCEED ||
- BUNappend(lg->catalog_bid, &check->batCacheid,
true) != GDK_SUCCEED ||
- BUNappend(lg->catalog_lid, &lng_nil, false) !=
GDK_SUCCEED ||
- BUNappend(lg->catalog_cnt,
&(lng){BATcount(check)}, false) != GDK_SUCCEED
- ) {
- bat_destroy(check);
- return GDK_FAIL;
- }
- BBPretain(check->batCacheid);
+ /* new STRING column sys.keys.check */
+ BAT *b = log_temp_descriptor(log_find_bat(lg, 2088)); /*
sys.keys.id */
+ if (b == NULL)
+ return GDK_FAIL;
+ BAT *check = BATconstant(b->hseqbase, TYPE_str,
ATOMnilptr(TYPE_str), BATcount(b), PERSISTENT);
+ bat_destroy(b);
+ if (check == NULL)
+ return GDK_FAIL;
+ if ((check = BATsetaccess(check, BAT_READ)) == NULL ||
+ /* 2165 is sys.keys.check */
+ BUNappend(lg->catalog_id, &(int) {2165}, true) !=
GDK_SUCCEED ||
+ BUNappend(lg->catalog_bid, &check->batCacheid, true) !=
GDK_SUCCEED ||
+ BUNappend(lg->catalog_lid, &lng_nil, false) !=
GDK_SUCCEED ||
+ BUNappend(lg->catalog_cnt, &(lng){BATcount(check)},
false) != GDK_SUCCEED
+ ) {
bat_destroy(check);
+ return GDK_FAIL;
+ }
+ BBPretain(check->batCacheid);
+ bat_destroy(check);
- if (tabins(lg,
- 2076, &(msk) {false}, /*
sys._columns */
- /* 2165 is sys.keys.check */
- 2077, &(int) {2165}, /*
sys._columns.id */
- 2078, "check",
/* sys._columns.name */
- 2079, "varchar",
/* sys._columns.type */
- 2080, &(int) {2048}, /*
sys._columns.type_digits */
- 2081, &(int) {0}, /*
sys._columns.type_scale */
- /* 2087 is sys.keys */
- 2082, &(int) {2087}, /*
sys._columns.table_id */
- 2083, str_nil,
/* sys._columns.default */
- 2084, &(bit) {TRUE}, /*
sys._columns.null */
- 2085, &(int) {6}, /*
sys._columns.number */
- 2086, str_nil,
/* sys._columns.storage */
- 0) != GDK_SUCCEED)
- return GDK_FAIL;
- if (tabins(lg,
- 2076, &(msk) {false}, /*
sys._columns */
- /* 2166 is tmp.keys.check */
- 2077, &(int) {2166}, /*
sys._columns.id */
- 2078, "check",
/* sys._columns.name */
- 2079, "varchar",
/* sys._columns.type */
- 2080, &(int) {2048}, /*
sys._columns.type_digits */
- 2081, &(int) {0}, /*
sys._columns.type_scale */
- /* 2135 is tmp.keys */
- 2082, &(int) {2135}, /*
sys._columns.table_id */
- 2083, str_nil,
/* sys._columns.default */
- 2084, &(bit) {TRUE}, /*
sys._columns.null */
- 2085, &(int) {6}, /*
sys._columns.number */
- 2086, str_nil,
/* sys._columns.storage */
- 0) != GDK_SUCCEED)
- return GDK_FAIL;
+ if (tabins(lg,
+ 2076, &(msk) {false}, /* sys._columns
*/
+ /* 2165 is sys.keys.check */
+ 2077, &(int) {2165}, /*
sys._columns.id */
+ 2078, "check", /*
sys._columns.name */
+ 2079, "varchar", /*
sys._columns.type */
+ 2080, &(int) {2048}, /*
sys._columns.type_digits */
+ 2081, &(int) {0}, /*
sys._columns.type_scale */
+ /* 2087 is sys.keys */
+ 2082, &(int) {2087}, /*
sys._columns.table_id */
+ 2083, str_nil, /*
sys._columns.default */
+ 2084, &(bit) {TRUE}, /*
sys._columns.null */
+ 2085, &(int) {6}, /*
sys._columns.number */
+ 2086, str_nil, /*
sys._columns.storage */
+ 0) != GDK_SUCCEED)
+ return GDK_FAIL;
+ if (tabins(lg,
+ 2076, &(msk) {false}, /* sys._columns
*/
+ /* 2166 is tmp.keys.check */
+ 2077, &(int) {2166}, /*
sys._columns.id */
+ 2078, "check", /*
sys._columns.name */
+ 2079, "varchar", /*
sys._columns.type */
+ 2080, &(int) {2048}, /*
sys._columns.type_digits */
+ 2081, &(int) {0}, /*
sys._columns.type_scale */
+ /* 2135 is tmp.keys */
+ 2082, &(int) {2135}, /*
sys._columns.table_id */
+ 2083, str_nil, /*
sys._columns.default */
+ 2084, &(bit) {TRUE}, /*
sys._columns.null */
+ 2085, &(int) {6}, /*
sys._columns.number */
+ 2086, str_nil, /*
sys._columns.storage */
+ 0) != GDK_SUCCEED)
+ return GDK_FAIL;
}
#endif
@@ -881,63 +881,63 @@ bl_postversion(void *Store, logger *lg)
bat_destroy(funcs);
}
if (store->catalog_version <= CATALOG_AUG2024) {
- /* new TINYINT column sys.functions.order_specification
*/
- BAT *ftype = log_temp_descriptor(log_find_bat(lg,
2022)); /* sys.functions.type (int) */
- BAT *fname = log_temp_descriptor(log_find_bat(lg,
2018)); /* sys.functions.name (str) */
- if (ftype == NULL || fname == NULL)
- return GDK_FAIL;
- bte zero = 0;
- BAT *order_spec = BATconstant(ftype->hseqbase,
TYPE_bte, &zero, BATcount(ftype), PERSISTENT);
- /* update functions set order_specification=1 where
type == aggr and name in ('group_concat', 'listagg', 'xmlagg')
- * update functions set order_specification=2 where
type == aggr and name = 'quantile' */
- if (order_spec == NULL) {
- bat_destroy(ftype);
- bat_destroy(fname);
- return GDK_FAIL;
- }
- bte *os = (bte*)Tloc(order_spec, 0);
- int *ft = (int*)Tloc(ftype, 0);
- BATiter fni = bat_iterator_nolock(fname);
- for(BUN b = 0; b < BATcount(ftype); b++) {
- if (ft[b] == F_AGGR) {
- const char *f = BUNtvar(fni, b);
- if (strcmp(f, "group_concat") == 0 ||
strcmp(f, "listagg") == 0 || strcmp(f, "xmlagg") == 0)
- os[b] = 1;
- else if (strcmp(f, "quantile") == 0 ||
strcmp(f, "quantile_avg") == 0)
- os[b] = 2;
- }
- }
+ /* new TINYINT column sys.functions.order_specification */
+ BAT *ftype = log_temp_descriptor(log_find_bat(lg, 2022)); /*
sys.functions.type (int) */
+ BAT *fname = log_temp_descriptor(log_find_bat(lg, 2018)); /*
sys.functions.name (str) */
+ if (ftype == NULL || fname == NULL)
+ return GDK_FAIL;
+ bte zero = 0;
+ BAT *order_spec = BATconstant(ftype->hseqbase, TYPE_bte, &zero,
BATcount(ftype), PERSISTENT);
+ /* update functions set order_specification=1 where type ==
aggr and name in ('group_concat', 'listagg', 'xmlagg')
+ * update functions set order_specification=2 where type ==
aggr and name = 'quantile' */
+ if (order_spec == NULL) {
bat_destroy(ftype);
bat_destroy(fname);
- if ((order_spec = BATsetaccess(order_spec, BAT_READ))
== NULL ||
- /* 2167 is sys.functions.order_specification */
- BUNappend(lg->catalog_id, &(int) {2167}, true)
!= GDK_SUCCEED ||
- BUNappend(lg->catalog_bid,
&order_spec->batCacheid, true) != GDK_SUCCEED ||
- BUNappend(lg->catalog_lid, &lng_nil, false) !=
GDK_SUCCEED ||
- BUNappend(lg->catalog_cnt,
&(lng){BATcount(order_spec)}, false) != GDK_SUCCEED
- ) {
- bat_destroy(order_spec);
- return GDK_FAIL;
+ return GDK_FAIL;
+ }
+ bte *os = (bte*)Tloc(order_spec, 0);
+ int *ft = (int*)Tloc(ftype, 0);
+ BATiter fni = bat_iterator_nolock(fname);
+ for(BUN b = 0; b < BATcount(ftype); b++) {
+ if (ft[b] == F_AGGR) {
+ const char *f = BUNtvar(fni, b);
+ if (strcmp(f, "group_concat") == 0 || strcmp(f,
"listagg") == 0 || strcmp(f, "xmlagg") == 0)
+ os[b] = 1;
+ else if (strcmp(f, "quantile") == 0 ||
strcmp(f, "quantile_avg") == 0)
+ os[b] = 2;
}
- BBPretain(order_spec->batCacheid);
+ }
+ bat_destroy(ftype);
+ bat_destroy(fname);
+ if ((order_spec = BATsetaccess(order_spec, BAT_READ)) == NULL ||
+ /* 2167 is sys.functions.order_specification */
+ BUNappend(lg->catalog_id, &(int) {2167}, true) !=
GDK_SUCCEED ||
+ BUNappend(lg->catalog_bid, &order_spec->batCacheid,
true) != GDK_SUCCEED ||
+ BUNappend(lg->catalog_lid, &lng_nil, false) !=
GDK_SUCCEED ||
+ BUNappend(lg->catalog_cnt,
&(lng){BATcount(order_spec)}, false) != GDK_SUCCEED
+ ) {
bat_destroy(order_spec);
+ return GDK_FAIL;
+ }
+ BBPretain(order_spec->batCacheid);
+ bat_destroy(order_spec);
- if (tabins(lg,
- 2076, &(msk) {false}, /*
sys._columns */
- /* 2167 is
sys.functions.order_specification */
- 2077, &(int) {2167}, /*
sys._columns.id */
- 2078, "order_specification",
/* sys._columns.name */
- 2079, "tinyint",
/* sys._columns.type */
- 2080, &(int) {7}, /*
sys._columns.type_digits */
- 2081, &(int) {0}, /*
sys._columns.type_scale */
- /* 2016 is sys.functions */
- 2082, &(int) {2016}, /*
sys._columns.table_id */
- 2083, str_nil,
/* sys._columns.default */
- 2084, &(bit) {TRUE}, /*
sys._columns.null */
- 2085, &(int) {12}, /*
sys._columns.number */
- 2086, str_nil,
/* sys._columns.storage */
- 0) != GDK_SUCCEED)
- return GDK_FAIL;
+ if (tabins(lg,
+ 2076, &(msk) {false}, /* sys._columns
*/
+ /* 2167 is sys.functions.order_specification
*/
+ 2077, &(int) {2167}, /*
sys._columns.id */
+ 2078, "order_specification",
/* sys._columns.name */
+ 2079, "tinyint", /*
sys._columns.type */
+ 2080, &(int) {7}, /*
sys._columns.type_digits */
+ 2081, &(int) {0}, /*
sys._columns.type_scale */
+ /* 2016 is sys.functions */
+ 2082, &(int) {2016}, /*
sys._columns.table_id */
+ 2083, str_nil, /*
sys._columns.default */
+ 2084, &(bit) {TRUE}, /*
sys._columns.null */
+ 2085, &(int) {12}, /*
sys._columns.number */
+ 2086, str_nil, /*
sys._columns.storage */
+ 0) != GDK_SUCCEED)
+ return GDK_FAIL;
}
#endif
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
@@ -2220,32 +2220,32 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "sql",
"Internal C", "Analytic function", false, false, false, true, 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", "prod", "SYSTEM", "prod", "sql",
"Internal C", "Analytic function", false, false, false, true, 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", "qgramnormalize", "SYSTEM", "create
function sys.qgramnormalize(x string) returns string external name
txtsim.qgramnormalize;", "txtsim", "MAL", "Scalar function",
false, false, false, true, NULL, "result", "varchar", 0,
0, "out", "x", "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", "quantile", "SYSTEM", "create
aggregate quantile(val bigint, q double) returns bigint external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "bigint", 63, 0,
"out", "val", "bigint", 63, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val date, q double) returns date external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "date", 0, 0, "out",
"val", "date", 0, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val decimal(18), q double) returns decimal(18) external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "decimal", 18, 0,
"out", "val", "decimal", 18, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val decimal(2), q double) returns decimal(2) external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "decimal", 2, 0,
"out", "val", "decimal", 2, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val decimal(4), q double) returns decimal(4) external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "decimal", 4, 0,
"out", "val", "decimal", 4, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val decimal(9), q double) returns decimal(9) external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "decimal", 9, 0,
"out", "val", "decimal", 9, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val double, q double) returns double external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "double", 53, 0,
"out", "val", "double", 53, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val integer, q double) returns integer external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "int", 31, 0, "out",
"val", "int", 31, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val interval day, q double) returns interval day external
name \"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function",
false, false, false, true, NULL, "result", "day_interval", 4,
0, "out", "val", "day_interval", 4, 0, "in", "q",
"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
]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val interval month, q double) returns interval month
external name \"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function",
false, false, false, true, NULL, "result", "month_interval",
3, 0, "out", "val", "month_interval", 3, 0, "in",
"q", "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 ]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val interval second, q double) returns interval second
external name \"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate
function", false, false, false, true, NULL, "result",
"sec_interval", 13, 0, "out", "val", "sec_interval", 13, 0,
"in", "q", "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 ]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val real, q double) returns real external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "real", 24, 0, "out",
"val", "real", 24, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val smallint, q double) returns smallint external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "smallint", 15, 0,
"out", "val", "smallint", 15, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val time, q double) returns time external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "time", 1, 0, "out",
"val", "time", 1, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val timestamp, q double) returns timestamp external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "timestamp", 7, 0,
"out", "val", "timestamp", 7, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val tinyint, q double) returns tinyint external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "tinyint", 7, 0,
"out", "val", "tinyint", 7, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile_avg", "SYSTEM", "create
aggregate quantile_avg(val bigint, q double) returns double external name
\"aggr\".\"quantile_avg\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "double", 53, 0,
"out", "val", "bigint", 63, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile_avg", "SYSTEM", "create
aggregate quantile_avg(val decimal(18), q double) returns double external name
\"aggr\".\"quantile_avg\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "double", 53, 0,
"out", "val", "decimal", 18, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile_avg", "SYSTEM", "create
aggregate quantile_avg(val decimal(2), q double) returns double external name
\"aggr\".\"quantile_avg\";", "aggr", "MAL", "Aggregate function",
false, false, false, true, NULL, "result", "double", 53,
0, "out", "val", "decimal", 2, 0, "in", "q",
"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
]
-[ "sys.functions", "sys", "quantile_avg", "SYSTEM", "create
aggregate quantile_avg(val decimal(4), q double) returns double external name
\"aggr\".\"quantile_avg\";", "aggr", "MAL", "Aggregate function",
false, false, false, true, NULL, "result", "double", 53,
0, "out", "val", "decimal", 4, 0, "in", "q",
"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
]
-[ "sys.functions", "sys", "quantile_avg", "SYSTEM", "create
aggregate quantile_avg(val decimal(9), q double) returns double external name
\"aggr\".\"quantile_avg\";", "aggr", "MAL", "Aggregate function",
false, false, false, true, NULL, "result", "double", 53,
0, "out", "val", "decimal", 9, 0, "in", "q",
"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
]
-[ "sys.functions", "sys", "quantile_avg", "SYSTEM", "create
aggregate quantile_avg(val double, q double) returns double external name
\"aggr\".\"quantile_avg\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "double", 53, 0,
"out", "val", "double", 53, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile_avg", "SYSTEM", "create
aggregate quantile_avg(val integer, q double) returns double external name
\"aggr\".\"quantile_avg\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "double", 53, 0,
"out", "val", "int", 31, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile_avg", "SYSTEM", "create
aggregate quantile_avg(val real, q double) returns double external name
\"aggr\".\"quantile_avg\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "double", 53, 0,
"out", "val", "real", 24, 0, "in", "q", "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 ]
-[ "sys.functions", "sys", "quantile_avg", "SYSTEM", "create
aggregate quantile_avg(val smallint, q double) returns double external name
\"aggr\".\"quantile_avg\";", "aggr", "MAL", "Aggregate function",
false, false, false, true, NULL, "result", "double", 53,
0, "out", "val", "smallint", 15, 0, "in", "q",
"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
]
-[ "sys.functions", "sys", "quantile_avg", "SYSTEM", "create
aggregate quantile_avg(val tinyint, q double) returns double external name
\"aggr\".\"quantile_avg\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "double", 53, 0,
"out", "val", "tinyint", 7, 0, "in", "q", "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 ]
+[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val bigint, q double) returns bigint ordered external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "bigint", 63, 0,
"out", "val", "bigint", 63, 0, "in", "q", "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 ]
+[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val date, q double) returns date ordered external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "date", 0, 0, "out",
"val", "date", 0, 0, "in", "q", "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 ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
