Changeset: 0a259b40fcb3 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0a259b40fcb3 Added Files: monetdb5/modules/kernel/00_aggr_hge.mal monetdb5/modules/kernel/00_aggr_hge.mal.sh monetdb5/modules/mal/00_batcalc_hge.mal monetdb5/modules/mal/00_batcalc_hge.mal.sh monetdb5/modules/mal/00_calc_hge.mal monetdb5/modules/mal/00_calc_hge.mal.sh monetdb5/modules/mal/00_cluster_hge.mal monetdb5/modules/mal/00_iterator_hge.mal monetdb5/modules/mal/00_language_hge.mal monetdb5/modules/mal/00_mal_mapi_hge.mal monetdb5/modules/mal/00_mkey_hge.mal monetdb5/modules/mal/00_pqueue_hge.mal sql/scripts/39_analytics_hge.sql Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/SQL-dump.stable.out monetdb5/modules/kernel/Makefile.ag monetdb5/modules/kernel/aggr.mal monetdb5/modules/kernel/aggr.mal.sh monetdb5/modules/mal/Makefile.ag monetdb5/modules/mal/batcalc.mal monetdb5/modules/mal/batcalc.mal.sh monetdb5/modules/mal/calc.mal monetdb5/modules/mal/calc.mal.sh monetdb5/modules/mal/cluster.mal monetdb5/modules/mal/iterator.mal monetdb5/modules/mal/language.mal monetdb5/modules/mal/mal_mapi.mal monetdb5/modules/mal/mkey.mal monetdb5/modules/mal/pqueue.mal sql/backends/monet5/Makefile.ag sql/backends/monet5/sql.mx sql/scripts/Makefile.ag sql/test/Tests/systemfunctions.stable.out sql/test/leaks/Tests/check1.stable.out sql/test/leaks/Tests/check2.stable.out sql/test/leaks/Tests/check3.stable.out sql/test/leaks/Tests/check4.stable.out sql/test/leaks/Tests/check5.stable.out sql/test/mapi/Tests/php_monetdb.stable.out Branch: int128 Log Message:
extract declaration of 128-bit (hge/HUGEINT) specific MAL & SQL signtatures into separate files that are installed & loaded conditionally only if there is support for 128-bit integers diffs (truncated from 93995 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 @@ -26,6 +26,22 @@ Ready. # 00:44:35 > #?*) +command aggr.avg(b:bat[:oid,:hge],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +address AGGRavg23_dbl; +comment Grouped tail average on hge, also returns count + +command aggr.avg(b:bat[:oid,:hge],e:bat[:oid,:any_1]) (X_3:bat[:oid,:dbl],X_4:bat[:oid,:wrd]) +address AGGRavg22_dbl; +comment Grouped tail average on hge, also returns count + +command aggr.avg(b:bat[:oid,:hge],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] +address AGGRavg13_dbl; +comment Grouped tail average on hge + +command aggr.avg(b:bat[:oid,:hge],e:bat[:oid,:any_1]):bat[:oid,:dbl] +address AGGRavg12_dbl; +comment Grouped tail average on hge + command aggr.avg(b:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) address AGGRavg23_dbl; comment Grouped tail average on dbl, also returns count @@ -58,22 +74,6 @@ command aggr.avg(b:bat[:oid,:flt],e:bat[ address AGGRavg12_dbl; comment Grouped tail average on flt -command aggr.avg(b:bat[:oid,:hge],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) -address AGGRavg23_dbl; -comment Grouped tail average on hge, also returns count - -command aggr.avg(b:bat[:oid,:hge],e:bat[:oid,:any_1]) (X_3:bat[:oid,:dbl],X_4:bat[:oid,:wrd]) -address AGGRavg22_dbl; -comment Grouped tail average on hge, also returns count - -command aggr.avg(b:bat[:oid,:hge],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg13_dbl; -comment Grouped tail average on hge - -command aggr.avg(b:bat[:oid,:hge],e:bat[:oid,:any_1]):bat[:oid,:dbl] -address AGGRavg12_dbl; -comment Grouped tail average on hge - command aggr.avg(b:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) address AGGRavg23_dbl; comment Grouped tail average on lng, also returns count @@ -158,6 +158,10 @@ command aggr.avg(b:bat[:any_1,:any_2]):d address ALGavg; comment Gives the avg of all tail values +function aggr.corr(e1:bat[:oid,:hge],e2:bat[:oid,:hge],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:hge]; +function aggr.covar(e1:bat[:oid,:hge],e2:bat[:oid,:hge],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:hge]; +function aggr.corr(e1:bat[:oid,:hge],e2:bat[:oid,:hge]):hge; +function aggr.covar(e1:bat[:oid,:hge],e2:bat[:oid,:hge]):hge; function aggr.corr(e1:bat[:oid,:dbl],e2:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:dbl]; function aggr.covar(e1:bat[:oid,:dbl],e2:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:dbl]; function aggr.corr(e1:bat[:oid,:dbl],e2:bat[:oid,:dbl]):dbl; @@ -166,10 +170,6 @@ function aggr.corr(e1:bat[:oid,:flt],e2: function aggr.covar(e1:bat[:oid,:flt],e2:bat[:oid,:flt],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:flt]; function aggr.corr(e1:bat[:oid,:flt],e2:bat[:oid,:flt]):flt; function aggr.covar(e1:bat[:oid,:flt],e2:bat[:oid,:flt]):flt; -function aggr.corr(e1:bat[:oid,:hge],e2:bat[:oid,:hge],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:hge]; -function aggr.covar(e1:bat[:oid,:hge],e2:bat[:oid,:hge],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:hge]; -function aggr.corr(e1:bat[:oid,:hge],e2:bat[:oid,:hge]):hge; -function aggr.covar(e1:bat[:oid,:hge],e2:bat[:oid,:hge]):hge; function aggr.corr(e1:bat[:oid,:lng],e2:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:lng]; function aggr.covar(e1:bat[:oid,:lng],e2:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:lng]; function aggr.corr(e1:bat[:oid,:lng],e2:bat[:oid,:lng]):lng; @@ -253,6 +253,534 @@ command aggr.min(b:bat[:any_1,:any_2]):a address ALGminany; comment Return the lowest tail value or nil. +pattern aggr.prod(b:bat[:oid,:dbl],s:bat[:oid,:oid],nil_if_empty:bit):dbl +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:dbl],s:bat[:oid,:oid]):dbl +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:dbl],nil_if_empty:bit):dbl +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:dbl]):dbl +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:flt],s:bat[:oid,:oid],nil_if_empty:bit):dbl +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:flt],s:bat[:oid,:oid]):dbl +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:flt],nil_if_empty:bit):dbl +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:flt]):dbl +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:flt],s:bat[:oid,:oid],nil_if_empty:bit):flt +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:flt],s:bat[:oid,:oid]):flt +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:flt],nil_if_empty:bit):flt +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:flt]):flt +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:lng],s:bat[:oid,:oid],nil_if_empty:bit):dbl +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:lng],s:bat[:oid,:oid]):dbl +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:lng],nil_if_empty:bit):dbl +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:lng]):dbl +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:lng],s:bat[:oid,:oid],nil_if_empty:bit):lng +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:lng],s:bat[:oid,:oid]):lng +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:lng],nil_if_empty:bit):lng +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:lng]):lng +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:wrd],s:bat[:oid,:oid],nil_if_empty:bit):dbl +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:wrd],s:bat[:oid,:oid]):dbl +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:wrd],nil_if_empty:bit):dbl +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:wrd]):dbl +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:wrd],s:bat[:oid,:oid],nil_if_empty:bit):lng +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:wrd],s:bat[:oid,:oid]):lng +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:wrd],nil_if_empty:bit):lng +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:wrd]):lng +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:wrd],s:bat[:oid,:oid],nil_if_empty:bit):wrd +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:wrd],s:bat[:oid,:oid]):wrd +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:wrd],nil_if_empty:bit):wrd +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:wrd]):wrd +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:int],s:bat[:oid,:oid],nil_if_empty:bit):dbl +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:int],s:bat[:oid,:oid]):dbl +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:int],nil_if_empty:bit):dbl +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:int]):dbl +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:int],s:bat[:oid,:oid],nil_if_empty:bit):lng +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:int],s:bat[:oid,:oid]):lng +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:int],nil_if_empty:bit):lng +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:int]):lng +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:int],s:bat[:oid,:oid],nil_if_empty:bit):wrd +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:int],s:bat[:oid,:oid]):wrd +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:int],nil_if_empty:bit):wrd +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:int]):wrd +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:int],s:bat[:oid,:oid],nil_if_empty:bit):int +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:int],s:bat[:oid,:oid]):int +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:int],nil_if_empty:bit):int +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:int]):int +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:sht],s:bat[:oid,:oid],nil_if_empty:bit):dbl +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:sht],s:bat[:oid,:oid]):dbl +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:sht],nil_if_empty:bit):dbl +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:sht]):dbl +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:sht],s:bat[:oid,:oid],nil_if_empty:bit):lng +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:sht],s:bat[:oid,:oid]):lng +address CMDBATprod; +comment Calculate aggregate product of B with candidate list. + +pattern aggr.prod(b:bat[:oid,:sht],nil_if_empty:bit):lng +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:sht]):lng +address CMDBATprod; +comment Calculate aggregate product of B. + +pattern aggr.prod(b:bat[:oid,:sht],s:bat[:oid,:oid],nil_if_empty:bit):wrd _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
