Changeset: 8706b522ac9f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8706b522ac9f
Added Files:
sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql
sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.err
sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out
sql/test/Tests/like_tests.sql
sql/test/out2in/Tests/out2in.stable.out.int128
Removed Files:
cmake/Modules/FindLiblas.cmake
cmake/Modules/FindLidar.cmake
debian/libmonetdb5-server-lidar.install
sql/backends/monet5/vaults/lidar/75_lidar.mal
sql/backends/monet5/vaults/lidar/75_lidar.sql
sql/backends/monet5/vaults/lidar/CMakeLists.txt
sql/backends/monet5/vaults/lidar/lidar.c
sql/backends/monet5/vaults/lidar/lidar.h
sql/backends/monet5/vaults/lidar/lidar.mal
sql/test/Tests/like_tests.SQL.py
sql/test/like_tests.sql
Modified Files:
CMakeLists.txt
ChangeLog
MonetDB.spec
NT/mksqlwxs.py
NT/rules.msc
README-Debian
README-Fedora
clients/Tests/All
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
cmake/monetdb-deb-packages.cmake
cmake/monetdb-defines.cmake
cmake/monetdb-findpackages.cmake
cmake/monetdb-options.cmake
cmake/monetdb-rpm-packages.cmake
ctest/tools/embedded/CMakeLists.txt
debian/control
debian/libmonetdb-dev.install
debian/monetdb5-server.install
debian/monetdb5-sql.install
debian/rules
gdk/ChangeLog.Jun2020
gdk/gdk_hash.c
gdk/gdk_logger.c
gdk/gdk_select.c
gdk/gdk_tracer.h
monetdb5/mal/mal_debugger.c
monetdb5/modules/atoms/mtime.c
monetdb5/modules/mal/Tests/inspect05.stable.out
monetdb5/modules/mal/batmtime.mal
monetdb5/modules/mal/batmtime.mal.sh
monetdb5/modules/mal/pcre.c
rpm.mk.in
sql/backends/monet5/sql.c
sql/backends/monet5/sql_execute.c
sql/backends/monet5/sql_subquery.mal
sql/backends/monet5/sql_upgrades.c
sql/backends/monet5/vaults/CMakeLists.txt
sql/test/BugTracker-2020/Tests/All
sql/test/Tests/hot_snapshot.py
sql/test/emptydb-upgrade-chain-hge/Tests/All
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
sql/test/emptydb-upgrade-chain/Tests/All
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
sql/test/emptydb-upgrade-hge/Tests/All
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/All
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/All
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/miscellaneous/Tests/simple_selects.sql
sql/test/miscellaneous/Tests/simple_selects.stable.out
sql/test/out2in/Tests/out2in.stable.out
sql/test/sys-schema/Tests/All
sql/test/sys-schema/Tests/systemfunctions.stable.out
sql/test/sys-schema/Tests/systemfunctions.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
testing/CMakeLists.txt
testing/Mtest.py.in
Branch: msk-type
Log Message:
Merge with default branch.
diffs (truncated from 87708 to 300 lines):
diff --git a/CMakeLists.txt b/CMakeLists.txt
--- a/CMakeLists.txt
+++ b/CMakeLists.txt
@@ -86,7 +86,7 @@ include(monetdb-custom-targets)
SET(CMAKE_SKIP_BUILD_RPATH FALSE)
SET(CMAKE_BUILD_WITH_INSTALL_RPATH FALSE)
-SET(CMAKE_INSTALL_RPATH "${CMAKE_INSTALL_FULL_LIBDIR}")
+SET(CMAKE_INSTALL_RPATH
"${CMAKE_INSTALL_FULL_LIBDIR};${CMAKE_INSTALL_FULL_LIBDIR}/monetdb5")
SET(CMAKE_INSTALL_RPATH_USE_LINK_PATH TRUE)
# required for some instalation files
diff --git a/ChangeLog b/ChangeLog
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,6 +1,10 @@
# ChangeLog file for devel
# This file is updated with Maddlog
+* Wed Jun 10 2020 Sjoerd Mullender <[email protected]>
+- Removed support for LiDAR data, that is the SQL procedures
+ sys.lidarattach, sys.lidarload, and sys.lidarexport.
+
* Thu Apr 2 2020 Martin Kersten <[email protected]>
- The sys.queue() has been turned into a circular buffer to allow for
inspection of both active, paused and recently executed queries.
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -61,17 +61,6 @@
%endif
%endif
-# On Fedora, the liblas library is available, and so we can require it
-# and build the lidar modules. On RedHat Enterprise Linux and
-# derivatives (CentOS, Scientific Linux), the liblas library is only
-# available if EPEL is enabled, and then only on version 7.
-%if %{fedpkgs}
-%if %{?rhel:0}%{!?rhel:1} || 0%{?rhel} == 7
-# By default create the MonetDB-lidar package on Fedora and RHEL 7
-%bcond_without lidar
-%endif
-%endif
-
# By default use PCRE for the implementation of the SQL LIKE and ILIKE
# operators. Otherwise the POSIX regex functions are used.
%bcond_without pcre
@@ -133,10 +122,6 @@ BuildRequires: pkgconfig(cfitsio)
%if %{with geos}
BuildRequires: geos-devel >= 3.4.0
%endif
-%if %{with lidar}
-BuildRequires: liblas-devel >= 1.8.0
-BuildRequires: pkgconfig(gdal)
-%endif
BuildRequires: pkgconfig(libcurl)
BuildRequires: pkgconfig(liblzma)
# BuildRequires: libmicrohttpd-devel
@@ -201,6 +186,7 @@ functionality of MonetDB.
%dir %{_includedir}/monetdb
%{_includedir}/monetdb/gdk*.h
%{_includedir}/monetdb/matomic.h
+%{_includedir}/monetdb/mstring.h
%{_includedir}/monetdb/monet*.h
%{_libdir}/libbat.so
%{_libdir}/pkgconfig/monetdb-gdk.pc
@@ -399,28 +385,6 @@ extensions for %{name}-SQL-server5.
%{_libdir}/monetdb5/lib_geom.so
%endif
-%if %{with lidar}
-%package lidar
-Summary: MonetDB5 SQL support for working with LiDAR data
-Group: Applications/Databases
-Requires: MonetDB5-server%{?_isa} = %{version}-%{release}
-
-%description lidar
-MonetDB is a database management system that is developed from a
-main-memory perspective with use of a fully decomposed storage model,
-automatic index management, extensibility of data types and search
-accelerators. It also has an SQL front end.
-
-This package contains support for reading and writing LiDAR data.
-
-%files lidar
-%defattr(-,root,root)
-%{_libdir}/monetdb5/autoload/*_lidar.mal
-%{_libdir}/monetdb5/createdb/*_lidar.sql
-%{_libdir}/monetdb5/lidar.mal
-%{_libdir}/monetdb5/lib_lidar.so
-%endif
-
%if %{with rintegration}
%package R
Summary: Integration of MonetDB and R, allowing use of R from within SQL
@@ -565,9 +529,6 @@ exit 0
%if %{with geos}
%exclude %{_libdir}/monetdb5/geom.mal
%endif
-%if %{with lidar}
-%exclude %{_libdir}/monetdb5/lidar.mal
-%endif
%if %{with py3integration}
%exclude %{_libdir}/monetdb5/pyapi3.mal
%endif
@@ -583,9 +544,6 @@ exit 0
%if %{with geos}
%exclude %{_libdir}/monetdb5/autoload/*_geom.mal
%endif
-%if %{with lidar}
-%exclude %{_libdir}/monetdb5/autoload/*_lidar.mal
-%endif
%if %{with py3integration}
%exclude %{_libdir}/monetdb5/autoload/*_pyapi3.mal
%endif
@@ -708,9 +666,6 @@ use SQL with MonetDB, you will need to i
%if %{with geos}
%exclude %{_libdir}/monetdb5/createdb/*_geom.sql
%endif
-%if %{with lidar}
-%exclude %{_libdir}/monetdb5/createdb/*_lidar.sql
-%endif
%{_libdir}/monetdb5/createdb/*.sql
%{_libdir}/monetdb5/sql*.mal
%if %{with hugeint}
@@ -888,7 +843,6 @@ export CFLAGS
--enable-fits=%{?with_fits:yes}%{!?with_fits:no} \
--enable-geom=%{?with_geos:yes}%{!?with_geos:no} \
--enable-int128=%{?with_hugeint:yes}%{!?with_hugeint:no} \
- --enable-lidar=%{?with_lidar:yes}%{!?with_lidar:no} \
--enable-mapi=yes \
--enable-netcdf=no \
--enable-odbc=yes \
@@ -902,9 +856,8 @@ export CFLAGS
--enable-testing=yes \
--with-bz2=yes \
--with-curl=yes \
- --with-gdal=%{?with_lidar:yes}%{!?with_lidar:no} \
+ --with-gdal=no \
--with-geos=%{?with_geos:yes}%{!?with_geos:no} \
- --with-liblas=%{?with_lidar:yes}%{!?with_lidar:no} \
--with-libxml2=yes \
--with-lz4=no \
--with-lzma=yes \
diff --git a/NT/mksqlwxs.py b/NT/mksqlwxs.py
--- a/NT/mksqlwxs.py
+++ b/NT/mksqlwxs.py
@@ -158,6 +158,7 @@ def main():
sorted([r'include\monetdb\{}'.format(x) for x in filter(lambda
x: (x.startswith('gdk') or x.startswith('monet') or x.startswith('mal')) and
x.endswith('.h'), os.listdir(os.path.join(sys.argv[3], 'include', 'monetdb')))]
+
[r'include\monetdb\mapi.h',
r'include\monetdb\matomic.h',
+ r'include\monetdb\mstring.h',
r'include\monetdb\stream.h',
r'include\monetdb\stream_socket.h']),
vital = 'no')
diff --git a/NT/rules.msc b/NT/rules.msc
--- a/NT/rules.msc
+++ b/NT/rules.msc
@@ -278,11 +278,6 @@ create_winconfig_conds_new_py:
!ELSE
$(ECHO) HAVE_CURL_FALSE='' >> "$(TOPDIR)\winconfig_conds_new.py"
!ENDIF
-!IFDEF HAVE_DEVELOPER
- $(ECHO) HAVE_DEVELOPER_FALSE='#' >> "$(TOPDIR)\winconfig_conds_new.py"
-!ELSE
- $(ECHO) HAVE_DEVELOPER_FALSE='' >> "$(TOPDIR)\winconfig_conds_new.py"
-!ENDIF
!IFDEF HAVE_FITS
$(ECHO) HAVE_FITS_FALSE='#' >> "$(TOPDIR)\winconfig_conds_new.py"
!ELSE
@@ -333,11 +328,6 @@ create_winconfig_conds_new_py:
!ELSE
$(ECHO) HAVE_LIBZ_FALSE='' >> "$(TOPDIR)\winconfig_conds_new.py"
!ENDIF
-!IFDEF HAVE_LIDAR
- $(ECHO) HAVE_LIDAR_FALSE='#' >> "$(TOPDIR)\winconfig_conds_new.py"
-!ELSE
- $(ECHO) HAVE_LIDAR_FALSE='' >> "$(TOPDIR)\winconfig_conds_new.py"
-!ENDIF
!IFDEF HAVE_NETCDF
$(ECHO) HAVE_NETCDF_FALSE='#' >> "$(TOPDIR)\winconfig_conds_new.py"
!ELSE
@@ -368,11 +358,6 @@ create_winconfig_conds_new_py:
!ELSE
$(ECHO) HAVE_MAL_DEBUGGER_FALSE='' >> "$(TOPDIR)\winconfig_conds_new.py"
!ENDIF
-!IFDEF HAVE_TESTING
- $(ECHO) HAVE_TESTING_FALSE='#' >> "$(TOPDIR)\winconfig_conds_new.py"
-!ELSE
- $(ECHO) HAVE_TESTING_FALSE='' >> "$(TOPDIR)\winconfig_conds_new.py"
-!ENDIF
!IFDEF NATIVE_WIN32
$(ECHO) NATIVE_WIN32_FALSE='#' >> "$(TOPDIR)\winconfig_conds_new.py"
!ELSE
diff --git a/README-Debian b/README-Debian
--- a/README-Debian
+++ b/README-Debian
@@ -15,7 +15,6 @@ These packages are optional, but require
libbz2-dev # optional: read and write .bz2 compressed files
libcurl4-gnutls-dev # optional: read remote files with sys.getcontent(url)
libgeos-dev # optional: required for geom module
-liblas-c-dev # optional: read LIDAR files
liblzma-dev # optional: read and write .xz compressed files
libpcre3-dev # optional: use PCRE library, enable some functions
libreadline-dev # optional, enable editing in mclient
diff --git a/README-Fedora b/README-Fedora
--- a/README-Fedora
+++ b/README-Fedora
@@ -31,7 +31,6 @@ These packages are optional.
cfitsio-devel # optional: read FITS files
libasan # optional: --enable-sanitizer configuration
(debug)
-liblas-devel # optional: read LIDAR files
lz4-devel # optional: compression in new (unused) MAPI protocol,
also used to read and write .lz4 compressed files
netcdf-devel # optional: read NetCDF files
proj-devel # optional, only optionally used in geom module
diff --git a/clients/Tests/All b/clients/Tests/All
--- a/clients/Tests/All
+++ b/clients/Tests/All
@@ -1,4 +1,4 @@
exports
-HAVE_FITS&HAVE_GEOM&HAVE_LIBR&HAVE_LIBPY3&HAVE_LIDAR&HAVE_NETCDF&HAVE_SHP&NOT_WIN32?MAL-signatures
+HAVE_FITS&HAVE_GEOM&HAVE_LIBR&HAVE_LIBPY3&HAVE_NETCDF&HAVE_SHP&NOT_WIN32?MAL-signatures
#MERCURIAL?malcheck
mclient-uri
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
@@ -64,17929 +64,6834 @@ stdout of test 'MAL-signatures` in direc
% .%1, .%1, .%1, .%1, .%1 # table_name
% module, function, signature, address, comment # name
% clob, clob, clob, clob, clob # type
-% 12, 28, 364, 42, 874 # length
-[ "aggr", "allnotequal", "command aggr.allnotequal(l:bat[:any_1],
r:bat[:any_1]):bit ", "SQLallnotequal;", "if all values in r are not
equal to l return true, else if r has nil nil else false" ]
-[ "aggr", "anyequal", "pattern aggr.anyequal(l:any_1, r:any_1):bit ",
"CMDvarEQ;", "" ]
-[ "aggr", "anyequal", "command aggr.anyequal(l:bat[:any_1],
r:bat[:any_1]):bit ", "SQLanyequal;", "if any value in r is equal to l
return true, else if r has nil nil else false" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:bte], g:bat[:oid],
e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on
bte" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:dbl], g:bat[:oid],
e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on
dbl" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:flt], g:bat[:oid],
e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on
flt" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:int], g:bat[:oid],
e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on
int" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:lng], g:bat[:oid],
e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on
lng" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:sht], g:bat[:oid],
e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on
sht" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:bte], g:bat[:oid],
e:bat[:any_1], scale:int):bat[:dbl] ", "AGGRavg14_dbl;", "Grouped
tail average on bte" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:dbl], g:bat[:oid],
e:bat[:any_1], scale:int):bat[:dbl] ", "AGGRavg14_dbl;", "Grouped
tail average on dbl" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:flt], g:bat[:oid],
e:bat[:any_1], scale:int):bat[:dbl] ", "AGGRavg14_dbl;", "Grouped
tail average on flt" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:int], g:bat[:oid],
e:bat[:any_1], scale:int):bat[:dbl] ", "AGGRavg14_dbl;", "Grouped
tail average on int" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:lng], g:bat[:oid],
e:bat[:any_1], scale:int):bat[:dbl] ", "AGGRavg14_dbl;", "Grouped
tail average on lng" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:sht], g:bat[:oid],
e:bat[:any_1], scale:int):bat[:dbl] ", "AGGRavg14_dbl;", "Grouped
tail average on sht" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:bte], g:bat[:oid],
e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg23_dbl;",
"Grouped tail average on bte, also returns count" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:dbl], g:bat[:oid],
e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg23_dbl;",
"Grouped tail average on dbl, also returns count" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:flt], g:bat[:oid],
e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg23_dbl;",
"Grouped tail average on flt, also returns count" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:int], g:bat[:oid],
e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg23_dbl;",
"Grouped tail average on int, also returns count" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:lng], g:bat[:oid],
e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg23_dbl;",
"Grouped tail average on lng, also returns count" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:sht], g:bat[:oid],
e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg23_dbl;",
"Grouped tail average on sht, also returns count" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:bte], g:bat[:oid],
e:bat[:any_1], scale:int) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg24_dbl;",
"Grouped tail average on bte, also returns count" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:dbl], g:bat[:oid],
e:bat[:any_1], scale:int) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg24_dbl;",
"Grouped tail average on dbl, also returns count" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:flt], g:bat[:oid],
e:bat[:any_1], scale:int) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg24_dbl;",
"Grouped tail average on flt, also returns count" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:int], g:bat[:oid],
e:bat[:any_1], scale:int) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg24_dbl;",
"Grouped tail average on int, also returns count" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:lng], g:bat[:oid],
e:bat[:any_1], scale:int) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg24_dbl;",
"Grouped tail average on lng, also returns count" ]
-[ "aggr", "avg", "command aggr.avg(b:bat[:sht], g:bat[:oid],
e:bat[:any_1], scale:int) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg24_dbl;",
"Grouped tail average on sht, also returns count" ]
-[ "aggr", "avg", "pattern aggr.avg(b:bat[:any_2]):dbl ", "CMDcalcavg;",
"Gives the avg of all tail values" ]
-[ "aggr", "avg", "pattern aggr.avg(b:bat[:any_2], scale:int):dbl ",
"CMDcalcavg;", "Gives the avg of all tail values" ]
-[ "aggr", "cardinality", "command aggr.cardinality(b:bat[:any_2]):lng ",
"ALGcard;", "Return the cardinality of the BAT tail values." ]
-[ "aggr", "corr", "command aggr.corr(b1:bat[:bte], b2:bat[:bte],
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation
aggregate" ]
-[ "aggr", "corr", "command aggr.corr(b1:bat[:dbl], b2:bat[:dbl],
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation
aggregate" ]
-[ "aggr", "corr", "command aggr.corr(b1:bat[:flt], b2:bat[:flt],
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation
aggregate" ]
-[ "aggr", "corr", "command aggr.corr(b1:bat[:int], b2:bat[:int],
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation
aggregate" ]
-[ "aggr", "corr", "command aggr.corr(b1:bat[:lng], b2:bat[:lng],
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation
aggregate" ]
-[ "aggr", "corr", "command aggr.corr(b1:bat[:sht], b2:bat[:sht],
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcorr;", "Correlation
aggregate" ]
-[ "aggr", "corr", "command aggr.corr(b1:bat[:any_2], b2:bat[:any_2]):dbl
", "ALGcorr;", "Gives the correlation of all tail values" ]
-[ "aggr", "count", "command aggr.count(b:bat[:any_1], g:bat[:oid],
e:bat[:any_2], ignorenils:bit):bat[:lng] ", "AGGRcount3;", "" ]
-[ "aggr", "count", "command aggr.count(b:bat[:any_1], g:bat[:oid],
e:bat[:any_2]):bat[:lng] ", "AGGRcount3nils;", "Grouped count" ]
-[ "aggr", "count", "command aggr.count(b:bat[:any],
cnd:bat[:oid]):lng ", "ALGcountCND_bat;", "Return the current size (in
number of elements) in a BAT." ]
-[ "aggr", "count", "command aggr.count(b:bat[:any], cnd:bat[:oid],
ignore_nils:bit):lng ", "ALGcountCND_nil;", "Return the number of elements
currently in a BAT ignores\n\t\tBUNs with nil-tail iff ignore_nils==TRUE."
]
-[ "aggr", "count", "command aggr.count(b:bat[:any]):lng ",
"ALGcount_bat;", "Return the current size (in number of elements) in a
BAT." ]
-[ "aggr", "count", "command aggr.count(b:bat[:any],
ignore_nils:bit):lng ", "ALGcount_nil;", "Return the number of
elements currently in a BAT ignores\n\t\tBUNs with nil-tail iff
ignore_nils==TRUE." ]
-[ "aggr", "count_no_nil", "command aggr.count_no_nil(b:bat[:any_1],
g:bat[:oid], e:bat[:any_2]):bat[:lng] ", "AGGRcount3nonils;", "" ]
-[ "aggr", "count_no_nil", "command aggr.count_no_nil(b:bat[:any_2],
cnd:bat[:oid]):lng ", "ALGcountCND_no_nil;", "Return the number of elements
currently\n\tin a BAT ignoring BUNs with nil-tail" ]
-[ "aggr", "count_no_nil", "command aggr.count_no_nil(b:bat[:any_2]):lng
", "ALGcount_no_nil;", "Return the number of elements
currently\n\tin a BAT ignoring BUNs with nil-tail" ]
-[ "aggr", "covariance", "command aggr.covariance(b1:bat[:bte],
b2:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;",
"Covariance sample aggregate" ]
-[ "aggr", "covariance", "command aggr.covariance(b1:bat[:dbl],
b2:bat[:dbl], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;",
"Covariance sample aggregate" ]
-[ "aggr", "covariance", "command aggr.covariance(b1:bat[:flt],
b2:bat[:flt], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;",
"Covariance sample aggregate" ]
-[ "aggr", "covariance", "command aggr.covariance(b1:bat[:int],
b2:bat[:int], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;",
"Covariance sample aggregate" ]
-[ "aggr", "covariance", "command aggr.covariance(b1:bat[:lng],
b2:bat[:lng], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;",
"Covariance sample aggregate" ]
-[ "aggr", "covariance", "command aggr.covariance(b1:bat[:sht],
b2:bat[:sht], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariance;",
"Covariance sample aggregate" ]
-[ "aggr", "covariance", "command aggr.covariance(b1:bat[:any_2],
b2:bat[:any_2]):dbl ", "ALGcovariance;", "Gives the covariance of all
tail values" ]
-[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:bte],
b2:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;",
"Covariance population aggregate" ]
-[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:dbl],
b2:bat[:dbl], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;",
"Covariance population aggregate" ]
-[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:flt],
b2:bat[:flt], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;",
"Covariance population aggregate" ]
-[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:int],
b2:bat[:int], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;",
"Covariance population aggregate" ]
-[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:lng],
b2:bat[:lng], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;",
"Covariance population aggregate" ]
-[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:sht],
b2:bat[:sht], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRcovariancep;",
"Covariance population aggregate" ]
-[ "aggr", "covariancep", "command aggr.covariancep(b1:bat[:any_2],
b2:bat[:any_2]):dbl ", "ALGcovariancep;", "Gives the covariance of
all tail values" ]
-[ "aggr", "exist", "command aggr.exist(b:bat[:any_2], h:any_1):bit
", "ALGexist;", "" ]
-[ "aggr", "exist", "command aggr.exist(b:bat[:any_2]):bit ",
"SQLexist;", "" ]
-[ "aggr", "exist", "pattern aggr.exist(v:any_2):bit ",
"SQLexist_val;", "" ]
-[ "aggr", "jsonaggr", "command aggr.jsonaggr(val:bat[:dbl]):str ",
"JSONgroupStr;", "Aggregate the double values to array." ]
-[ "aggr", "jsonaggr", "command aggr.jsonaggr(val:bat[:str]):str ",
"JSONgroupStr;", "Aggregate the string values to array." ]
-[ "aggr", "max", "command aggr.max(b:bat[:any_1], g:bat[:oid],
e:bat[:any_2]):bat[:any_1] ", "AGGRmax3;", "" ]
-[ "aggr", "max", "command aggr.max(b:bat[:any_2]):any_2 ",
"ALGmaxany;", "Return the highest tail value or nil." ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
