Changeset: 8e983ad5d13d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/8e983ad5d13d
Modified Files:
clients/Tests/MAL-signatures-hge.test
sql/backends/monet5/sql.c
Branch: default
Log Message:
some more optional bats, ie reducing number of mel function definitions
diffs (234 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
@@ -34230,142 +34230,72 @@ SQLvar_pop;
return the variance population of groups
batsql
window_bound
-pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bat[:bte]):bat[:oid]
-SQLwindow_bound;
-computes window ranges for each row
-batsql
-window_bound
-pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bat[:dbl]):bat[:oid]
+pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bat?[:bte]):bat[:oid]
SQLwindow_bound;
computes window ranges for each row
batsql
window_bound
-pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bat[:flt]):bat[:oid]
-SQLwindow_bound;
-computes window ranges for each row
-batsql
-window_bound
-pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bat[:hge]):bat[:oid]
-SQLwindow_bound;
-computes window ranges for each row
-batsql
-window_bound
-pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bat[:int]):bat[:oid]
-SQLwindow_bound;
-computes window ranges for each row
-batsql
-window_bound
-pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bat[:lng]):bat[:oid]
+pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bat?[:dbl]):bat[:oid]
SQLwindow_bound;
computes window ranges for each row
batsql
window_bound
-pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bat[:sht]):bat[:oid]
-SQLwindow_bound;
-computes window ranges for each row
-batsql
-window_bound
-pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bte):bat[:oid]
-SQLwindow_bound;
-computes window ranges for each row
-batsql
-window_bound
-pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:dbl):bat[:oid]
+pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bat?[:flt]):bat[:oid]
SQLwindow_bound;
computes window ranges for each row
batsql
window_bound
-pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:flt):bat[:oid]
+pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bat?[:hge]):bat[:oid]
SQLwindow_bound;
computes window ranges for each row
batsql
window_bound
-pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:hge):bat[:oid]
+pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bat?[:int]):bat[:oid]
SQLwindow_bound;
computes window ranges for each row
batsql
window_bound
-pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:int):bat[:oid]
-SQLwindow_bound;
-computes window ranges for each row
-batsql
-window_bound
-pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:lng):bat[:oid]
+pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bat?[:lng]):bat[:oid]
SQLwindow_bound;
computes window ranges for each row
batsql
window_bound
-pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:sht):bat[:oid]
-SQLwindow_bound;
-computes window ranges for each row
-batsql
-window_bound
-pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bat[:bte]):bat[:oid]
-SQLwindow_bound;
-computes window ranges for each row
-batsql
-window_bound
-pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bat[:dbl]):bat[:oid]
+pattern batsql.window_bound(X_0:bat[:any_1], X_1:int, X_2:int, X_3:int,
X_4:bat?[:sht]):bat[:oid]
SQLwindow_bound;
computes window ranges for each row
batsql
window_bound
-pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bat[:flt]):bat[:oid]
+pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bat?[:bte]):bat[:oid]
SQLwindow_bound;
computes window ranges for each row
batsql
window_bound
-pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bat[:hge]):bat[:oid]
-SQLwindow_bound;
-computes window ranges for each row
-batsql
-window_bound
-pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bat[:int]):bat[:oid]
-SQLwindow_bound;
-computes window ranges for each row
-batsql
-window_bound
-pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bat[:lng]):bat[:oid]
+pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bat?[:dbl]):bat[:oid]
SQLwindow_bound;
computes window ranges for each row
batsql
window_bound
-pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bat[:sht]):bat[:oid]
+pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bat?[:flt]):bat[:oid]
SQLwindow_bound;
computes window ranges for each row
batsql
window_bound
-pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bte):bat[:oid]
-SQLwindow_bound;
-computes window ranges for each row
-batsql
-window_bound
-pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:dbl):bat[:oid]
+pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bat?[:hge]):bat[:oid]
SQLwindow_bound;
computes window ranges for each row
batsql
window_bound
-pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:flt):bat[:oid]
-SQLwindow_bound;
-computes window ranges for each row
-batsql
-window_bound
-pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:hge):bat[:oid]
+pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bat?[:int]):bat[:oid]
SQLwindow_bound;
computes window ranges for each row
batsql
window_bound
-pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:int):bat[:oid]
+pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bat?[:lng]):bat[:oid]
SQLwindow_bound;
computes window ranges for each row
batsql
window_bound
-pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:lng):bat[:oid]
-SQLwindow_bound;
-computes window ranges for each row
-batsql
-window_bound
-pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:sht):bat[:oid]
+pattern batsql.window_bound(X_0:bat[:bit], X_1:bat[:any_1], X_2:int, X_3:int,
X_4:int, X_5:bat?[:sht]):bat[:oid]
SQLwindow_bound;
computes window ranges for each row
batstr
diff --git a/sql/backends/monet5/sql.c b/sql/backends/monet5/sql.c
--- a/sql/backends/monet5/sql.c
+++ b/sql/backends/monet5/sql.c
@@ -5713,41 +5713,29 @@ pattern("sql", "decypher", SQLdecypher,
pattern("batsql", "diff", SQLdiff, false, "return true if cur != prev row",
args(1,3, batarg("",bit),batarg("p",bit),argany("b",1))),
pattern("batsql", "diff", SQLdiff, false, "return true if cur != prev row",
args(1,3, batarg("",bit),batarg("p",bit),batargany("b",1))),
pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
arg("",oid),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",bte))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",bte))),
+ pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),optbatarg("limit",bte))),
pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
arg("",oid),arg("p",bit),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",bte))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",bte))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),batarg("limit",bte))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),batarg("limit",bte))),
+ pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),optbatarg("limit",bte))),
pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
arg("",oid),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",sht))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",sht))),
+ pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),optbatarg("limit",sht))),
pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
arg("",oid),arg("p",bit),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",sht))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",sht))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),batarg("limit",sht))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),batarg("limit",sht))),
+ pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),optbatarg("limit",sht))),
pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
arg("",oid),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",int))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",int))),
+ pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),optbatarg("limit",int))),
pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
arg("",oid),arg("p",bit),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",int))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",int))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),batarg("limit",int))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),batarg("limit",int))),
+ pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),optbatarg("limit",int))),
pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
arg("",oid),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",lng))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",lng))),
+ pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),optbatarg("limit",lng))),
pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
arg("",oid),arg("p",bit),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",lng))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",lng))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),batarg("limit",lng))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),batarg("limit",lng))),
+ pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),optbatarg("limit",lng))),
pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
arg("",oid),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",flt))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",flt))),
+ pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),optbatarg("limit",flt))),
pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
arg("",oid),arg("p",bit),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",flt))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",flt))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),batarg("limit",flt))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),batarg("limit",flt))),
+ pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),optbatarg("limit",flt))),
pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
arg("",oid),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",dbl))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",dbl))),
+ pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),optbatarg("limit",dbl))),
pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
arg("",oid),arg("p",bit),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",dbl))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",dbl))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),batarg("limit",dbl))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),batarg("limit",dbl))),
+ pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),optbatarg("limit",dbl))),
pattern("sql", "row_number", SQLrow_number, false, "return the row_numer-ed
groups", args(1,4, arg("",int),argany("b",1),arg("p",bit),arg("o",bit))),
pattern("batsql", "row_number", SQLrow_number, false, "return the
row_numer-ed groups", args(1,4,
batarg("",int),batargany("b",1),optbatarg("p",bit),optbatarg("o",bit))),
pattern("sql", "rank", SQLrank, false, "return the ranked groups", args(1,4,
arg("",int),argany("b",1),arg("p",bit),arg("o",bit))),
@@ -6127,12 +6115,10 @@ pattern("sql", "decypher", SQLdecypher,
command("batcalc", "dbl", bathge_dec2_dbl, false, "cast decimal(hge) to dbl
and check for overflow", args(1,4,
batarg("",dbl),arg("s1",int),batarg("v",hge),batarg("s",oid))),
command("batcalc", "dbl", bathge_dec2dec_dbl, false, "cast decimal(hge) to
decimal(dbl) and check for overflow", args(1,6,
batarg("",dbl),arg("s1",int),batarg("v",hge),batarg("s",oid),arg("d2",int),arg("s2",int))),
/* sql_rank_hge */
- pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
arg("",oid),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("start",hge))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("start",hge))),
- pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
arg("",oid),arg("p",bit),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("start",hge))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("start",hge))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),batarg("start",hge))),
- pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),batarg("start",hge))),
+ pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
arg("",oid),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",hge))),
+ pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,6,
batarg("",oid),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),optbatarg("limit",hge))),
+ pattern("sql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
arg("",oid),arg("p",bit),argany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),arg("limit",hge))),
+ pattern("batsql", "window_bound", SQLwindow_bound, false, "computes window
ranges for each row", args(1,7,
batarg("",oid),batarg("p",bit),batargany("b",1),arg("unit",int),arg("bound",int),arg("excl",int),optbatarg("limit",hge))),
pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,7,
arg("",hge),arg("b",bte),arg("p",bit),arg("o",bit),arg("t",int),arg("s",oid),arg("e",oid))),
pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,7,
batarg("",hge),batarg("b",bte),optbatarg("p",bit),optbatarg("o",bit),arg("t",int),optbatarg("s",oid),optbatarg("e",oid))),
pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,7,
arg("",hge),arg("b",sht),arg("p",bit),arg("o",bit),arg("t",int),arg("s",oid),arg("e",oid))),
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
