Changeset: 5718e15eba3c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5718e15eba3c
Modified Files:
sql/backends/monet5/sql.c
sql/backends/monet5/sql_rank.c
sql/backends/monet5/sql_rank.h
sql/server/rel_dump.c
sql/server/rel_select.c
sql/server/rel_unnest.c
sql/test/subquery/Tests/correlated.sql
sql/test/subquery/Tests/correlated.stable.out
Branch: window-tunning
Log Message:
Pass default values when some arguments are not needed. This cleans up the MAL
signatures and window function optimizers
diffs (truncated from 2854 to 300 lines):
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
@@ -6053,1088 +6053,194 @@ static mel_func sql_init_funcs[] = {
pattern("batsql", "ntile", SQLntile, false, "return the groups divided as
equally as possible", args(1,5,
batargany("",1),batargany("b",0),batargany("n",1),argany("p",2),argany("o",3))),
/* these window functions support frames */
- pattern("sql", "first_value", SQLfirst_value, false, "return the first value
of groups", args(1,4, argany("",1),argany("b",1),arg("s",lng),arg("e",lng))),
- pattern("batsql", "first_value", SQLfirst_value, false, "return the first
value of groups", args(1,4,
batargany("",1),batargany("b",1),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "last_value", SQLlast_value, false, "return the last value of
groups", args(1,4, argany("",1),argany("b",1),arg("s",lng),arg("e",lng))),
- pattern("batsql", "last_value", SQLlast_value, false, "return the last value
of groups", args(1,4,
batargany("",1),batargany("b",1),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "nth_value", SQLnth_value, false, "return the nth value of
each group", args(1,5,
argany("",0),argany("b",0),argany("n",1),arg("s",lng),arg("e",lng))),
- pattern("batsql", "nth_value", SQLnth_value, false, "return the nth value of
each group", args(1,5,
batargany("",0),batargany("b",0),argany("n",1),batarg("s",lng),batarg("e",lng))),
- pattern("batsql", "nth_value", SQLnth_value, false, "return the nth value of
each group", args(1,5,
batargany("",0),argany("b",0),batargany("n",1),arg("s",lng),arg("e",lng))),
- pattern("batsql", "nth_value", SQLnth_value, false, "return the nth value of
each group", args(1,5,
batargany("",0),batargany("b",0),batargany("n",1),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "min", SQLmin_global, false, "return the minimum of groups",
args(1,3, argany("",1),argany("b",1),arg("t",int))),
- pattern("batsql", "min", SQLmin_global, false, "return the minimum of
groups", args(1,3, batargany("",1),batargany("b",1),arg("t",int))),
- pattern("sql", "min", SQLmin_global, false, "return the minimum of groups",
args(1,4, argany("",1),argany("b",1),arg("t",int),arg("p",bit))),
- pattern("batsql", "min", SQLmin_global, false, "return the minimum of
groups", args(1,4,
batargany("",1),batargany("b",1),arg("t",int),batarg("p",bit))),
- pattern("sql", "min", SQLmin_global, false, "return the minimum of groups",
args(1,4, argany("",1),argany("b",1),arg("t",int),arg("o",bit))),
- pattern("batsql", "min", SQLmin_global, false, "return the minimum of
groups", args(1,4,
batargany("",1),batargany("b",1),arg("t",int),batarg("o",bit))),
- pattern("sql", "min", SQLmin_global, false, "return the minimum of groups",
args(1,5, argany("",1),argany("b",1),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "min", SQLmin_global, false, "return the minimum of
groups", args(1,5,
batargany("",1),batargany("b",1),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "min", SQLmin, false, "return the minimum of groups",
args(1,5, argany("",1),argany("b",1),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "min", SQLmin, false, "return the minimum of groups",
args(1,5,
batargany("",1),batargany("b",1),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "min", SQLmin, false, "return the minimum of groups",
args(1,6,
argany("",1),argany("b",1),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "min", SQLmin, false, "return the minimum of groups",
args(1,6,
batargany("",1),batargany("b",1),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "max", SQLmax_global, false, "return the maximum of groups",
args(1,3, argany("",1),argany("b",1),arg("t",int))),
- pattern("batsql", "max", SQLmax_global, false, "return the maximum of
groups", args(1,3, batargany("",1),batargany("b",1),arg("t",int))),
- pattern("sql", "max", SQLmax_global, false, "return the maximum of groups",
args(1,4, argany("",1),argany("b",1),arg("t",int),arg("p",bit))),
- pattern("batsql", "max", SQLmax_global, false, "return the maximum of
groups", args(1,4,
batargany("",1),batargany("b",1),arg("t",int),batarg("p",bit))),
- pattern("sql", "max", SQLmax_global, false, "return the maximum of groups",
args(1,4, argany("",1),argany("b",1),arg("t",int),arg("o",bit))),
- pattern("batsql", "max", SQLmax_global, false, "return the maximum of
groups", args(1,4,
batargany("",1),batargany("b",1),arg("t",int),batarg("o",bit))),
- pattern("sql", "max", SQLmax_global, false, "return the maximum of groups",
args(1,5, argany("",1),argany("b",1),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "max", SQLmax_global, false, "return the maximum of
groups", args(1,5,
batargany("",1),batargany("b",1),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "max", SQLmax, false, "return the maximum of groups",
args(1,5, argany("",1),argany("b",1),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "max", SQLmax, false, "return the maximum of groups",
args(1,5,
batargany("",1),batargany("b",1),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "max", SQLmax, false, "return the maximum of groups",
args(1,6,
argany("",1),argany("b",1),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "max", SQLmax, false, "return the maximum of groups",
args(1,6,
batargany("",1),batargany("b",1),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "count", SQLcount_global, false, "return count of groups",
args(1,4, arg("",lng),argany("b",1),arg("ignils",bit),arg("t",int))),
- pattern("batsql", "count", SQLcount_global, false, "return count of groups",
args(1,4, batarg("",lng),batargany("b",1),arg("ignils",bit),arg("t",int))),
- pattern("sql", "count", SQLcount_global, false, "return count of groups",
args(1,5,
arg("",lng),argany("b",1),arg("ignils",bit),arg("t",int),arg("p",bit))),
- pattern("batsql", "count", SQLcount_global, false, "return count of groups",
args(1,5,
batarg("",lng),batargany("b",1),arg("ignils",bit),arg("t",int),batarg("p",bit))),
- pattern("sql", "count", SQLcount_global, false, "return count of groups",
args(1,5,
arg("",lng),argany("b",1),arg("ignils",bit),arg("t",int),arg("o",bit))),
- pattern("batsql", "count", SQLcount_global, false, "return count of groups",
args(1,5,
batarg("",lng),batargany("b",1),arg("ignils",bit),arg("t",int),batarg("o",bit))),
- pattern("sql", "count", SQLcount_global, false, "return count of groups",
args(1,6,
arg("",lng),argany("b",1),arg("ignils",bit),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "count", SQLcount_global, false, "return count of groups",
args(1,6,
batarg("",lng),batargany("b",1),arg("ignils",bit),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "count", SQLcount, false, "return count of groups", args(1,6,
arg("",lng),argany("b",1),arg("ignils",bit),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "count", SQLcount, false, "return count of groups",
args(1,6,
batarg("",lng),batargany("b",1),arg("ignils",bit),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "count", SQLcount, false, "return count of groups", args(1,7,
arg("",lng),argany("b",1),arg("ignils",bit),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "count", SQLcount, false, "return count of groups",
args(1,7,
batarg("",lng),batargany("b",1),arg("ignils",bit),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,3, arg("",lng),arg("b",bte),arg("t",int))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,3, batarg("",lng),batarg("b",bte),arg("t",int))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, arg("",lng),arg("b",bte),arg("t",int),arg("p",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, batarg("",lng),batarg("b",bte),arg("t",int),batarg("p",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, arg("",lng),arg("b",bte),arg("t",int),arg("o",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, batarg("",lng),batarg("b",bte),arg("t",int),batarg("o",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,5, arg("",lng),arg("b",bte),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,5,
batarg("",lng),batarg("b",bte),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,5,
arg("",lng),arg("b",bte),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,5,
batarg("",lng),batarg("b",bte),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,6,
arg("",lng),arg("b",bte),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,6,
batarg("",lng),batarg("b",bte),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,3, arg("",lng),arg("b",bte),arg("t",int))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,3, batarg("",lng),batarg("b",bte),arg("t",int))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,4, arg("",lng),arg("b",bte),arg("t",int),arg("p",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,4,
batarg("",lng),batarg("b",bte),arg("t",int),batarg("p",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,4, arg("",lng),arg("b",bte),arg("t",int),arg("o",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,4,
batarg("",lng),batarg("b",bte),arg("t",int),batarg("o",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,5, arg("",lng),arg("b",bte),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,5,
batarg("",lng),batarg("b",bte),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "prod", SQLprod, false, "return the product of groups",
args(1,5, arg("",lng),arg("b",bte),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "prod", SQLprod, false, "return the product of groups",
args(1,5,
batarg("",lng),batarg("b",bte),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "prod", SQLprod, false, "return the product of groups",
args(1,6,
arg("",lng),arg("b",bte),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "prod", SQLprod, false, "return the product of groups",
args(1,6,
batarg("",lng),batarg("b",bte),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,3, arg("",lng),arg("b",sht),arg("t",int))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,3, batarg("",lng),batarg("b",sht),arg("t",int))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, arg("",lng),arg("b",sht),arg("t",int),arg("p",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, batarg("",lng),batarg("b",sht),arg("t",int),batarg("p",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, arg("",lng),arg("b",sht),arg("t",int),arg("o",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, batarg("",lng),batarg("b",sht),arg("t",int),batarg("o",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,5, arg("",lng),arg("b",sht),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,5,
batarg("",lng),batarg("b",sht),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,5,
arg("",lng),arg("b",sht),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,5,
batarg("",lng),batarg("b",sht),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,6,
arg("",lng),arg("b",sht),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,6,
batarg("",lng),batarg("b",sht),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,3, arg("",lng),arg("b",sht),arg("t",int))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,3, batarg("",lng),batarg("b",sht),arg("t",int))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,4, arg("",lng),arg("b",sht),arg("t",int),arg("p",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,4,
batarg("",lng),batarg("b",sht),arg("t",int),batarg("p",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,4, arg("",lng),arg("b",sht),arg("t",int),arg("o",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,4,
batarg("",lng),batarg("b",sht),arg("t",int),batarg("o",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,5, arg("",lng),arg("b",sht),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,5,
batarg("",lng),batarg("b",sht),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "prod", SQLprod, false, "return the product of groups",
args(1,5, arg("",lng),arg("b",sht),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "prod", SQLprod, false, "return the product of groups",
args(1,5,
batarg("",lng),batarg("b",sht),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "prod", SQLprod, false, "return the product of groups",
args(1,6,
arg("",lng),arg("b",sht),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "prod", SQLprod, false, "return the product of groups",
args(1,6,
batarg("",lng),batarg("b",sht),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,3, arg("",lng),arg("b",int),arg("t",int))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,3, batarg("",lng),batarg("b",int),arg("t",int))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, arg("",lng),arg("b",int),arg("t",int),arg("p",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, batarg("",lng),batarg("b",int),arg("t",int),batarg("p",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, arg("",lng),arg("b",int),arg("t",int),batarg("o",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, batarg("",lng),batarg("b",int),arg("t",int),batarg("o",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,5, arg("",lng),arg("b",int),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,5,
batarg("",lng),batarg("b",int),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,5,
arg("",lng),arg("b",int),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,5,
batarg("",lng),batarg("b",int),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,6,
arg("",lng),arg("b",int),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,6,
batarg("",lng),batarg("b",int),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,3, arg("",lng),arg("b",int),arg("t",int))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,3, batarg("",lng),batarg("b",int),arg("t",int))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,4, arg("",lng),arg("b",int),arg("t",int),arg("p",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,4,
batarg("",lng),batarg("b",int),arg("t",int),batarg("p",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,4, arg("",lng),arg("b",int),arg("t",int),arg("o",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,4,
batarg("",lng),batarg("b",int),arg("t",int),batarg("o",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,5, arg("",lng),arg("b",int),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,5,
batarg("",lng),batarg("b",int),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "prod", SQLprod, false, "return the product of groups",
args(1,5, arg("",lng),arg("b",int),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "prod", SQLprod, false, "return the product of groups",
args(1,5,
batarg("",lng),batarg("b",int),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "prod", SQLprod, false, "return the product of groups",
args(1,6,
arg("",lng),arg("b",int),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "prod", SQLprod, false, "return the product of groups",
args(1,6,
batarg("",lng),batarg("b",int),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,3, arg("",lng),arg("b",lng),arg("t",int))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,3, batarg("",lng),batarg("b",lng),arg("t",int))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, arg("",lng),arg("b",lng),arg("t",int),arg("p",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, batarg("",lng),batarg("b",lng),arg("t",int),batarg("p",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, arg("",lng),arg("b",lng),arg("t",int),arg("o",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, batarg("",lng),batarg("b",lng),arg("t",int),batarg("o",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,5, arg("",lng),arg("b",lng),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,5,
batarg("",lng),batarg("b",lng),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,5,
arg("",lng),arg("b",lng),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,5,
batarg("",lng),batarg("b",lng),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,6,
arg("",lng),arg("b",lng),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,6,
batarg("",lng),batarg("b",lng),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,3, arg("",lng),arg("b",lng),arg("t",int))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,3, batarg("",lng),batarg("b",lng),arg("t",int))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,4, arg("",lng),arg("b",lng),arg("t",int),arg("p",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,4,
batarg("",lng),batarg("b",lng),arg("t",int),batarg("p",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,4, arg("",lng),arg("b",lng),arg("t",int),arg("o",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,4,
batarg("",lng),batarg("b",lng),arg("t",int),batarg("o",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,5, arg("",lng),arg("b",lng),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,5,
batarg("",lng),batarg("b",lng),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "prod", SQLprod, false, "return the product of groups",
args(1,5, arg("",lng),arg("b",lng),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "prod", SQLprod, false, "return the product of groups",
args(1,5,
batarg("",lng),batarg("b",lng),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "prod", SQLprod, false, "return the product of groups",
args(1,6,
arg("",lng),arg("b",lng),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "prod", SQLprod, false, "return the product of groups",
args(1,6,
batarg("",lng),batarg("b",lng),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,3, arg("",flt),arg("b",flt),arg("t",int))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,3, batarg("",flt),batarg("b",flt),arg("t",int))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, arg("",flt),arg("b",flt),arg("t",int),arg("p",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, batarg("",flt),batarg("b",flt),arg("t",int),batarg("p",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, arg("",flt),arg("b",flt),arg("t",int),arg("o",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, batarg("",flt),batarg("b",flt),arg("t",int),batarg("o",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,5, arg("",flt),arg("b",flt),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,5,
batarg("",flt),batarg("b",flt),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,5,
arg("",flt),arg("b",flt),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,5,
batarg("",flt),batarg("b",flt),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,6,
arg("",flt),arg("b",flt),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,6,
batarg("",flt),batarg("b",flt),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,3, arg("",flt),arg("b",flt),arg("t",int))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,3, batarg("",flt),batarg("b",flt),arg("t",int))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,4, arg("",flt),arg("b",flt),arg("t",int),arg("p",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,4,
batarg("",flt),batarg("b",flt),arg("t",int),batarg("p",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,4, arg("",flt),arg("b",flt),arg("t",int),arg("o",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,4,
batarg("",flt),batarg("b",flt),arg("t",int),batarg("o",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,5, arg("",flt),arg("b",flt),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,5,
batarg("",flt),batarg("b",flt),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "prod", SQLprod, false, "return the product of groups",
args(1,5, arg("",flt),arg("b",flt),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "prod", SQLprod, false, "return the product of groups",
args(1,5,
batarg("",flt),batarg("b",flt),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "prod", SQLprod, false, "return the product of groups",
args(1,6,
arg("",flt),arg("b",flt),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "prod", SQLprod, false, "return the product of groups",
args(1,6,
batarg("",flt),batarg("b",flt),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,3, arg("",dbl),arg("b",flt),arg("t",int))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,3, batarg("",dbl),batarg("b",flt),arg("t",int))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, arg("",dbl),arg("b",flt),arg("t",int),arg("p",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, batarg("",dbl),batarg("b",flt),arg("t",int),batarg("p",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, arg("",dbl),arg("b",flt),arg("t",int),arg("o",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, batarg("",dbl),batarg("b",flt),arg("t",int),batarg("o",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,5, arg("",dbl),arg("b",flt),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,5,
batarg("",dbl),batarg("b",flt),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,5,
arg("",dbl),arg("b",flt),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,5,
batarg("",dbl),batarg("b",flt),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,6,
arg("",dbl),arg("b",flt),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,6,
batarg("",dbl),batarg("b",flt),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,3, arg("",dbl),arg("b",flt),arg("t",int))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,3, batarg("",dbl),batarg("b",flt),arg("t",int))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,4, arg("",dbl),arg("b",flt),arg("t",int),arg("p",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,4,
batarg("",dbl),batarg("b",flt),arg("t",int),batarg("p",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,4, arg("",dbl),arg("b",flt),arg("t",int),arg("o",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,4,
batarg("",dbl),batarg("b",flt),arg("t",int),batarg("o",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,5, arg("",dbl),arg("b",flt),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,5,
batarg("",dbl),batarg("b",flt),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "prod", SQLprod, false, "return the product of groups",
args(1,5, arg("",dbl),arg("b",flt),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "prod", SQLprod, false, "return the product of groups",
args(1,5,
batarg("",dbl),batarg("b",flt),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "prod", SQLprod, false, "return the product of groups",
args(1,6,
arg("",dbl),arg("b",flt),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "prod", SQLprod, false, "return the product of groups",
args(1,6,
batarg("",dbl),batarg("b",flt),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,3, arg("",dbl),arg("b",dbl),arg("t",int))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,3, batarg("",dbl),batarg("b",dbl),arg("t",int))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, arg("",dbl),arg("b",dbl),arg("t",int),arg("p",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("p",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, arg("",dbl),arg("b",dbl),arg("t",int),arg("o",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,4, batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("o",bit))),
- pattern("sql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,5, arg("",dbl),arg("b",dbl),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "sum", SQLsum_global, false, "return the sum of groups",
args(1,5,
batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,5,
arg("",dbl),arg("b",dbl),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,5,
batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "sum", SQLsum, false, "return the sum of groups", args(1,6,
arg("",dbl),arg("b",dbl),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "sum", SQLsum, false, "return the sum of groups", args(1,6,
batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,3, arg("",dbl),arg("b",dbl),arg("t",int))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,3, batarg("",dbl),batarg("b",dbl),arg("t",int))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,4, arg("",dbl),arg("b",dbl),arg("t",int),arg("p",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,4,
batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("p",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,4, arg("",dbl),arg("b",dbl),arg("t",int),arg("o",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,4,
batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("o",bit))),
- pattern("sql", "prod", SQLprod_global, false, "return the product of groups",
args(1,5, arg("",dbl),arg("b",dbl),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "prod", SQLprod_global, false, "return the product of
groups", args(1,5,
batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "prod", SQLprod, false, "return the product of groups",
args(1,5, arg("",dbl),arg("b",dbl),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "prod", SQLprod, false, "return the product of groups",
args(1,5,
batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "prod", SQLprod, false, "return the product of groups",
args(1,6,
arg("",dbl),arg("b",dbl),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "prod", SQLprod, false, "return the product of groups",
args(1,6,
batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "avg", SQLavg, false, "return the average of groups",
args(1,5, arg("",dbl),arg("b",bte),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "avg", SQLavg, false, "return the average of groups",
args(1,5,
batarg("",dbl),batarg("b",bte),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "avg", SQLavg, false, "return the average of groups",
args(1,6,
arg("",dbl),arg("b",bte),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "avg", SQLavg, false, "return the average of groups",
args(1,6,
batarg("",dbl),batarg("b",bte),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,3, arg("",dbl),arg("b",bte),arg("t",int))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,3, batarg("",dbl),batarg("b",bte),arg("t",int))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,4, arg("",dbl),arg("b",bte),arg("t",int),arg("p",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,4,
batarg("",dbl),batarg("b",bte),arg("t",int),batarg("p",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,4, arg("",dbl),arg("b",bte),arg("t",int),arg("o",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,4,
batarg("",dbl),batarg("b",bte),arg("t",int),batarg("o",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,5, arg("",dbl),arg("b",bte),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,5,
batarg("",dbl),batarg("b",bte),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "avg", SQLavg, false, "return the average of groups",
args(1,5, arg("",dbl),arg("b",sht),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "avg", SQLavg, false, "return the average of groups",
args(1,5,
batarg("",dbl),batarg("b",sht),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "avg", SQLavg, false, "return the average of groups",
args(1,6,
arg("",dbl),arg("b",sht),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "avg", SQLavg, false, "return the average of groups",
args(1,6,
batarg("",dbl),batarg("b",sht),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,3, arg("",dbl),arg("b",sht),arg("t",int))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,3, batarg("",dbl),batarg("b",sht),arg("t",int))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,4, arg("",dbl),arg("b",sht),arg("t",int),arg("p",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,4,
batarg("",dbl),batarg("b",sht),arg("t",int),batarg("p",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,4, arg("",dbl),arg("b",sht),arg("t",int),arg("o",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,4,
batarg("",dbl),batarg("b",sht),arg("t",int),batarg("o",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,5, arg("",dbl),arg("b",sht),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,5,
batarg("",dbl),batarg("b",sht),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "avg", SQLavg, false, "return the average of groups",
args(1,5, arg("",dbl),arg("b",int),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "avg", SQLavg, false, "return the average of groups",
args(1,5,
batarg("",dbl),batarg("b",int),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "avg", SQLavg, false, "return the average of groups",
args(1,6,
arg("",dbl),arg("b",int),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "avg", SQLavg, false, "return the average of groups",
args(1,6,
batarg("",dbl),batarg("b",int),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,3, arg("",dbl),arg("b",int),arg("t",int))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,3, batarg("",dbl),batarg("b",int),arg("t",int))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,4, arg("",dbl),arg("b",int),arg("t",int),arg("p",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,4,
batarg("",dbl),batarg("b",int),arg("t",int),batarg("p",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,4, arg("",dbl),arg("b",int),arg("t",int),arg("o",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,4,
batarg("",dbl),batarg("b",int),arg("t",int),batarg("o",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,5, arg("",dbl),arg("b",int),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,5,
batarg("",dbl),batarg("b",int),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "avg", SQLavg, false, "return the average of groups",
args(1,5, arg("",dbl),arg("b",lng),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "avg", SQLavg, false, "return the average of groups",
args(1,5,
batarg("",dbl),batarg("b",lng),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "avg", SQLavg, false, "return the average of groups",
args(1,6,
arg("",dbl),arg("b",lng),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "avg", SQLavg, false, "return the average of groups",
args(1,6,
batarg("",dbl),batarg("b",lng),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,3, arg("",dbl),arg("b",lng),arg("t",int))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,3, batarg("",dbl),batarg("b",lng),arg("t",int))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,4, arg("",dbl),arg("b",lng),arg("t",int),arg("p",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,4,
batarg("",dbl),batarg("b",lng),arg("t",int),batarg("p",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,4, arg("",dbl),arg("b",lng),arg("t",int),arg("o",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,4,
batarg("",dbl),batarg("b",lng),arg("t",int),batarg("o",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,5, arg("",dbl),arg("b",lng),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,5,
batarg("",dbl),batarg("b",lng),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "avg", SQLavg, false, "return the average of groups",
args(1,5, arg("",dbl),arg("b",flt),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "avg", SQLavg, false, "return the average of groups",
args(1,5,
batarg("",dbl),batarg("b",flt),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "avg", SQLavg, false, "return the average of groups",
args(1,6,
arg("",dbl),arg("b",flt),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "avg", SQLavg, false, "return the average of groups",
args(1,6,
batarg("",dbl),batarg("b",flt),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,3, arg("",dbl),arg("b",flt),arg("t",int))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,3, batarg("",dbl),batarg("b",flt),arg("t",int))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,4, arg("",dbl),arg("b",flt),arg("t",int),arg("p",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,4,
batarg("",dbl),batarg("b",flt),arg("t",int),batarg("p",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,4, arg("",dbl),arg("b",flt),arg("t",int),arg("o",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,4,
batarg("",dbl),batarg("b",flt),arg("t",int),batarg("o",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,5, arg("",dbl),arg("b",flt),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,5,
batarg("",dbl),batarg("b",flt),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "avg", SQLavg, false, "return the average of groups",
args(1,5, arg("",dbl),arg("b",dbl),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "avg", SQLavg, false, "return the average of groups",
args(1,5,
batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "avg", SQLavg, false, "return the average of groups",
args(1,6,
arg("",dbl),arg("b",dbl),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "avg", SQLavg, false, "return the average of groups",
args(1,6,
batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,3, arg("",dbl),arg("b",dbl),arg("t",int))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,3, batarg("",dbl),batarg("b",dbl),arg("t",int))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,4, arg("",dbl),arg("b",dbl),arg("t",int),arg("p",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,4,
batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("p",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,4, arg("",dbl),arg("b",dbl),arg("t",int),arg("o",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,4,
batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("o",bit))),
- pattern("sql", "avg", SQLavg_global, false, "return the average of groups",
args(1,5, arg("",dbl),arg("b",dbl),arg("t",int),arg("o",bit),arg("p",bit))),
- pattern("batsql", "avg", SQLavg_global, false, "return the average of
groups", args(1,5,
batarg("",dbl),batarg("b",dbl),arg("t",int),batarg("o",bit),batarg("p",bit))),
- pattern("sql", "avg", SQLavginteger, false, "return the average of groups",
args(1,5, arg("",bte),arg("b",bte),arg("t",int),arg("s",lng),arg("e",lng))),
- pattern("batsql", "avg", SQLavginteger, false, "return the average of
groups", args(1,5,
batarg("",bte),batarg("b",bte),arg("t",int),batarg("s",lng),batarg("e",lng))),
- pattern("sql", "avg", SQLavginteger, false, "return the average of groups",
args(1,6,
arg("",bte),arg("b",bte),arg("t",int),arg("s",lng),arg("e",lng),arg("p",bit))),
- pattern("batsql", "avg", SQLavginteger, false, "return the average of
groups", args(1,6,
batarg("",bte),batarg("b",bte),arg("t",int),batarg("s",lng),batarg("e",lng),batarg("p",bit))),
- pattern("sql", "avg", SQLavginteger_global, false, "return the average of
groups", args(1,3, arg("",bte),arg("b",bte),arg("t",int))),
- pattern("batsql", "avg", SQLavginteger_global, false, "return the average of
groups", args(1,3, batarg("",bte),batarg("b",bte),arg("t",int))),
- pattern("sql", "avg", SQLavginteger_global, false, "return the average of
groups", args(1,4, arg("",bte),arg("b",bte),arg("t",int),arg("p",bit))),
- pattern("batsql", "avg", SQLavginteger_global, false, "return the average of
groups", args(1,4,
batarg("",bte),batarg("b",bte),arg("t",int),batarg("p",bit))),
- pattern("sql", "avg", SQLavginteger_global, false, "return the average of
groups", args(1,4, arg("",bte),arg("b",bte),arg("t",int),arg("o",bit))),
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
