Changeset: ddd40ae2fa64 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/ddd40ae2fa64
Modified Files:
sql/test/rel-optimizers/Tests/All
Branch: const_aggr_elim
Log Message:
Merges default
diffs (truncated from 111036 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 -- [email protected]
To unsubscribe send an email to [email protected]
