Changeset: 62eb163bc938 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/62eb163bc938
Modified Files:
clients/Tests/MAL-signatures-hge.test
clients/Tests/MAL-signatures.test
clients/Tests/exports.stable.out
sql/backends/monet5/rel_bin.c
sql/server/CMakeLists.txt
sql/server/rel_rel.h
sql/server/rel_select.c
sql/server/sql_parser.y
sql/test/BugTracker-2024/Tests/7425-pkey-check-failed.test
sql/test/BugTracker-2024/Tests/7426-inequality-hash-issue.test
sql/test/BugTracker-2024/Tests/7428-where-between-issue.test
sql/test/BugTracker-2024/Tests/7429-where-case-null-issue.test
sql/test/BugTracker-2024/Tests/7430-create-index-query-issue.test
sql/test/BugTracker-2024/Tests/7432-alloc-overflow.test
sql/test/BugTracker-2024/Tests/7433-rewrite-count-crash.test
sql/test/BugTracker-2024/Tests/7434-exp-bin-crash.test
sql/test/BugTracker-2024/Tests/7435-aggr-exp-copy-crash.test
sql/test/BugTracker-2024/Tests/7436-count-unnest-crash.test
sql/test/BugTracker-2024/Tests/7437-add-partition-crash.test
sql/test/BugTracker-2024/Tests/7438-bind-exps-crash.test
sql/test/BugTracker-2024/Tests/7439-exps-cards-crash.test
sql/test/BugTracker-2024/Tests/7440-gc-col-crash.test
sql/test/BugTracker-2024/Tests/7441-is-col-uniq-crash.test
sql/test/BugTracker-2024/Tests/7442-unaligned_mats.test
sql/test/BugTracker-2024/Tests/7443-recursive-merge-table-crash.test
sql/test/BugTracker-2024/Tests/7444-greatest-as-colname.test
sql/test/BugTracker-2024/Tests/7447-where-cond-issue.test
sql/test/BugTracker-2024/Tests/7448-where-cond-issue.test
sql/test/BugTracker-2024/Tests/7450-where_null.test
sql/test/BugTracker-2024/Tests/7451-between-boolean.test
sql/test/BugTracker-2024/Tests/7455-concat_order.test
sql/test/BugTracker-2024/Tests/7456-order-by-false-or-false.test
sql/test/BugTracker-2024/Tests/7457-constant-expression-issue.test
sql/test/BugTracker-2024/Tests/7458-sign-issue.test
sql/test/BugTracker-2024/Tests/7459-contains-between-issue.test
sql/test/BugTracker-2024/Tests/7460-push_select_exp-issue.test
sql/test/BugTracker-2024/Tests/7461-unicode-escape.test
sql/test/BugTracker-2024/Tests/7462-exp-bin.test
sql/test/BugTracker-2024/Tests/7463-contains-cast.test
sql/test/BugTracker-2024/Tests/7465-between-true-and-null.test
sql/test/BugTracker-2024/Tests/7466-inner-join-contains.test
sql/test/BugTracker-2024/Tests/7469-contains-or.test
sql/test/BugTracker-2024/Tests/7470-conversion-string-to-bte-failed.test
sql/test/BugTracker-2024/Tests/7472-groupby-select1.test
sql/test/BugTracker-2024/Tests/7473-SQLunionfunc.test
sql/test/BugTracker-2024/Tests/7474-VLTgenerator_table.test
sql/test/BugTracker-2024/Tests/7475-exp_equal.test
sql/test/BugTracker-2024/Tests/7476-rel2bin_join.test
sql/test/BugTracker-2024/Tests/7477-atom_cmp.test
sql/test/BugTracker-2024/Tests/7478-exp_equal.test
sql/test/BugTracker-2024/Tests/7479-exp_ref.test
sql/test/BugTracker-2024/Tests/7480-get_rel_count.test
sql/test/BugTracker-2024/Tests/7481-mvc_row_result_wrap.test
sql/test/BugTracker-2024/Tests/7482-bin_find_smallest_column.test
sql/test/BugTracker-2024/Tests/7483-rel_setop_get_statistics.test
sql/test/BugTracker-2024/Tests/7484-rel_groupby_cse.test
sql/test/BugTracker-2024/Tests/7485-rel_groupby_cse.test
sql/test/BugTracker-2024/Tests/7486-CMDgen_group.test
sql/test/BugTracker-2024/Tests/7487-sql_init_subtype.test
sql/test/BugTracker-2024/Tests/7488-orderby-max-over-rows.test
sql/test/BugTracker-2024/Tests/7496-rel2bin_select.test
sql/test/BugTracker-2024/Tests/7497-multicolumn_IN_value_list.test
sql/test/BugTracker-2024/Tests/7500-analyze-in-proc-func-trig-body.test
sql/test/BugTracker-2024/Tests/7503-merge-into-gh.test
sql/test/BugTracker-2024/Tests/7506-field-arg-error.test
testing/listexports.py
Branch: odbc_loader
Log Message:
Merge 'default' into 'odbc_loader'
diffs (truncated from 115018 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,47377 +6,47372 @@ 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
