Changeset: d4c3037ab922 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d4c3037ab922
Modified Files:
clients/Tests/MAL-signatures.stable.out
sql/test/Tests/systemfunctions.stable.out
Branch: analytics
Log Message:
Approve non-128bit build output.
diffs (truncated from 306 to 300 lines):
diff --git a/clients/Tests/MAL-signatures.stable.out
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -8380,7 +8380,6 @@ Ready.
[ "batsql", "avg", "pattern batsql.avg(b:bat[:bte], s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ]
[ "batsql", "avg", "pattern batsql.avg(b:bat[:dbl], s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ]
[ "batsql", "avg", "pattern batsql.avg(b:bat[:flt], s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ]
-[ "batsql", "avg", "pattern batsql.avg(b:bat[:hge], s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ]
[ "batsql", "avg", "pattern batsql.avg(b:bat[:int], s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ]
[ "batsql", "avg", "pattern batsql.avg(b:bat[:lng], s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ]
[ "batsql", "avg", "pattern batsql.avg(b:bat[:sht], s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ]
@@ -8420,17 +8419,12 @@ Ready.
[ "batsql", "ntile", "pattern batsql.ntile(b:bat[:any_1],
n:bat[:any_2], p:any_3, o:any_4):bat[:any_2] ", "SQLntile;", "return the
groups divided as equally as possible" ]
[ "batsql", "password", "pattern
batsql.password(user:bat[:str]):bat[:str] ", "db_password_wrap;", "Return
password hash of user" ]
[ "batsql", "percent_rank", "pattern batsql.percent_rank(b:bat[:any_1],
p:any_2, o:any_3):bat[:dbl] ", "SQLpercent_rank;", "return the
percentage into the total number of groups for each row" ]
-[ "batsql", "prod", "pattern batsql.prod(b:bat[:bte], s:bat[:lng],
e:bat[:lng]):bat[:hge] ", "SQLprod;", "return the product of groups"
]
[ "batsql", "prod", "pattern batsql.prod(b:bat[:bte], s:bat[:lng],
e:bat[:lng]):bat[:lng] ", "SQLprod;", "return the product of groups"
]
[ "batsql", "prod", "pattern batsql.prod(b:bat[:dbl], s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLprod;", "return the product of groups"
]
[ "batsql", "prod", "pattern batsql.prod(b:bat[:flt], s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLprod;", "return the product of groups"
]
[ "batsql", "prod", "pattern batsql.prod(b:bat[:flt], s:bat[:lng],
e:bat[:lng]):bat[:flt] ", "SQLprod;", "return the product of groups"
]
-[ "batsql", "prod", "pattern batsql.prod(b:bat[:hge], s:bat[:lng],
e:bat[:lng]):bat[:hge] ", "SQLprod;", "return the product of groups"
]
-[ "batsql", "prod", "pattern batsql.prod(b:bat[:int], s:bat[:lng],
e:bat[:lng]):bat[:hge] ", "SQLprod;", "return the product of groups"
]
[ "batsql", "prod", "pattern batsql.prod(b:bat[:int], s:bat[:lng],
e:bat[:lng]):bat[:lng] ", "SQLprod;", "return the product of groups"
]
-[ "batsql", "prod", "pattern batsql.prod(b:bat[:lng], s:bat[:lng],
e:bat[:lng]):bat[:hge] ", "SQLprod;", "return the product of groups"
]
[ "batsql", "prod", "pattern batsql.prod(b:bat[:lng], s:bat[:lng],
e:bat[:lng]):bat[:lng] ", "SQLprod;", "return the product of groups"
]
-[ "batsql", "prod", "pattern batsql.prod(b:bat[:sht], s:bat[:lng],
e:bat[:lng]):bat[:hge] ", "SQLprod;", "return the product of groups"
]
[ "batsql", "prod", "pattern batsql.prod(b:bat[:sht], s:bat[:lng],
e:bat[:lng]):bat[:lng] ", "SQLprod;", "return the product of groups"
]
[ "batsql", "rank", "pattern batsql.rank(b:bat[:any_1], p:any_2,
o:any_3):bat[:int] ", "SQLrank;", "return the ranked groups" ]
[ "batsql", "round", "command batsql.round(v:bat[:bte], d:int,
s:int, r:bte):bat[:bte] ", "bte_bat_round_wrap;", "round off the decimal
v(d,s) to r digits behind the dot (if r < 0, before the dot)" ]
@@ -8440,71 +8434,58 @@ Ready.
[ "batsql", "round", "command batsql.round(v:bat[:lng], d:int,
s:int, r:bte):bat[:lng] ", "lng_bat_round_wrap;", "round off the decimal
v(d,s) to r digits behind the dot (if r < 0, before the dot)" ]
[ "batsql", "round", "command batsql.round(v:bat[:sht], d:int,
s:int, r:bte):bat[:sht] ", "sht_bat_round_wrap;", "round off the decimal
v(d,s) to r digits behind the dot (if r < 0, before the dot)" ]
[ "batsql", "row_number", "pattern batsql.row_number(b:bat[:any_1],
p:any_2, o:any_3):bat[:int] ", "SQLrow_number;", "return the
row_numer-ed groups" ]
-[ "batsql", "sum", "pattern batsql.sum(b:bat[:bte], s:bat[:lng],
e:bat[:lng]):bat[:hge] ", "SQLsum;", "return the sum of groups" ]
[ "batsql", "sum", "pattern batsql.sum(b:bat[:bte], s:bat[:lng],
e:bat[:lng]):bat[:lng] ", "SQLsum;", "return the sum of groups" ]
[ "batsql", "sum", "pattern batsql.sum(b:bat[:dbl], s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLsum;", "return the sum of groups" ]
[ "batsql", "sum", "pattern batsql.sum(b:bat[:flt], s:bat[:lng],
e:bat[:lng]):bat[:dbl] ", "SQLsum;", "return the sum of groups" ]
[ "batsql", "sum", "pattern batsql.sum(b:bat[:flt], s:bat[:lng],
e:bat[:lng]):bat[:flt] ", "SQLsum;", "return the sum of groups" ]
-[ "batsql", "sum", "pattern batsql.sum(b:bat[:hge], s:bat[:lng],
e:bat[:lng]):bat[:hge] ", "SQLsum;", "return the sum of groups" ]
-[ "batsql", "sum", "pattern batsql.sum(b:bat[:int], s:bat[:lng],
e:bat[:lng]):bat[:hge] ", "SQLsum;", "return the sum of groups" ]
[ "batsql", "sum", "pattern batsql.sum(b:bat[:int], s:bat[:lng],
e:bat[:lng]):bat[:lng] ", "SQLsum;", "return the sum of groups" ]
-[ "batsql", "sum", "pattern batsql.sum(b:bat[:lng], s:bat[:lng],
e:bat[:lng]):bat[:hge] ", "SQLsum;", "return the sum of groups" ]
[ "batsql", "sum", "pattern batsql.sum(b:bat[:lng], s:bat[:lng],
e:bat[:lng]):bat[:lng] ", "SQLsum;", "return the sum of groups" ]
-[ "batsql", "sum", "pattern batsql.sum(b:bat[:sht], s:bat[:lng],
e:bat[:lng]):bat[:hge] ", "SQLsum;", "return the sum of groups" ]
[ "batsql", "sum", "pattern batsql.sum(b:bat[:sht], s:bat[:lng],
e:bat[:lng]):bat[:lng] ", "SQLsum;", "return the sum of groups" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
end:bat[:bte]):bat[:lng] ", "SQLwindow_following_bound;", "computes the end
ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
end:bat[:dbl]):bat[:lng] ", "SQLwindow_following_bound;", "computes the end
ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
end:bat[:flt]):bat[:lng] ", "SQLwindow_following_bound;", "computes the end
ranges for each row" ]
-[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
end:bat[:hge]):bat[:lng] ", "SQLwindow_following_bound;", "computes the end
ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
end:bat[:int]):bat[:lng] ", "SQLwindow_following_bound;", "computes the end
ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
end:bat[:lng]):bat[:lng] ", "SQLwindow_following_bound;", "computes the end
ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
end:bat[:sht]):bat[:lng] ", "SQLwindow_following_bound;", "computes the end
ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
end:bte):bat[:lng] ", "SQLwindow_following_bound;", "computes the end ranges
for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
end:dbl):bat[:lng] ", "SQLwindow_following_bound;", "computes the end ranges
for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
end:flt):bat[:lng] ", "SQLwindow_following_bound;", "computes the end ranges
for each row" ]
-[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
end:hge):bat[:lng] ", "SQLwindow_following_bound;", "computes the end ranges
for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
end:int):bat[:lng] ", "SQLwindow_following_bound;", "computes the end ranges
for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
end:lng):bat[:lng] ", "SQLwindow_following_bound;", "computes the end ranges
for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
end:sht):bat[:lng] ", "SQLwindow_following_bound;", "computes the end ranges
for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, end:bat[:bte]):bat[:lng] ", "SQLwindow_following_bound;",
"computes the end ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, end:bat[:dbl]):bat[:lng] ", "SQLwindow_following_bound;",
"computes the end ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, end:bat[:flt]):bat[:lng] ", "SQLwindow_following_bound;",
"computes the end ranges for each row" ]
-[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, end:bat[:hge]):bat[:lng] ", "SQLwindow_following_bound;",
"computes the end ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, end:bat[:int]):bat[:lng] ", "SQLwindow_following_bound;",
"computes the end ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, end:bat[:lng]):bat[:lng] ", "SQLwindow_following_bound;",
"computes the end ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, end:bat[:sht]):bat[:lng] ", "SQLwindow_following_bound;",
"computes the end ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, end:bte):bat[:lng] ", "SQLwindow_following_bound;", "computes the
end ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, end:dbl):bat[:lng] ", "SQLwindow_following_bound;", "computes the
end ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, end:flt):bat[:lng] ", "SQLwindow_following_bound;", "computes the
end ranges for each row" ]
-[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, end:hge):bat[:lng] ", "SQLwindow_following_bound;", "computes the
end ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, end:int):bat[:lng] ", "SQLwindow_following_bound;", "computes the
end ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, end:lng):bat[:lng] ", "SQLwindow_following_bound;", "computes the
end ranges for each row" ]
[ "batsql", "window_following_bound", "pattern
batsql.window_following_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, end:sht):bat[:lng] ", "SQLwindow_following_bound;", "computes the
end ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
start:bat[:bte]):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
start:bat[:dbl]):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
start:bat[:flt]):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
-[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
start:bat[:hge]):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
start:bat[:int]):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
start:bat[:lng]):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
start:bat[:sht]):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
start:bte):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
start:dbl):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
start:flt):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
-[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
start:hge):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
start:int):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
start:lng):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(b:bat[:any_1], unit:int, excl:int, fh:lng,
start:sht):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, start:bat[:bte]):bat[:lng] ", "SQLwindow_preceding_bound;",
"computes the start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, start:bat[:dbl]):bat[:lng] ", "SQLwindow_preceding_bound;",
"computes the start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, start:bat[:flt]):bat[:lng] ", "SQLwindow_preceding_bound;",
"computes the start ranges for each row" ]
-[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, start:bat[:hge]):bat[:lng] ", "SQLwindow_preceding_bound;",
"computes the start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, start:bat[:int]):bat[:lng] ", "SQLwindow_preceding_bound;",
"computes the start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, start:bat[:lng]):bat[:lng] ", "SQLwindow_preceding_bound;",
"computes the start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, start:bat[:sht]):bat[:lng] ", "SQLwindow_preceding_bound;",
"computes the start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, start:bte):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, start:dbl):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, start:flt):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
-[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, start:hge):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, start:int):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, start:lng):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
[ "batsql", "window_preceding_bound", "pattern
batsql.window_preceding_bound(p:bat[:bit], b:bat[:any_1], unit:int, excl:int,
fh:lng, start:sht):bat[:lng] ", "SQLwindow_preceding_bound;", "computes the
start ranges for each row" ]
@@ -11032,7 +11013,6 @@ Ready.
[ "sql", "avg", "pattern sql.avg(b:bte, s:lng, e:lng):dbl ",
"SQLavg;", "return the average of groups" ]
[ "sql", "avg", "pattern sql.avg(b:dbl, s:lng, e:lng):dbl ",
"SQLavg;", "return the average of groups" ]
[ "sql", "avg", "pattern sql.avg(b:flt, s:lng, e:lng):dbl ",
"SQLavg;", "return the average of groups" ]
-[ "sql", "avg", "pattern sql.avg(b:hge, s:lng, e:lng):dbl ",
"SQLavg;", "return the average of groups" ]
[ "sql", "avg", "pattern sql.avg(b:int, s:lng, e:lng):dbl ",
"SQLavg;", "return the average of groups" ]
[ "sql", "avg", "pattern sql.avg(b:lng, s:lng, e:lng):dbl ",
"SQLavg;", "return the average of groups" ]
[ "sql", "avg", "pattern sql.avg(b:sht, s:lng, e:lng):dbl ",
"SQLavg;", "return the average of groups" ]
@@ -11132,17 +11112,12 @@ Ready.
[ "sql", "password", "pattern sql.password(user:str):str ",
"db_password_wrap;", "Return password hash of user" ]
[ "sql", "percent_rank", "pattern sql.percent_rank(b:any_1, p:bit,
o:bit):dbl ", "SQLpercent_rank;", "return the percentage into the total
number of groups for each row" ]
[ "sql", "prelude", "pattern sql.prelude():void ", "SQLprelude;",
"" ]
-[ "sql", "prod", "pattern sql.prod(b:bte, s:lng, e:lng):hge ",
"SQLprod;", "return the product of groups" ]
[ "sql", "prod", "pattern sql.prod(b:bte, s:lng, e:lng):lng ",
"SQLprod;", "return the product of groups" ]
[ "sql", "prod", "pattern sql.prod(b:dbl, s:lng, e:lng):dbl ",
"SQLprod;", "return the product of groups" ]
[ "sql", "prod", "pattern sql.prod(b:flt, s:lng, e:lng):dbl ",
"SQLprod;", "return the product of groups" ]
[ "sql", "prod", "pattern sql.prod(b:flt, s:lng, e:lng):flt ",
"SQLprod;", "return the product of groups" ]
-[ "sql", "prod", "pattern sql.prod(b:hge, s:lng, e:lng):hge ",
"SQLprod;", "return the product of groups" ]
-[ "sql", "prod", "pattern sql.prod(b:int, s:lng, e:lng):hge ",
"SQLprod;", "return the product of groups" ]
[ "sql", "prod", "pattern sql.prod(b:int, s:lng, e:lng):lng ",
"SQLprod;", "return the product of groups" ]
-[ "sql", "prod", "pattern sql.prod(b:lng, s:lng, e:lng):hge ",
"SQLprod;", "return the product of groups" ]
[ "sql", "prod", "pattern sql.prod(b:lng, s:lng, e:lng):lng ",
"SQLprod;", "return the product of groups" ]
-[ "sql", "prod", "pattern sql.prod(b:sht, s:lng, e:lng):hge ",
"SQLprod;", "return the product of groups" ]
[ "sql", "prod", "pattern sql.prod(b:sht, s:lng, e:lng):lng ",
"SQLprod;", "return the product of groups" ]
[ "sql", "project", "command sql.project(col:bat[:oid],
l:bat[:oid], r:bat[:oid]):bat[:oid] ", "BATleftproject;", "Last step
of a left outer join, ie project the inner join (l,r) over the left input side
(col)" ]
[ "sql", "projectdelta", "command sql.projectdelta(select:bat[:oid],
col:bat[:any_3], uid:bat[:oid], uval:bat[:any_3]):bat[:any_3] ",
"DELTAproject2;", "Return column bat with delta's applied." ]
@@ -11189,17 +11164,12 @@ Ready.
[ "sql", "subdelta", "command sql.subdelta(col:bat[:oid],
cand:bat[:oid], uid:bat[:oid], uval:bat[:oid]):bat[:oid] ",
"DELTAsub2;", "Return a single bat of selected delta." ]
[ "sql", "subdelta", "command sql.subdelta(col:bat[:oid],
cand:bat[:oid], uid:bat[:oid], uval:bat[:oid], ins:bat[:oid]):bat[:oid] ",
"DELTAsub;", "Return a single bat of selected delta." ]
[ "sql", "subzero_or_one", "inline function
sql.subzero_or_one(b:bat[:any_1], gp:bat[:oid], gpe:bat[:oid],
no_nil:bit):bat[:any_1];", "", "" ]
-[ "sql", "sum", "pattern sql.sum(b:bte, s:lng, e:lng):hge ",
"SQLsum;", "return the sum of groups" ]
[ "sql", "sum", "pattern sql.sum(b:bte, s:lng, e:lng):lng ",
"SQLsum;", "return the sum of groups" ]
[ "sql", "sum", "pattern sql.sum(b:dbl, s:lng, e:lng):dbl ",
"SQLsum;", "return the sum of groups" ]
[ "sql", "sum", "pattern sql.sum(b:flt, s:lng, e:lng):dbl ",
"SQLsum;", "return the sum of groups" ]
[ "sql", "sum", "pattern sql.sum(b:flt, s:lng, e:lng):flt ",
"SQLsum;", "return the sum of groups" ]
-[ "sql", "sum", "pattern sql.sum(b:hge, s:lng, e:lng):hge ",
"SQLsum;", "return the sum of groups" ]
-[ "sql", "sum", "pattern sql.sum(b:int, s:lng, e:lng):hge ",
"SQLsum;", "return the sum of groups" ]
[ "sql", "sum", "pattern sql.sum(b:int, s:lng, e:lng):lng ",
"SQLsum;", "return the sum of groups" ]
-[ "sql", "sum", "pattern sql.sum(b:lng, s:lng, e:lng):hge ",
"SQLsum;", "return the sum of groups" ]
[ "sql", "sum", "pattern sql.sum(b:lng, s:lng, e:lng):lng ",
"SQLsum;", "return the sum of groups" ]
-[ "sql", "sum", "pattern sql.sum(b:sht, s:lng, e:lng):hge ",
"SQLsum;", "return the sum of groups" ]
[ "sql", "sum", "pattern sql.sum(b:sht, s:lng, e:lng):lng ",
"SQLsum;", "return the sum of groups" ]
[ "sql", "sysmon_pause", "pattern sql.sysmon_pause(tag:int):void ",
"SYSMONpause;", "" ]
[ "sql", "sysmon_pause", "pattern sql.sysmon_pause(tag:lng):void ",
"SYSMONpause;", "" ]
@@ -11226,28 +11196,24 @@ Ready.
[ "sql", "window_following_bound", "pattern
sql.window_following_bound(b:any_1, unit:int, excl:int, fh:lng, end:bte):lng ",
"SQLwindow_following_bound;", "computes the end ranges for each row" ]
[ "sql", "window_following_bound", "pattern
sql.window_following_bound(b:any_1, unit:int, excl:int, fh:lng, end:dbl):lng ",
"SQLwindow_following_bound;", "computes the end ranges for each row" ]
[ "sql", "window_following_bound", "pattern
sql.window_following_bound(b:any_1, unit:int, excl:int, fh:lng, end:flt):lng ",
"SQLwindow_following_bound;", "computes the end ranges for each row" ]
-[ "sql", "window_following_bound", "pattern
sql.window_following_bound(b:any_1, unit:int, excl:int, fh:lng, end:hge):lng ",
"SQLwindow_following_bound;", "computes the end ranges for each row" ]
[ "sql", "window_following_bound", "pattern
sql.window_following_bound(b:any_1, unit:int, excl:int, fh:lng, end:int):lng ",
"SQLwindow_following_bound;", "computes the end ranges for each row" ]
[ "sql", "window_following_bound", "pattern
sql.window_following_bound(b:any_1, unit:int, excl:int, fh:lng, end:lng):lng ",
"SQLwindow_following_bound;", "computes the end ranges for each row" ]
[ "sql", "window_following_bound", "pattern
sql.window_following_bound(b:any_1, unit:int, excl:int, fh:lng, end:sht):lng ",
"SQLwindow_following_bound;", "computes the end ranges for each row" ]
[ "sql", "window_following_bound", "pattern
sql.window_following_bound(p:bit, b:any_1, unit:int, excl:int, fh:lng,
end:bte):lng ", "SQLwindow_following_bound;", "computes the end ranges for
each row" ]
[ "sql", "window_following_bound", "pattern
sql.window_following_bound(p:bit, b:any_1, unit:int, excl:int, fh:lng,
end:dbl):lng ", "SQLwindow_following_bound;", "computes the end ranges for
each row" ]
[ "sql", "window_following_bound", "pattern
sql.window_following_bound(p:bit, b:any_1, unit:int, excl:int, fh:lng,
end:flt):lng ", "SQLwindow_following_bound;", "computes the end ranges for
each row" ]
-[ "sql", "window_following_bound", "pattern
sql.window_following_bound(p:bit, b:any_1, unit:int, excl:int, fh:lng,
end:hge):lng ", "SQLwindow_following_bound;", "computes the end ranges for
each row" ]
[ "sql", "window_following_bound", "pattern
sql.window_following_bound(p:bit, b:any_1, unit:int, excl:int, fh:lng,
end:int):lng ", "SQLwindow_following_bound;", "computes the end ranges for
each row" ]
[ "sql", "window_following_bound", "pattern
sql.window_following_bound(p:bit, b:any_1, unit:int, excl:int, fh:lng,
end:lng):lng ", "SQLwindow_following_bound;", "computes the end ranges for
each row" ]
[ "sql", "window_following_bound", "pattern
sql.window_following_bound(p:bit, b:any_1, unit:int, excl:int, fh:lng,
end:sht):lng ", "SQLwindow_following_bound;", "computes the end ranges for
each row" ]
[ "sql", "window_preceding_bound", "pattern
sql.window_preceding_bound(b:any_1, unit:int, excl:int, fh:lng, start:bte):lng
", "SQLwindow_preceding_bound;", "computes the start ranges for each
row" ]
[ "sql", "window_preceding_bound", "pattern
sql.window_preceding_bound(b:any_1, unit:int, excl:int, fh:lng, start:dbl):lng
", "SQLwindow_preceding_bound;", "computes the start ranges for each
row" ]
[ "sql", "window_preceding_bound", "pattern
sql.window_preceding_bound(b:any_1, unit:int, excl:int, fh:lng, start:flt):lng
", "SQLwindow_preceding_bound;", "computes the start ranges for each
row" ]
-[ "sql", "window_preceding_bound", "pattern
sql.window_preceding_bound(b:any_1, unit:int, excl:int, fh:lng, start:hge):lng
", "SQLwindow_preceding_bound;", "computes the start ranges for each
row" ]
[ "sql", "window_preceding_bound", "pattern
sql.window_preceding_bound(b:any_1, unit:int, excl:int, fh:lng, start:int):lng
", "SQLwindow_preceding_bound;", "computes the start ranges for each
row" ]
[ "sql", "window_preceding_bound", "pattern
sql.window_preceding_bound(b:any_1, unit:int, excl:int, fh:lng, start:lng):lng
", "SQLwindow_preceding_bound;", "computes the start ranges for each
row" ]
[ "sql", "window_preceding_bound", "pattern
sql.window_preceding_bound(b:any_1, unit:int, excl:int, fh:lng, start:sht):lng
", "SQLwindow_preceding_bound;", "computes the start ranges for each
row" ]
[ "sql", "window_preceding_bound", "pattern
sql.window_preceding_bound(p:bit, b:any_1, unit:int, excl:int, fh:lng,
start:bte):lng ", "SQLwindow_preceding_bound;", "computes the start
ranges for each row" ]
[ "sql", "window_preceding_bound", "pattern
sql.window_preceding_bound(p:bit, b:any_1, unit:int, excl:int, fh:lng,
start:dbl):lng ", "SQLwindow_preceding_bound;", "computes the start
ranges for each row" ]
[ "sql", "window_preceding_bound", "pattern
sql.window_preceding_bound(p:bit, b:any_1, unit:int, excl:int, fh:lng,
start:flt):lng ", "SQLwindow_preceding_bound;", "computes the start
ranges for each row" ]
-[ "sql", "window_preceding_bound", "pattern
sql.window_preceding_bound(p:bit, b:any_1, unit:int, excl:int, fh:lng,
start:hge):lng ", "SQLwindow_preceding_bound;", "computes the start
ranges for each row" ]
[ "sql", "window_preceding_bound", "pattern
sql.window_preceding_bound(p:bit, b:any_1, unit:int, excl:int, fh:lng,
start:int):lng ", "SQLwindow_preceding_bound;", "computes the start
ranges for each row" ]
[ "sql", "window_preceding_bound", "pattern
sql.window_preceding_bound(p:bit, b:any_1, unit:int, excl:int, fh:lng,
start:lng):lng ", "SQLwindow_preceding_bound;", "computes the start
ranges for each row" ]
[ "sql", "window_preceding_bound", "pattern
sql.window_preceding_bound(p:bit, b:any_1, unit:int, excl:int, fh:lng,
start:sht):lng ", "SQLwindow_preceding_bound;", "computes the start
ranges for each row" ]
diff --git a/sql/test/Tests/systemfunctions.stable.out
b/sql/test/Tests/systemfunctions.stable.out
--- a/sql/test/Tests/systemfunctions.stable.out
+++ b/sql/test/Tests/systemfunctions.stable.out
@@ -247,8 +247,6 @@ Ready.
[ "sys", "avg", 0, "double", "avg" ]
[ "sys", "avg", 1, "bigint", "" ]
[ "sys", "avg", 0, "double", "avg" ]
-[ "sys", "avg", 1, "hugeint", "" ]
-[ "sys", "avg", 0, "double", "avg" ]
[ "sys", "avg", 1, "real", "" ]
[ "sys", "avg", 0, "double", "avg" ]
[ "sys", "avg", 1, "double", "" ]
@@ -797,11 +795,6 @@ Ready.
[ "sys", "lag", 4, "boolean", "" ]
[ "sys", "lag", 0, "any", "lag" ]
[ "sys", "lag", 1, "any", "" ]
-[ "sys", "lag", 2, "hugeint", "" ]
-[ "sys", "lag", 3, "boolean", "" ]
-[ "sys", "lag", 4, "boolean", "" ]
-[ "sys", "lag", 0, "any", "lag" ]
-[ "sys", "lag", 1, "any", "" ]
[ "sys", "lag", 2, "tinyint", "" ]
[ "sys", "lag", 3, "any", "" ]
[ "sys", "lag", 4, "boolean", "" ]
@@ -824,12 +817,6 @@ Ready.
[ "sys", "lag", 3, "any", "" ]
[ "sys", "lag", 4, "boolean", "" ]
[ "sys", "lag", 5, "boolean", "" ]
-[ "sys", "lag", 0, "any", "lag" ]
-[ "sys", "lag", 1, "any", "" ]
-[ "sys", "lag", 2, "hugeint", "" ]
-[ "sys", "lag", 3, "any", "" ]
-[ "sys", "lag", 4, "boolean", "" ]
-[ "sys", "lag", 5, "boolean", "" ]
[ "sys", "last_value", 0, "any", "last_value" ]
[ "sys", "last_value", 1, "any", "" ]
[ "sys", "last_value", 2, "boolean", "" ]
@@ -866,11 +853,6 @@ Ready.
[ "sys", "lead", 4, "boolean", "" ]
[ "sys", "lead", 0, "any", "lead" ]
[ "sys", "lead", 1, "any", "" ]
-[ "sys", "lead", 2, "hugeint", "" ]
-[ "sys", "lead", 3, "boolean", "" ]
-[ "sys", "lead", 4, "boolean", "" ]
-[ "sys", "lead", 0, "any", "lead" ]
-[ "sys", "lead", 1, "any", "" ]
[ "sys", "lead", 2, "tinyint", "" ]
[ "sys", "lead", 3, "any", "" ]
[ "sys", "lead", 4, "boolean", "" ]
@@ -893,12 +875,6 @@ Ready.
[ "sys", "lead", 3, "any", "" ]
[ "sys", "lead", 4, "boolean", "" ]
[ "sys", "lead", 5, "boolean", "" ]
-[ "sys", "lead", 0, "any", "lead" ]
-[ "sys", "lead", 1, "any", "" ]
-[ "sys", "lead", 2, "hugeint", "" ]
-[ "sys", "lead", 3, "any", "" ]
-[ "sys", "lead", 4, "boolean", "" ]
-[ "sys", "lead", 5, "boolean", "" ]
[ "sys", "left", 0, "char", "stringleft" ]
[ "sys", "left", 1, "char", "" ]
[ "sys", "left", 2, "int", "" ]
@@ -1346,11 +1322,6 @@ Ready.
[ "sys", "nth_value", 2, "bigint", "" ]
[ "sys", "nth_value", 3, "boolean", "" ]
[ "sys", "nth_value", 4, "boolean", "" ]
-[ "sys", "nth_value", 0, "any", "nth_value" ]
-[ "sys", "nth_value", 1, "any", "" ]
-[ "sys", "nth_value", 2, "hugeint", "" ]
-[ "sys", "nth_value", 3, "boolean", "" ]
-[ "sys", "nth_value", 4, "boolean", "" ]
[ "sys", "ntile", 0, "tinyint", "ntile" ]
[ "sys", "ntile", 1, "any", "" ]
[ "sys", "ntile", 2, "tinyint", "" ]
@@ -1371,11 +1342,6 @@ Ready.
[ "sys", "ntile", 2, "bigint", "" ]
[ "sys", "ntile", 3, "boolean", "" ]
[ "sys", "ntile", 4, "boolean", "" ]
-[ "sys", "ntile", 0, "hugeint", "ntile" ]
-[ "sys", "ntile", 1, "any", "" ]
-[ "sys", "ntile", 2, "hugeint", "" ]
-[ "sys", "ntile", 3, "boolean", "" ]
-[ "sys", "ntile", 4, "boolean", "" ]
[ "sys", "octet_length", 0, "int", "nbytes" ]
[ "sys", "octet_length", 1, "char", "" ]
[ "sys", "octet_length", 0, "int", "nbytes" ]
@@ -1435,18 +1401,14 @@ Ready.
[ "sys", "prod", 1, "real", "" ]
[ "sys", "prod", 0, "double", "prod" ]
[ "sys", "prod", 1, "double", "" ]
-[ "sys", "prod", 0, "hugeint", "prod" ]
+[ "sys", "prod", 0, "bigint", "prod" ]
[ "sys", "prod", 1, "tinyint", "" ]
-[ "sys", "prod", 0, "hugeint", "prod" ]
+[ "sys", "prod", 0, "bigint", "prod" ]
[ "sys", "prod", 1, "smallint", "" ]
-[ "sys", "prod", 0, "hugeint", "prod" ]
+[ "sys", "prod", 0, "bigint", "prod" ]
[ "sys", "prod", 1, "int", "" ]
-[ "sys", "prod", 0, "hugeint", "prod" ]
+[ "sys", "prod", 0, "bigint", "prod" ]
[ "sys", "prod", 1, "bigint", "" ]
-[ "sys", "prod", 0, "hugeint", "prod" ]
-[ "sys", "prod", 1, "hugeint", "" ]
-[ "sys", "prod", 0, "decimal", "prod" ]
-[ "sys", "prod", 1, "decimal", "" ]
[ "sys", "prod", 0, "decimal", "prod" ]
[ "sys", "prod", 1, "decimal", "" ]
[ "sys", "prod", 0, "decimal", "prod" ]
@@ -4516,18 +4478,14 @@ Ready.
[ "sys", "sum", 1, "month_interval", "" ]
[ "sys", "sum", 0, "sec_interval", "sum" ]
[ "sys", "sum", 1, "sec_interval", "" ]
-[ "sys", "sum", 0, "hugeint", "sum" ]
+[ "sys", "sum", 0, "bigint", "sum" ]
[ "sys", "sum", 1, "tinyint", "" ]
-[ "sys", "sum", 0, "hugeint", "sum" ]
+[ "sys", "sum", 0, "bigint", "sum" ]
[ "sys", "sum", 1, "smallint", "" ]
-[ "sys", "sum", 0, "hugeint", "sum" ]
+[ "sys", "sum", 0, "bigint", "sum" ]
[ "sys", "sum", 1, "int", "" ]
-[ "sys", "sum", 0, "hugeint", "sum" ]
+[ "sys", "sum", 0, "bigint", "sum" ]
[ "sys", "sum", 1, "bigint", "" ]
-[ "sys", "sum", 0, "hugeint", "sum" ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
