Changeset: ff40f1a3e3f4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ff40f1a3e3f4 Modified Files: clients/Tests/exports.stable.out gdk/gdk.h gdk/gdk_bat.c monetdb5/mal/mal.h sql/backends/monet5/UDF/capi/capi.c sql/backends/monet5/rel_bin.c sql/backends/monet5/sql_execute.c sql/backends/monet5/sql_rank.c sql/backends/monet5/sql_scenario.c sql/server/rel_optimize_proj.c sql/server/rel_optimize_sel.c sql/server/rel_rel.h sql/server/rel_rewriter.h sql/server/rel_select.c sql/server/rel_unnest.c sql/server/sql_parser.y sql/server/sql_var.c Branch: resource_management Log Message:
merge with default diffs (truncated from 118863 to 300 lines): diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -923,6 +923,7 @@ sed -i 's/1\.2/1.1/' misc/selinux/monetd -DWITH_PCRE=ON \ -DWITH_PROJ=OFF \ -DWITH_READLINE=ON \ + -DWITH_RTREE=OFF \ -DWITH_SQLPARSE=OFF \ -DWITH_VALGRIND=OFF \ -DWITH_XML2=ON \ diff --git a/clients/Tests/MAL-signatures-hge.test b/clients/Tests/MAL-signatures-hge.test --- a/clients/Tests/MAL-signatures-hge.test +++ b/clients/Tests/MAL-signatures-hge.test @@ -6,50881 +6,50876 @@ select * from sys.malfunctions() order b aggr Collect command aggr.Collect(X_0:bat[:wkb]):wkb -wkbCollectAggr; +wkbCollectAggr TODO aggr MakeLine command aggr.MakeLine(X_0:bat[:wkb]):wkb -wkbMakeLineAggr; +wkbMakeLineAggr Gets a BAT with point or linestring geometries and returns a single linestring geometry aggr all command aggr.all(X_0:bat[:any_1]):any_1 -SQLall; +SQLall if all values in b are equal return this, else nil aggr allnotequal pattern aggr.allnotequal(X_0:bat[:any_1], X_1:bat[:any_1]):bit -SQLallnotequal; +SQLallnotequal if all values in r are not equal to l, return true, else if r has nil, return nil, else return false aggr anyequal pattern aggr.anyequal(X_0:any_1, X_1:any_1):bit -CMDvarEQ; +CMDvarEQ (empty) aggr anyequal pattern aggr.anyequal(X_0:bat[:any_1], X_1:bat[:any_1]):bit -SQLanyequal; +SQLanyequal if any value in r is equal to l, return true, else if r has nil, return nil, else return false aggr avg command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] -AGGRavg13_dbl; +AGGRavg13_dbl Grouped tail average on bte aggr avg command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] -AGGRavg13_dbl; +AGGRavg13_dbl Grouped tail average on dbl aggr avg command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] -AGGRavg13_dbl; +AGGRavg13_dbl Grouped tail average on flt aggr avg command aggr.avg(X_0:bat[:hge], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] -AGGRavg13_dbl; +AGGRavg13_dbl Grouped tail average on hge aggr avg command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] -AGGRavg13_dbl; +AGGRavg13_dbl Grouped tail average on int aggr avg command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] -AGGRavg13_dbl; +AGGRavg13_dbl Grouped tail average on lng aggr avg command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1]):bat[:dbl] -AGGRavg13_dbl; +AGGRavg13_dbl Grouped tail average on sht aggr avg command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] -AGGRavg14_dbl; +AGGRavg14_dbl Grouped tail average on bte aggr avg command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] -AGGRavg14_dbl; +AGGRavg14_dbl Grouped tail average on dbl aggr avg command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] -AGGRavg14_dbl; +AGGRavg14_dbl Grouped tail average on flt aggr avg command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] -AGGRavg14_dbl; +AGGRavg14_dbl Grouped tail average on int aggr avg command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] -AGGRavg14_dbl; +AGGRavg14_dbl Grouped tail average on lng aggr avg command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1], X_3:int):bat[:dbl] -AGGRavg14_dbl; +AGGRavg14_dbl Grouped tail average on sht aggr avg command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) -AGGRavg23_dbl; +AGGRavg23_dbl Grouped tail average on bte, also returns count aggr avg command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) -AGGRavg23_dbl; +AGGRavg23_dbl Grouped tail average on dbl, also returns count aggr avg command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) -AGGRavg23_dbl; +AGGRavg23_dbl Grouped tail average on flt, also returns count aggr avg command aggr.avg(X_0:bat[:hge], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) -AGGRavg23_dbl; +AGGRavg23_dbl Grouped tail average on hge, also returns count aggr avg command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) -AGGRavg23_dbl; +AGGRavg23_dbl Grouped tail average on int, also returns count aggr avg command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) -AGGRavg23_dbl; +AGGRavg23_dbl Grouped tail average on lng, also returns count aggr avg command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1]) (X_3:bat[:dbl], X_4:bat[:lng]) -AGGRavg23_dbl; +AGGRavg23_dbl Grouped tail average on sht, also returns count aggr avg command aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) -AGGRavg24_dbl; +AGGRavg24_dbl Grouped tail average on bte, also returns count aggr avg command aggr.avg(X_0:bat[:dbl], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) -AGGRavg24_dbl; +AGGRavg24_dbl Grouped tail average on dbl, also returns count aggr avg command aggr.avg(X_0:bat[:flt], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) -AGGRavg24_dbl; +AGGRavg24_dbl Grouped tail average on flt, also returns count aggr avg command aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) -AGGRavg24_dbl; +AGGRavg24_dbl Grouped tail average on int, also returns count aggr avg command aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) -AGGRavg24_dbl; +AGGRavg24_dbl Grouped tail average on lng, also returns count aggr avg command aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bat[:any_1], X_3:int) (X_4:bat[:dbl], X_5:bat[:lng]) -AGGRavg24_dbl; +AGGRavg24_dbl Grouped tail average on sht, also returns count aggr avg pattern aggr.avg(X_0:bat[:bte], X_1:bat[:oid], X_2:bit) (X_3:bte, X_4:lng, X_5:lng) -CMDBATavg3; +CMDBATavg3 Calculate aggregate average of B. aggr avg pattern aggr.avg(X_0:bat[:hge], X_1:bat[:oid], X_2:bit) (X_3:hge, X_4:lng, X_5:lng) -CMDBATavg3; +CMDBATavg3 Calculate aggregate average of B. aggr avg pattern aggr.avg(X_0:bat[:int], X_1:bat[:oid], X_2:bit) (X_3:int, X_4:lng, X_5:lng) -CMDBATavg3; +CMDBATavg3 Calculate aggregate average of B. aggr avg pattern aggr.avg(X_0:bat[:lng], X_1:bat[:oid], X_2:bit) (X_3:lng, X_4:lng, X_5:lng) -CMDBATavg3; +CMDBATavg3 Calculate aggregate average of B. aggr avg pattern aggr.avg(X_0:bat[:sht], X_1:bat[:oid], X_2:bit) (X_3:sht, X_4:lng, X_5:lng) -CMDBATavg3; +CMDBATavg3 Calculate aggregate average of B. aggr avg pattern aggr.avg(X_0:bat[:bte], X_1:bat[:lng], X_2:bat[:lng]):bte -CMDBATavg3comb; +CMDBATavg3comb Average aggregation combiner. aggr avg pattern aggr.avg(X_0:bat[:hge], X_1:bat[:lng], X_2:bat[:lng]):hge -CMDBATavg3comb; +CMDBATavg3comb Average aggregation combiner. aggr avg pattern aggr.avg(X_0:bat[:int], X_1:bat[:lng], X_2:bat[:lng]):int -CMDBATavg3comb; +CMDBATavg3comb Average aggregation combiner. aggr avg pattern aggr.avg(X_0:bat[:lng], X_1:bat[:lng], X_2:bat[:lng]):lng -CMDBATavg3comb; +CMDBATavg3comb Average aggregation combiner. aggr avg pattern aggr.avg(X_0:bat[:sht], X_1:bat[:lng], X_2:bat[:lng]):sht -CMDBATavg3comb; +CMDBATavg3comb Average aggregation combiner. aggr avg pattern aggr.avg(X_0:bat[:any_1]):dbl -CMDcalcavg; +CMDcalcavg Gives the avg of all tail values aggr avg pattern aggr.avg(X_0:bat[:any_1], X_1:int):dbl -CMDcalcavg; +CMDcalcavg Gives the avg of all tail values aggr cardinality command aggr.cardinality(X_0:bat[:any_2]):lng -ALGcard; +ALGcard Return the cardinality of the BAT tail values. aggr corr command aggr.corr(X_0:bat[:bte], X_1:bat[:bte], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] -AGGRcorr; +AGGRcorr Correlation aggregate aggr corr command aggr.corr(X_0:bat[:dbl], X_1:bat[:dbl], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] -AGGRcorr; +AGGRcorr Correlation aggregate aggr corr command aggr.corr(X_0:bat[:flt], X_1:bat[:flt], X_2:bat[:oid], X_3:bat[:any_1]):bat[:dbl] _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org