Changeset: dc1af5e89989 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dc1af5e89989 Added Files: sql/test/BugTracker-2016/Tests/querylog.stable.err sql/test/BugTracker-2016/Tests/querylog.stable.out sql/test/bugs/Tests/filter_error.sql sql/test/bugs/Tests/filter_error.stable.err sql/test/bugs/Tests/filter_error.stable.out Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/SQL-dump.stable.out clients/Tests/exports.stable.out common/stream/stream.h gdk/gdk.h gdk/gdk_utils.c monetdb5/mal/mal.h monetdb5/mal/mal_exception.c monetdb5/mal/mal_exception.h monetdb5/mal/mal_instruction.c monetdb5/mal/mal_instruction.h monetdb5/mal/mal_interpreter.c monetdb5/mal/mal_interpreter.h monetdb5/mal/mal_listing.c monetdb5/mal/mal_scenario.c monetdb5/mal/mal_session.c monetdb5/mal/mal_type.h monetdb5/modules/atoms/xml.c monetdb5/modules/mal/tablet.c sql/backends/monet5/UDF/cudf/Tests/udf-fuse.stable.out sql/backends/monet5/UDF/cudf/Tests/udf-reverse.stable.out sql/backends/monet5/sql_result.c sql/benchmarks/ssbm/Tests/01-explain.stable.out sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/02-explain.stable.out sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/03-explain.stable.out sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/10-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/11-explain.stable.out sql/benchmarks/ssbm/Tests/11-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/12-explain.stable.out sql/benchmarks/ssbm/Tests/12-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/13-explain.stable.out sql/benchmarks/ssbm/Tests/13-explain.stable.out.int128 sql/benchmarks/tpch/Tests/01-explain.stable.out.int128 sql/benchmarks/tpch/Tests/02-explain.stable.out sql/benchmarks/tpch/Tests/03-explain.stable.out.int128 sql/benchmarks/tpch/Tests/04-explain.stable.out sql/benchmarks/tpch/Tests/05-explain.stable.out.int128 sql/benchmarks/tpch/Tests/06-explain.stable.out.int128 sql/benchmarks/tpch/Tests/07-explain.stable.out.int128 sql/benchmarks/tpch/Tests/08-explain.stable.out.int128 sql/benchmarks/tpch/Tests/09-explain.stable.out.int128 sql/benchmarks/tpch/Tests/10-explain.stable.out.int128 sql/benchmarks/tpch/Tests/11-explain.stable.out.int128 sql/benchmarks/tpch/Tests/12-explain.stable.out.int128 sql/benchmarks/tpch/Tests/13-explain.stable.out sql/benchmarks/tpch/Tests/14-explain.stable.out.int128 sql/benchmarks/tpch/Tests/15-explain.stable.out.int128 sql/benchmarks/tpch/Tests/16-explain.stable.out sql/benchmarks/tpch/Tests/17-explain.stable.out.int128 sql/benchmarks/tpch/Tests/18-explain.stable.out.int128 sql/benchmarks/tpch/Tests/19-explain.stable.out.int128 sql/benchmarks/tpch/Tests/20-explain.stable.out.int128 sql/benchmarks/tpch/Tests/21-explain.stable.out sql/benchmarks/tpch/Tests/22-explain.stable.out.int128 sql/scripts/26_sysmon.sql sql/server/rel_select.c sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128 sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128 sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out sql/test/BugTracker-2016/Tests/All sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out sql/test/BugTracker/Tests/explain.SF-1739353.stable.out sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out sql/test/bugs/Tests/All sql/test/mergetables/Tests/mergequery.stable.out sql/test/remote/Tests/partition_elim.stable.out testing/MkillUsers.in testing/Mtest.py.in testing/listexports.py.in tools/merovingian/daemon/argvcmds.c tools/merovingian/daemon/controlrunner.c tools/merovingian/daemon/discoveryrunner.c tools/merovingian/daemon/merovingian.c tools/merovingian/utils/utils.c tools/merovingian/utils/utils.h Branch: sfcgal Log Message:
Merge diffs (truncated from 9331 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 @@ -20,7 +20,7 @@ Ready. # 17:25:33 > "mclient" "-lmal" "-ftest" "-Eutf-8" "--host=/var/tmp/mtest-25210" "--port=34276" # 17:25:33 > -command aggr.avg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1]) (X_4:bat[:dbl],X_5:bat[:lng]) +command aggr.avg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRavg23_dbl; comment Grouped tail average on dbl, also returns count @@ -28,7 +28,7 @@ command aggr.avg(b:bat[:dbl],g:bat[:oid] address AGGRavg13_dbl; comment Grouped tail average on dbl -command aggr.avg(b:bat[:flt],g:bat[:oid],e:bat[:any_1]) (X_4:bat[:dbl],X_5:bat[:lng]) +command aggr.avg(b:bat[:flt],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRavg23_dbl; comment Grouped tail average on flt, also returns count @@ -36,7 +36,7 @@ command aggr.avg(b:bat[:flt],g:bat[:oid] address AGGRavg13_dbl; comment Grouped tail average on flt -command aggr.avg(b:bat[:lng],g:bat[:oid],e:bat[:any_1]) (X_4:bat[:dbl],X_5:bat[:lng]) +command aggr.avg(b:bat[:lng],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRavg23_dbl; comment Grouped tail average on lng, also returns count @@ -44,7 +44,7 @@ command aggr.avg(b:bat[:lng],g:bat[:oid] address AGGRavg13_dbl; comment Grouped tail average on lng -command aggr.avg(b:bat[:int],g:bat[:oid],e:bat[:any_1]) (X_4:bat[:dbl],X_5:bat[:lng]) +command aggr.avg(b:bat[:int],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRavg23_dbl; comment Grouped tail average on int, also returns count @@ -52,7 +52,7 @@ command aggr.avg(b:bat[:int],g:bat[:oid] address AGGRavg13_dbl; comment Grouped tail average on int -command aggr.avg(b:bat[:sht],g:bat[:oid],e:bat[:any_1]) (X_4:bat[:dbl],X_5:bat[:lng]) +command aggr.avg(b:bat[:sht],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRavg23_dbl; comment Grouped tail average on sht, also returns count @@ -60,7 +60,7 @@ command aggr.avg(b:bat[:sht],g:bat[:oid] address AGGRavg13_dbl; comment Grouped tail average on sht -command aggr.avg(b:bat[:bte],g:bat[:oid],e:bat[:any_1]) (X_4:bat[:dbl],X_5:bat[:lng]) +command aggr.avg(b:bat[:bte],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRavg23_dbl; comment Grouped tail average on bte, also returns count @@ -868,11 +868,11 @@ command aggr.stdev(b:bat[:dbl],g:bat[:oi address AGGRstdev3_dbl; comment Grouped tail standard deviation (sample/non-biased) on dbl -command aggr.subavg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_7:bat[:dbl],X_8:bat[:lng]) +command aggr.subavg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRsubavg2cand_dbl; comment Grouped average aggregate with candidates list, also returns count -command aggr.subavg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_6:bat[:dbl],X_7:bat[:lng]) +command aggr.subavg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRsubavg2_dbl; comment Grouped average aggregate, also returns count @@ -924,11 +924,11 @@ command aggr.stdev(b:bat[:flt],g:bat[:oi address AGGRstdev3_dbl; comment Grouped tail standard deviation (sample/non-biased) on flt -command aggr.subavg(b:bat[:flt],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_7:bat[:dbl],X_8:bat[:lng]) +command aggr.subavg(b:bat[:flt],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRsubavg2cand_dbl; comment Grouped average aggregate with candidates list, also returns count -command aggr.subavg(b:bat[:flt],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_6:bat[:dbl],X_7:bat[:lng]) +command aggr.subavg(b:bat[:flt],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRsubavg2_dbl; comment Grouped average aggregate, also returns count @@ -980,11 +980,11 @@ command aggr.stdev(b:bat[:lng],g:bat[:oi address AGGRstdev3_dbl; comment Grouped tail standard deviation (sample/non-biased) on lng -command aggr.subavg(b:bat[:lng],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_7:bat[:dbl],X_8:bat[:lng]) +command aggr.subavg(b:bat[:lng],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRsubavg2cand_dbl; comment Grouped average aggregate with candidates list, also returns count -command aggr.subavg(b:bat[:lng],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_6:bat[:dbl],X_7:bat[:lng]) +command aggr.subavg(b:bat[:lng],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRsubavg2_dbl; comment Grouped average aggregate, also returns count @@ -1036,11 +1036,11 @@ command aggr.stdev(b:bat[:int],g:bat[:oi address AGGRstdev3_dbl; comment Grouped tail standard deviation (sample/non-biased) on int -command aggr.subavg(b:bat[:int],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_7:bat[:dbl],X_8:bat[:lng]) +command aggr.subavg(b:bat[:int],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRsubavg2cand_dbl; comment Grouped average aggregate with candidates list, also returns count -command aggr.subavg(b:bat[:int],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_6:bat[:dbl],X_7:bat[:lng]) +command aggr.subavg(b:bat[:int],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRsubavg2_dbl; comment Grouped average aggregate, also returns count @@ -1092,11 +1092,11 @@ command aggr.stdev(b:bat[:sht],g:bat[:oi address AGGRstdev3_dbl; comment Grouped tail standard deviation (sample/non-biased) on sht -command aggr.subavg(b:bat[:sht],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_7:bat[:dbl],X_8:bat[:lng]) +command aggr.subavg(b:bat[:sht],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRsubavg2cand_dbl; comment Grouped average aggregate with candidates list, also returns count -command aggr.subavg(b:bat[:sht],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_6:bat[:dbl],X_7:bat[:lng]) +command aggr.subavg(b:bat[:sht],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRsubavg2_dbl; comment Grouped average aggregate, also returns count @@ -1148,11 +1148,11 @@ command aggr.stdev(b:bat[:bte],g:bat[:oi address AGGRstdev3_dbl; comment Grouped tail standard deviation (sample/non-biased) on bte -command aggr.subavg(b:bat[:bte],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_7:bat[:dbl],X_8:bat[:lng]) +command aggr.subavg(b:bat[:bte],g:bat[:oid],e:bat[:any_1],s:bat[:oid],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRsubavg2cand_dbl; comment Grouped average aggregate with candidates list, also returns count -command aggr.subavg(b:bat[:bte],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_6:bat[:dbl],X_7:bat[:lng]) +command aggr.subavg(b:bat[:bte],g:bat[:oid],e:bat[:any_1],skip_nils:bit,abort_on_error:bit) (X_0:bat[:dbl],X_1:bat[:lng]) address AGGRsubavg2_dbl; comment Grouped average aggregate, also returns count @@ -1516,15 +1516,15 @@ command algebra.exist(b:bat[:any_1],val: address ALGexist; comment Returns whether 'val' occurs in b. -pattern algebra.firstn(b:bat[:any],s:bat[:oid],g:bat[:oid],n:lng,asc:bit,distinct:bit) (X_7:bat[:oid],X_8:bat[:oid]) +pattern algebra.firstn(b:bat[:any],s:bat[:oid],g:bat[:oid],n:lng,asc:bit,distinct:bit) (X_0:bat[:oid],X_1:bat[:oid]) address ALGfirstn; comment Calculate first N values of B with candidate list S -pattern algebra.firstn(b:bat[:any],s:bat[:oid],n:lng,asc:bit,distinct:bit) (X_6:bat[:oid],X_7:bat[:oid]) +pattern algebra.firstn(b:bat[:any],s:bat[:oid],n:lng,asc:bit,distinct:bit) (X_0:bat[:oid],X_1:bat[:oid]) address ALGfirstn; comment Calculate first N values of B with candidate list S -pattern algebra.firstn(b:bat[:any],n:lng,asc:bit,distinct:bit) (X_5:bat[:oid],X_6:bat[:oid]) +pattern algebra.firstn(b:bat[:any],n:lng,asc:bit,distinct:bit) (X_0:bat[:oid],X_1:bat[:oid]) address ALGfirstn; comment Calculate first N values of B @@ -1552,9 +1552,9 @@ command algebra.groupby(gids:bat[:oid],c address ALGgroupby; comment Produces a new BAT with groups identified by the head column. The result contains tail times the head value, ie the tail contains the result group sizes. -command algebra.ilikesubjoin(l:bat[:str],r:bat[:str],sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_7:bat[:oid],X_8:bat[:oid]) +command algebra.ilikesubjoin(l:bat[:str],r:bat[:str],sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_0:bat[:oid],X_1:bat[:oid]) address ILIKEsubjoin1; -command algebra.ilikesubjoin(l:bat[:str],r:bat[:str],esc:str,sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_8:bat[:oid],X_9:bat[:oid]) +command algebra.ilikesubjoin(l:bat[:str],r:bat[:str],esc:str,sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_0:bat[:oid],X_1:bat[:oid]) address ILIKEsubjoin; comment Join the string bat L with the pattern bat Rwith optional candidate lists SL and SR using pattern escape string ESCand doing a case insensitive match.The result is two aligned bats with oids of matching rows. @@ -1566,9 +1566,9 @@ command algebra.ilike(s:str,pat:str):bit address PCREilike2; command algebra.ilike(s:str,pat:str,esc:str):bit address PCREilike3; -command algebra.likesubjoin(l:bat[:str],r:bat[:str],sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_7:bat[:oid],X_8:bat[:oid]) +command algebra.likesubjoin(l:bat[:str],r:bat[:str],sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_0:bat[:oid],X_1:bat[:oid]) address LIKEsubjoin1; -command algebra.likesubjoin(l:bat[:str],r:bat[:str],esc:str,sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_8:bat[:oid],X_9:bat[:oid]) +command algebra.likesubjoin(l:bat[:str],r:bat[:str],esc:str,sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_0:bat[:oid],X_1:bat[:oid]) address LIKEsubjoin; comment Join the string bat L with the pattern bat Rwith optional candidate lists SL and SR using pattern escape string ESCand doing a case sensitive match.The result is two aligned bats with oids of matching rows. @@ -1640,32 +1640,32 @@ command algebra.subdiff(l:bat[:any_1],r: address ALGsubdiff; comment Difference of l and r with candidate lists -command algebra.subrangejoin(l:bat[:any_1],r1:bat[:any_1],r2:bat[:any_1],sl:bat[:oid],sr:bat[:oid],li:bit,hi:bit,estimate:lng) (X_9:bat[:oid],X_10:bat[:oid]) +command algebra.subrangejoin(l:bat[:any_1],r1:bat[:any_1],r2:bat[:any_1],sl:bat[:oid],sr:bat[:oid],li:bit,hi:bit,estimate:lng) (X_0:bat[:oid],X_1:bat[:oid]) address ALGsubrangejoin; comment Range join: values in l and r1/r2 match if r1 <[=] l <[=] r2 -command algebra.subbandjoin(l:bat[:any_1],r:bat[:any_1],sl:bat[:oid],sr:bat[:oid],c1:any_1,c2:any_1,li:bit,hi:bit,estimate:lng) (X_10:bat[:oid],X_11:bat[:oid]) +command algebra.subbandjoin(l:bat[:any_1],r:bat[:any_1],sl:bat[:oid],sr:bat[:oid],c1:any_1,c2:any_1,li:bit,hi:bit,estimate:lng) (X_0:bat[:oid],X_1:bat[:oid]) address ALGsubbandjoin; comment Band join: values in l and r match if r - c1 <[=] l <[=] r + c2 -function algebra.subantijoin(l:bat[:any_1],r:bat[:any_1],sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_7:bat[:oid],X_8:bat[:oid]); -command algebra.subthetajoin(l:bat[:any_1],r:bat[:any_1],sl:bat[:oid],sr:bat[:oid],op:int,nil_matches:bit,estimate:lng) (X_8:bat[:oid],X_9:bat[:oid]) +function algebra.subantijoin(l:bat[:any_1],r:bat[:any_1],sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_0:bat[:oid],X_1:bat[:oid]); +command algebra.subthetajoin(l:bat[:any_1],r:bat[:any_1],sl:bat[:oid],sr:bat[:oid],op:int,nil_matches:bit,estimate:lng) (X_0:bat[:oid],X_1:bat[:oid]) address ALGsubthetajoin; comment Theta join with candidate lists -command algebra.subsemijoin(l:bat[:any_1],r:bat[:any_1],sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_7:bat[:oid],X_8:bat[:oid]) +command algebra.subsemijoin(l:bat[:any_1],r:bat[:any_1],sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_0:bat[:oid],X_1:bat[:oid]) address ALGsubsemijoin; comment Semi join with candidate lists -command algebra.subouterjoin(l:bat[:any_1],r:bat[:any_1],sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_7:bat[:oid],X_8:bat[:oid]) +command algebra.subouterjoin(l:bat[:any_1],r:bat[:any_1],sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_0:bat[:oid],X_1:bat[:oid]) address ALGsubouterjoin; comment Left outer join with candidate lists -command algebra.subleftjoin(l:bat[:any_1],r:bat[:any_1],sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_7:bat[:oid],X_8:bat[:oid]) +command algebra.subleftjoin(l:bat[:any_1],r:bat[:any_1],sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_0:bat[:oid],X_1:bat[:oid]) address ALGsubleftjoin; comment Left join with candidate lists -command algebra.subjoin(l:bat[:any_1],r:bat[:any_1],sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_7:bat[:oid],X_8:bat[:oid]) +command algebra.subjoin(l:bat[:any_1],r:bat[:any_1],sl:bat[:oid],sr:bat[:oid],nil_matches:bit,estimate:lng) (X_0:bat[:oid],X_1:bat[:oid]) address ALGsubjoin; comment Join @@ -1677,11 +1677,11 @@ command algebra.subunique(b:bat[:any_1], address ALGsubunique2; comment Select all unique values from the tail of the first input. Input is a dense-headed BAT, the second input is a dense-headed BAT with sorted tail, output is a dense-headed BAT with in the tail the head value of the input BAT that was selected. The output BAT is sorted on the tail value. The second input BAT is a list of candidates. -command algebra.subsort(b:bat[:any_1],o:bat[:oid],g:bat[:oid],reverse:bit,stable:bit) (X_6:bat[:any_1],X_7:bat[:oid],X_8:bat[:oid]) +command algebra.subsort(b:bat[:any_1],o:bat[:oid],g:bat[:oid],reverse:bit,stable:bit) (X_0:bat[:any_1],X_1:bat[:oid],X_2:bat[:oid]) address ALGsubsort33; comment Returns a copy of the BAT sorted on tail values, a BAT that specifies how the input was reordered, and a BAT with group information. The input and output are (must be) dense headed. The order is descending if the reverse bit is set. This is a stable sort if the stable bit is set. -command algebra.subsort(b:bat[:any_1],o:bat[:oid],g:bat[:oid],reverse:bit,stable:bit) (X_6:bat[:any_1],X_7:bat[:oid]) +command algebra.subsort(b:bat[:any_1],o:bat[:oid],g:bat[:oid],reverse:bit,stable:bit) (X_0:bat[:any_1],X_1:bat[:oid]) address ALGsubsort32; comment Returns a copy of the BAT sorted on tail values and a BAT that specifies how the input was reordered. The input and output are (must be) dense headed. The order is descending if the reverse bit is set. This is a stable sort if the stable bit is set. @@ -1689,11 +1689,11 @@ command algebra.subsort(b:bat[:any_1],o: address ALGsubsort31; comment Returns a copy of the BAT sorted on tail values. The input and output are (must be) dense headed. The order is descending if the reverse bit is set. This is a stable sort if the stable bit is set. -command algebra.subsort(b:bat[:any_1],o:bat[:oid],reverse:bit,stable:bit) (X_5:bat[:any_1],X_6:bat[:oid],X_7:bat[:oid]) +command algebra.subsort(b:bat[:any_1],o:bat[:oid],reverse:bit,stable:bit) (X_0:bat[:any_1],X_1:bat[:oid],X_2:bat[:oid]) address ALGsubsort23; comment Returns a copy of the BAT sorted on tail values, a BAT that specifies how the input was reordered, and a BAT with group information. The input and output are (must be) dense headed. The order is descending if the reverse bit is set. This is a stable sort if the stable bit is set. -command algebra.subsort(b:bat[:any_1],o:bat[:oid],reverse:bit,stable:bit) (X_5:bat[:any_1],X_6:bat[:oid]) +command algebra.subsort(b:bat[:any_1],o:bat[:oid],reverse:bit,stable:bit) (X_0:bat[:any_1],X_1:bat[:oid]) address ALGsubsort22; comment Returns a copy of the BAT sorted on tail values and a BAT that specifies how the input was reordered. The input and output are (must be) dense headed. The order is descending if the reverse bit is set. This is a stable sort if the stable bit is set. @@ -1701,11 +1701,11 @@ command algebra.subsort(b:bat[:any_1],o: address ALGsubsort21; comment Returns a copy of the BAT sorted on tail values. The input and output are (must be) dense headed. The order is descending if the reverse bit is set. This is a stable sort if the stable bit is set. -command algebra.subsort(b:bat[:any_1],reverse:bit,stable:bit) (X_4:bat[:any_1],X_5:bat[:oid],X_6:bat[:oid]) +command algebra.subsort(b:bat[:any_1],reverse:bit,stable:bit) (X_0:bat[:any_1],X_1:bat[:oid],X_2:bat[:oid]) address ALGsubsort13; comment Returns a copy of the BAT sorted on tail values, a BAT that specifies how the input was reordered, and a BAT with group information. The input and output are (must be) dense headed. The order is descending if the reverse bit is set. This is a stable sort if the stable bit is set. -command algebra.subsort(b:bat[:any_1],reverse:bit,stable:bit) (X_4:bat[:any_1],X_5:bat[:oid]) +command algebra.subsort(b:bat[:any_1],reverse:bit,stable:bit) (X_0:bat[:any_1],X_1:bat[:oid]) address ALGsubsort12; comment Returns a copy of the BAT sorted on tail values and a BAT that specifies how the input was reordered. The input and output are (must be) dense headed. The order is descending if the reverse bit is set. This is a stable sort if the stable bit is set. @@ -2080,15 +2080,15 @@ function batgeom.YMaxFromWKB(g:bat[:wkb] function batgeom.YMinFromWKB(g:bat[:wkb]):bat[:dbl]; function batgeom.Y(w:bat[:wkb]):bat[:dbl]; function batgeom.Z(w:bat[:wkb]):bat[:dbl]; -command batgeom.coordinateFromMBR(X_1:bat[:mbr],X_2:int):bat[:dbl] +command batgeom.coordinateFromMBR(X_0:bat[:mbr],X_1:int):bat[:dbl] address wkbCoordinateFromMBR_bat; comment returns xmin (=1), ymin (=2), xmax (=3) or ymax(=4) of the provided mbr -command batgeom.coordinateFromWKB(X_1:bat[:wkb],X_2:int):bat[:dbl] +command batgeom.coordinateFromWKB(X_0:bat[:wkb],X_1:int):bat[:dbl] address wkbCoordinateFromWKB_bat; comment returns xmin (=1), ymin (=2), xmax (=3) or ymax(=4) of the provided geometry -command batgeom.mbr(X_1:bat[:wkb]):bat[:mbr] +command batgeom.mbr(X_0:bat[:wkb]):bat[:mbr] address wkbMBR_bat; comment Creates the mbr for the given wkb. @@ -15178,11 +15178,11 @@ pattern batcalc.>(b1:bat[:uuid],b2:bat[: address CMDbatGT; comment Return B1 > B2 -pattern batcalc.avg(b:bat[:dbl],s:bat[:oid]) (X_3:dbl,X_4:lng) +pattern batcalc.avg(b:bat[:dbl],s:bat[:oid]) (X_0:dbl,X_1:lng) address CMDcalcavg; comment average and number of non-nil values of B with candidates list -pattern batcalc.avg(b:bat[:dbl]) (X_2:dbl,X_3:lng) +pattern batcalc.avg(b:bat[:dbl]) (X_0:dbl,X_1:lng) address CMDcalcavg; comment average and number of non-nil values of B _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list