Changeset: ce4fd4692804 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ce4fd4692804
Removed Files:
        clients/odbc/driver/ODBC.syms
        clients/odbc/winsetup/setup.syms
        monetdb5/modules/atoms/mtime.h
        monetdb5/modules/atoms/mtime_analytic.c
        sql/test/miscellaneous/Tests/simple_plans.stable.out.single
Branch: monetdbe-proxy
Log Message:

Merge with default.


diffs (truncated from 151181 to 300 lines):

diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -789,3 +789,5 @@ cb4b3f021774b60ffd84c3004d341ec04de736f3
 bd91504a03736565fb2dff13cd4c94c738e81aa0 Oct2020_5
 cb4b3f021774b60ffd84c3004d341ec04de736f3 Oct2020_release
 bd91504a03736565fb2dff13cd4c94c738e81aa0 Oct2020_release
+ac8254a47e87d0be9df2a623e2c2fcf67c0f982d Oct2020_7
+ac8254a47e87d0be9df2a623e2c2fcf67c0f982d Oct2020_SP1_release
diff --git a/CMakeLists.txt b/CMakeLists.txt
--- a/CMakeLists.txt
+++ b/CMakeLists.txt
@@ -183,4 +183,5 @@ if(CMAKE_SUMMARY)
   monetdb_cmake_summary()
 endif()
 
+
 # vim: set ts=2:sw=2:et
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -97,7 +97,7 @@ Group: Applications/Databases
 License: MPLv2.0
 URL: https://www.monetdb.org/
 BugURL: https://bugs.monetdb.org/
-Source: 
https://www.monetdb.org/downloads/sources/Oct2020/%{name}-%{version}.tar.bz2
+Source: 
https://www.monetdb.org/downloads/sources/Oct2020-SP1/%{name}-%{version}.tar.bz2
 
 # The Fedora packaging document says we need systemd-rpm-macros for
 # the _unitdir and _tmpfilesdir macros to exist; however on RHEL 7
@@ -153,6 +153,13 @@ BuildRequires: python3-numpy
 %endif
 %if %{with rintegration}
 BuildRequires: pkgconfig(libR)
+%if (0%{?fedora} == 32)
+# work around a packaging bug on Fedora 32 (18 Nov 2020)
+# problem is things like:
+# file /etc/texlive/web2c/updmap.cfg conflicts between attempted installs of 
texlive-tetex-7:20190410-12.fc32.noarch and 
texlive-texlive-scripts-7:20200327-16.fc32.noarch
+# texlive-tetex is obsoleted by texlive-obsolete
+BuildRequires: texlive-obsolete
+%endif
 %endif
 # if we were to compile with cmocka support (-DWITH_CMOCKA=ON):
 # BuildRequires: pkgconfig(cmocka)
@@ -861,11 +868,36 @@ else
 fi
 %endif
 
+%if %{?rhel:0}%{!?rhel:1} || 0%{?rhel} >= 7
+# fix up some paths (/var/run -> /run)
+# needed because CMAKE_INSTALL_RUNSTATEDIR refers to /var/run
+sed -i 's|/var/run|/run|' \
+    %{buildroot}%{_tmpfilesdir}/monetdbd.conf \
+    %{buildroot}%{_localstatedir}/monetdb5/dbfarm/.merovingian_properties \
+    %{buildroot}%{_unitdir}/monetdbd.service
+%endif
+
 %post -p /sbin/ldconfig
 
 %postun -p /sbin/ldconfig
 
 %changelog
+* Wed Nov 18 2020 Sjoerd Mullender <sjo...@acm.org> - 11.39.7-20201118
+- Rebuilt.
+- BZ#6890: Add support of xz/lzma (de)compression on MS Windows
+- BZ#6891: Add support of lz4 (de)compression on MS Windows
+- BZ#6971: Parsing table returning function on remote server fails
+- BZ#6981: Oct2020: PREPARE DDL statement silently fails
+- BZ#6983: monetdb allows to use non-existing optimizer pipe
+- BZ#6998: MAL profiler buffer limitations
+- BZ#7001: crossproduct generated for a simple (semi-)join
+- BZ#7003: Segfault on large chain of constant decimal multiplication
+- BZ#7005: Dropping a STREAM TABLE does not remove the associated column
+  info from sys._columns
+- BZ#7010: deallocate <id> results in all prepared statements being
+  deallocated (not error-related)
+- BZ#7011: uuid() called only once when used in projection list
+
 * Tue Oct 13 2020 Sjoerd Mullender <sjo...@acm.org> - 11.39.5-20201013
 - Rebuilt.
 
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
@@ -6064,6 +6064,8 @@ stdout of test 'MAL-signatures` in direc
 [ "batmmath",  "radians",      "pattern batmmath.radians(X_1:bat[:dbl], 
X_2:bat[:oid]):bat[:dbl] ",    "CMDscience_bat_radians;",      ""      ]
 [ "batmmath",  "radians",      "pattern 
batmmath.radians(X_1:bat[:flt]):bat[:flt] ",   "CMDscience_bat_radians;",      
""      ]
 [ "batmmath",  "radians",      "pattern batmmath.radians(X_1:bat[:flt], 
X_2:bat[:oid]):bat[:flt] ",    "CMDscience_bat_radians;",      ""      ]
+[ "batmmath",  "rand", "unsafe pattern batmmath.rand(X_1:bat[:int]):bat[:int] 
",       "CMDscience_bat_randintarg;",   ""      ]
+[ "batmmath",  "rand", "unsafe pattern batmmath.rand(X_1:bat[:int], 
X_2:bat[:oid]):bat[:int] ",        "CMDscience_bat_randintarg;",   ""      ]
 [ "batmmath",  "sin",  "pattern batmmath.sin(X_1:bat[:dbl]):bat[:dbl] ",       
"CMDscience_bat_sin;",  ""      ]
 [ "batmmath",  "sin",  "pattern batmmath.sin(X_1:bat[:dbl], 
X_2:bat[:oid]):bat[:dbl] ",        "CMDscience_bat_sin;",  ""      ]
 [ "batmmath",  "sin",  "pattern batmmath.sin(X_1:bat[:flt]):bat[:flt] ",       
"CMDscience_bat_sin;",  ""      ]
@@ -6294,78 +6296,78 @@ stdout of test 'MAL-signatures` in direc
 [ "batsql",    "any",  "pattern batsql.any(X_1:bit, X_2:bat[:bit], 
X_3:bat[:bit]):bat[:bit] ", "SQLany_cmp;",  ""      ]
 [ "batsql",    "any",  "pattern batsql.any(X_1:bit, X_2:bat[:bit], 
X_3:bit):bat[:bit] ",       "SQLany_cmp;",  ""      ]
 [ "batsql",    "any",  "pattern batsql.any(X_1:bit, X_2:bit, 
X_3:bat[:bit]):bat[:bit] ",       "SQLany_cmp;",  ""      ]
-[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:bte], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:dbl] ",   "SQLavg;",      ""      ]
-[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:dbl], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:dbl] ",   "SQLavg;",      ""      ]
-[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:flt], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:dbl] ",   "SQLavg;",      ""      ]
-[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:int], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:dbl] ",   "SQLavg;",      ""      ]
-[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:lng], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:dbl] ",   "SQLavg;",      ""      ]
-[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:sht], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:dbl] ",   "SQLavg;",      ""      ]
-[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:bte], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:bte] ",   "SQLavginteger;",       ""      ]
-[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:int], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:int] ",   "SQLavginteger;",       ""      ]
-[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:lng], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:lng] ",   "SQLavginteger;",       ""      ]
-[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:sht], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:sht] ",   "SQLavginteger;",       ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:bte], X_2:bat[:bte], 
X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",   "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:bte], X_2:bte, 
X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:dbl], X_2:bat[:dbl], 
X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",   "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:dbl], X_2:dbl, 
X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:flt], X_2:bat[:flt], 
X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",   "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:flt], X_2:flt, 
X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:int], X_2:bat[:int], 
X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",   "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:int], X_2:int, 
X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:lng], X_2:bat[:lng], 
X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",   "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:lng], X_2:lng, 
X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:sht], X_2:bat[:sht], 
X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",   "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:sht], X_2:sht, 
X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ", "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:bte, X_2:bat[:bte], X_3:lng, 
X_4:lng):bat[:dbl] ",     "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:dbl, X_2:bat[:dbl], X_3:lng, 
X_4:lng):bat[:dbl] ",     "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:flt, X_2:bat[:flt], X_3:lng, 
X_4:lng):bat[:dbl] ",     "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:int, X_2:bat[:int], X_3:lng, 
X_4:lng):bat[:dbl] ",     "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:lng, X_2:bat[:lng], X_3:lng, 
X_4:lng):bat[:dbl] ",     "SQLcorr;",     ""      ]
-[ "batsql",    "corr", "pattern batsql.corr(X_1:sht, X_2:bat[:sht], X_3:lng, 
X_4:lng):bat[:dbl] ",     "SQLcorr;",     ""      ]
-[ "batsql",    "count",        "pattern batsql.count(X_1:bat[:any_1], X_2:bit, 
X_3:bat[:lng], X_4:bat[:lng]):bat[:lng] ",      "SQLcount;",    ""      ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:bte], 
X_2:bat[:bte], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",     "SQLcovar_samp;", 
      ""      ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:bte], 
X_2:bte, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",   "SQLcovar_samp;",       
""      ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:dbl], 
X_2:bat[:dbl], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",     "SQLcovar_samp;", 
      ""      ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:dbl], 
X_2:dbl, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",   "SQLcovar_samp;",       
""      ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:flt], 
X_2:bat[:flt], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",     "SQLcovar_samp;", 
      ""      ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:flt], 
X_2:flt, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",   "SQLcovar_samp;",       
""      ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:int], 
X_2:bat[:int], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",     "SQLcovar_samp;", 
      ""      ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:int], 
X_2:int, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",   "SQLcovar_samp;",       
""      ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:lng], 
X_2:bat[:lng], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",     "SQLcovar_samp;", 
      ""      ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:lng], 
X_2:lng, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",   "SQLcovar_samp;",       
""      ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:sht], 
X_2:bat[:sht], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",     "SQLcovar_samp;", 
      ""      ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:sht], 
X_2:sht, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",   "SQLcovar_samp;",       
""      ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bte, 
X_2:bat[:bte], X_3:lng, X_4:lng):bat[:dbl] ",       "SQLcovar_samp;",       ""  
    ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:dbl, 
X_2:bat[:dbl], X_3:lng, X_4:lng):bat[:dbl] ",       "SQLcovar_samp;",       ""  
    ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:flt, 
X_2:bat[:flt], X_3:lng, X_4:lng):bat[:dbl] ",       "SQLcovar_samp;",       ""  
    ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:int, 
X_2:bat[:int], X_3:lng, X_4:lng):bat[:dbl] ",       "SQLcovar_samp;",       ""  
    ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:lng, 
X_2:bat[:lng], X_3:lng, X_4:lng):bat[:dbl] ",       "SQLcovar_samp;",       ""  
    ]
-[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:sht, 
X_2:bat[:sht], X_3:lng, X_4:lng):bat[:dbl] ",       "SQLcovar_samp;",       ""  
    ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:bte], 
X_2:bat[:bte], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",    "SQLcovar_pop;",   
     ""      ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:bte], 
X_2:bte, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",  "SQLcovar_pop;",        "" 
     ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:dbl], 
X_2:bat[:dbl], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",    "SQLcovar_pop;",   
     ""      ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:dbl], 
X_2:dbl, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",  "SQLcovar_pop;",        "" 
     ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:flt], 
X_2:bat[:flt], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",    "SQLcovar_pop;",   
     ""      ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:flt], 
X_2:flt, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",  "SQLcovar_pop;",        "" 
     ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:int], 
X_2:bat[:int], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",    "SQLcovar_pop;",   
     ""      ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:int], 
X_2:int, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",  "SQLcovar_pop;",        "" 
     ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:lng], 
X_2:bat[:lng], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",    "SQLcovar_pop;",   
     ""      ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:lng], 
X_2:lng, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",  "SQLcovar_pop;",        "" 
     ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:sht], 
X_2:bat[:sht], X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",    "SQLcovar_pop;",   
     ""      ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:sht], 
X_2:sht, X_3:bat[:lng], X_4:bat[:lng]):bat[:dbl] ",  "SQLcovar_pop;",        "" 
     ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bte, 
X_2:bat[:bte], X_3:lng, X_4:lng):bat[:dbl] ",      "SQLcovar_pop;",        ""   
   ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:dbl, 
X_2:bat[:dbl], X_3:lng, X_4:lng):bat[:dbl] ",      "SQLcovar_pop;",        ""   
   ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:flt, 
X_2:bat[:flt], X_3:lng, X_4:lng):bat[:dbl] ",      "SQLcovar_pop;",        ""   
   ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:int, 
X_2:bat[:int], X_3:lng, X_4:lng):bat[:dbl] ",      "SQLcovar_pop;",        ""   
   ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:lng, 
X_2:bat[:lng], X_3:lng, X_4:lng):bat[:dbl] ",      "SQLcovar_pop;",        ""   
   ]
-[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:sht, 
X_2:bat[:sht], X_3:lng, X_4:lng):bat[:dbl] ",      "SQLcovar_pop;",        ""   
   ]
+[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:bte], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:dbl] ",    "SQLavg;",      ""      ]
+[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:dbl], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:dbl] ",    "SQLavg;",      ""      ]
+[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:flt], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:dbl] ",    "SQLavg;",      ""      ]
+[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:int], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:dbl] ",    "SQLavg;",      ""      ]
+[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:lng], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:dbl] ",    "SQLavg;",      ""      ]
+[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:sht], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:dbl] ",    "SQLavg;",      ""      ]
+[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:bte], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:bte] ",    "SQLavginteger;",       ""      ]
+[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:int], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:int] ",    "SQLavginteger;",       ""      ]
+[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:lng], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:lng] ",    "SQLavginteger;",       ""      ]
+[ "batsql",    "avg",  "pattern batsql.avg(X_1:bat[:sht], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:sht] ",    "SQLavginteger;",       ""      ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:bte], X_2:bat[:bte], 
X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    "SQLcorr;",     "" 
     ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:bte], X_2:bte, X_3:any, 
X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",  "SQLcorr;",     ""      ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:dbl], X_2:bat[:dbl], 
X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    "SQLcorr;",     "" 
     ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:dbl], X_2:dbl, X_3:any, 
X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",  "SQLcorr;",     ""      ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:flt], X_2:bat[:flt], 
X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    "SQLcorr;",     "" 
     ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:flt], X_2:flt, X_3:any, 
X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",  "SQLcorr;",     ""      ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:int], X_2:bat[:int], 
X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    "SQLcorr;",     "" 
     ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:int], X_2:int, X_3:any, 
X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",  "SQLcorr;",     ""      ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:lng], X_2:bat[:lng], 
X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    "SQLcorr;",     "" 
     ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:lng], X_2:lng, X_3:any, 
X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",  "SQLcorr;",     ""      ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:sht], X_2:bat[:sht], 
X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    "SQLcorr;",     "" 
     ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:bat[:sht], X_2:sht, X_3:any, 
X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",  "SQLcorr;",     ""      ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:bte, X_2:bat[:bte], X_3:any, 
X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",  "SQLcorr;",     ""      ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:dbl, X_2:bat[:dbl], X_3:any, 
X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",  "SQLcorr;",     ""      ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:flt, X_2:bat[:flt], X_3:any, 
X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",  "SQLcorr;",     ""      ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:int, X_2:bat[:int], X_3:any, 
X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",  "SQLcorr;",     ""      ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:lng, X_2:bat[:lng], X_3:any, 
X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",  "SQLcorr;",     ""      ]
+[ "batsql",    "corr", "pattern batsql.corr(X_1:sht, X_2:bat[:sht], X_3:any, 
X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",  "SQLcorr;",     ""      ]
+[ "batsql",    "count",        "pattern batsql.count(X_1:bat[:any_1], X_2:bit, 
X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:lng] ",       "SQLcount;",    
""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:bte], 
X_2:bat[:bte], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",      
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:bte], 
X_2:bte, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:dbl], 
X_2:bat[:dbl], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",      
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:dbl], 
X_2:dbl, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:flt], 
X_2:bat[:flt], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",      
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:flt], 
X_2:flt, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:int], 
X_2:bat[:int], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",      
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:int], 
X_2:int, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:lng], 
X_2:bat[:lng], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",      
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:lng], 
X_2:lng, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:sht], 
X_2:bat[:sht], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",      
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bat[:sht], 
X_2:sht, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:bte, 
X_2:bat[:bte], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:dbl, 
X_2:bat[:dbl], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:flt, 
X_2:bat[:flt], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:int, 
X_2:bat[:int], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:lng, 
X_2:bat[:lng], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariance",   "pattern batsql.covariance(X_1:sht, 
X_2:bat[:sht], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",    
"SQLcovar_samp;",       ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:bte], 
X_2:bat[:bte], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",     
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:bte], 
X_2:bte, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",   
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:dbl], 
X_2:bat[:dbl], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",     
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:dbl], 
X_2:dbl, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",   
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:flt], 
X_2:bat[:flt], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",     
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:flt], 
X_2:flt, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",   
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:int], 
X_2:bat[:int], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",     
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:int], 
X_2:int, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",   
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:lng], 
X_2:bat[:lng], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",     
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:lng], 
X_2:lng, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",   
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:sht], 
X_2:bat[:sht], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",     
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bat[:sht], 
X_2:sht, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",   
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:bte, 
X_2:bat[:bte], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",   
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:dbl, 
X_2:bat[:dbl], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",   
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:flt, 
X_2:bat[:flt], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",   
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:int, 
X_2:bat[:int], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",   
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:lng, 
X_2:bat[:lng], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",   
"SQLcovar_pop;",        ""      ]
+[ "batsql",    "covariancep",  "pattern batsql.covariancep(X_1:sht, 
X_2:bat[:sht], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:dbl] ",   
"SQLcovar_pop;",        ""      ]
 [ "batsql",    "cume_dist",    "pattern batsql.cume_dist(X_1:bat[:any_1], 
X_2:any_2, X_3:any_3):bat[:dbl] ",   "SQLcume_dist;",        ""      ]
 [ "batsql",    "dense_rank",   "pattern batsql.dense_rank(X_1:bat[:any_1], 
X_2:any_2, X_3:any_3):bat[:int] ",  "SQLdense_rank;",       ""      ]
 [ "batsql",    "diff", "pattern batsql.diff(X_1:bat[:any_1]):bat[:bit] ",      
"SQLdiff;",     ""      ]
 [ "batsql",    "diff", "pattern batsql.diff(X_1:bat[:bit], 
X_2:any_1):bat[:bit] ",     "SQLdiff;",     ""      ]
 [ "batsql",    "diff", "pattern batsql.diff(X_1:bat[:bit], 
X_2:bat[:any_1]):bat[:bit] ",       "SQLdiff;",     ""      ]
 [ "batsql",    "diff", "pattern batsql.diff(X_1:bit, 
X_2:bat[:any_1]):bat[:bit] ",     "SQLdiff;",     ""      ]
-[ "batsql",    "first_value",  "pattern batsql.first_value(X_1:bat[:any_1], 
X_2:bat[:lng], X_3:bat[:lng]):bat[:any_1] ",       "SQLfirst_value;",      ""   
   ]
+[ "batsql",    "first_value",  "pattern batsql.first_value(X_1:bat[:any_1], 
X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1] ",        
"SQLfirst_value;",      ""      ]
 [ "batsql",    "get_value",    "pattern batsql.get_value(X_1:bat[:str], 
X_2:bat[:str]):bat[:lng] ",    "mvc_bat_get_value;",   ""      ]
 [ "batsql",    "get_value",    "pattern batsql.get_value(X_1:bat[:str], 
X_2:str):bat[:lng] ",  "mvc_bat_get_value;",   ""      ]
 [ "batsql",    "get_value",    "pattern batsql.get_value(X_1:str, 
X_2:bat[:str]):bat[:lng] ",  "mvc_bat_get_value;",   ""      ]
@@ -6383,7 +6385,7 @@ stdout of test 'MAL-signatures` in direc
 [ "batsql",    "lag",  "pattern batsql.lag(X_1:bat[:any_1], X_2:bat[:any], 
X_3:any_1, X_4:any_2, X_5:any_3):bat[:any_1] ",     "SQLlag;",      ""      ]
 [ "batsql",    "lag",  "pattern batsql.lag(X_1:bat[:any_1], X_2:bat[:any], 
X_3:any_2, X_4:any_3):bat[:any_1] ",        "SQLlag;",      ""      ]
 [ "batsql",    "lag",  "pattern batsql.lag(X_1:bat[:any_1], X_2:bat[:any], 
X_3:bat[:any_1], X_4:any_2, X_5:any_3):bat[:any_1] ",       "SQLlag;",      ""  
    ]
-[ "batsql",    "last_value",   "pattern batsql.last_value(X_1:bat[:any_1], 
X_2:bat[:lng], X_3:bat[:lng]):bat[:any_1] ",        "SQLlast_value;",       ""  
    ]
+[ "batsql",    "last_value",   "pattern batsql.last_value(X_1:bat[:any_1], 
X_2:any, X_3:any, X_4:int, X_5:any, X_6:any):bat[:any_1] ", "SQLlast_value;",   
    ""      ]
 [ "batsql",    "lead", "pattern batsql.lead(X_1:any_1, X_2:any, 
X_3:bat[:any_1], X_4:any_2, X_5:any_3):bat[:any_1] ",  "SQLlead;",     ""      ]
 [ "batsql",    "lead", "pattern batsql.lead(X_1:any_1, X_2:bat[:any], 
X_3:any_1, X_4:any_2, X_5:any_3):bat[:any_1] ",  "SQLlead;",     ""      ]
 [ "batsql",    "lead", "pattern batsql.lead(X_1:any_1, X_2:bat[:any], 
X_3:any_2, X_4:any_3):bat[:any_1] ",     "SQLlead;",     ""      ]
@@ -6395,26 +6397,26 @@ stdout of test 'MAL-signatures` in direc
 [ "batsql",    "lead", "pattern batsql.lead(X_1:bat[:any_1], X_2:bat[:any], 
X_3:any_1, X_4:any_2, X_5:any_3):bat[:any_1] ",    "SQLlead;",     ""      ]
 [ "batsql",    "lead", "pattern batsql.lead(X_1:bat[:any_1], X_2:bat[:any], 
X_3:any_2, X_4:any_3):bat[:any_1] ",       "SQLlead;",     ""      ]
 [ "batsql",    "lead", "pattern batsql.lead(X_1:bat[:any_1], X_2:bat[:any], 
X_3:bat[:any_1], X_4:any_2, X_5:any_3):bat[:any_1] ",      "SQLlead;",     ""   
   ]
-[ "batsql",    "max",  "pattern batsql.max(X_1:bat[:any_1], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:any_1] ",       "SQLmax;",      ""      ]
-[ "batsql",    "min",  "pattern batsql.min(X_1:bat[:any_1], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:any_1] ",       "SQLmin;",      ""      ]
+[ "batsql",    "max",  "pattern batsql.max(X_1:bat[:any_1], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:any_1] ",        "SQLmax;",      ""      ]
+[ "batsql",    "min",  "pattern batsql.min(X_1:bat[:any_1], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:any_1] ",        "SQLmin;",      ""      ]
 [ "batsql",    "next_value",   "unsafe pattern 
batsql.next_value(X_1:bat[:str], X_2:bat[:str]):bat[:lng] ",    
"mvc_bat_next_value;",  ""      ]
 [ "batsql",    "next_value",   "unsafe pattern 
batsql.next_value(X_1:bat[:str], X_2:str):bat[:lng] ",  "mvc_bat_next_value;",  
""      ]
 [ "batsql",    "next_value",   "unsafe pattern batsql.next_value(X_1:str, 
X_2:bat[:str]):bat[:lng] ",  "mvc_bat_next_value;",  ""      ]
-[ "batsql",    "nth_value",    "pattern batsql.nth_value(X_1:any, 
X_2:bat[:any_1], X_3:lng, X_4:lng):bat[:any] ",      "SQLnth_value;",        "" 
     ]
-[ "batsql",    "nth_value",    "pattern batsql.nth_value(X_1:bat[:any], 
X_2:any_1, X_3:bat[:lng], X_4:bat[:lng]):bat[:any] ",  "SQLnth_value;",        
""      ]
-[ "batsql",    "nth_value",    "pattern batsql.nth_value(X_1:bat[:any], 
X_2:bat[:any_1], X_3:bat[:lng], X_4:bat[:lng]):bat[:any] ",    "SQLnth_value;", 
       ""      ]
+[ "batsql",    "nth_value",    "pattern batsql.nth_value(X_1:any_1, 
X_2:bat[:lng], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:any_1] ", 
"SQLnth_value;",        ""      ]
+[ "batsql",    "nth_value",    "pattern batsql.nth_value(X_1:bat[:any_1], 
X_2:bat[:lng], X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:any_1] ",   
"SQLnth_value;",        ""      ]
+[ "batsql",    "nth_value",    "pattern batsql.nth_value(X_1:bat[:any_1], 
X_2:lng, X_3:any, X_4:any, X_5:int, X_6:any, X_7:any):bat[:any_1] ", 
"SQLnth_value;",        ""      ]
 [ "batsql",    "ntile",        "pattern batsql.ntile(X_1:any, X_2:bat[:any_1], 
X_3:any_2, X_4:any_3):bat[:any_1] ",    "SQLntile;",    ""      ]
 [ "batsql",    "ntile",        "pattern batsql.ntile(X_1:bat[:any], X_2:any_1, 
X_3:any_2, X_4:any_3):bat[:any_1] ",    "SQLntile;",    ""      ]
 [ "batsql",    "ntile",        "pattern batsql.ntile(X_1:bat[:any], 
X_2:bat[:any_1], X_3:any_2, X_4:any_3):bat[:any_1] ",      "SQLntile;",    ""   
   ]
 [ "batsql",    "password",     "pattern 
batsql.password(X_1:bat[:str]):bat[:str] ",    "db_password_wrap;",    ""      ]
 [ "batsql",    "percent_rank", "pattern batsql.percent_rank(X_1:bat[:any_1], 
X_2:any_2, X_3:any_3):bat[:dbl] ",        "SQLpercent_rank;",     ""      ]
-[ "batsql",    "prod", "pattern batsql.prod(X_1:bat[:bte], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:lng] ",  "SQLprod;",     ""      ]
-[ "batsql",    "prod", "pattern batsql.prod(X_1:bat[:dbl], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:dbl] ",  "SQLprod;",     ""      ]
-[ "batsql",    "prod", "pattern batsql.prod(X_1:bat[:flt], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:dbl] ",  "SQLprod;",     ""      ]
-[ "batsql",    "prod", "pattern batsql.prod(X_1:bat[:flt], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:flt] ",  "SQLprod;",     ""      ]
-[ "batsql",    "prod", "pattern batsql.prod(X_1:bat[:int], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:lng] ",  "SQLprod;",     ""      ]
-[ "batsql",    "prod", "pattern batsql.prod(X_1:bat[:lng], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:lng] ",  "SQLprod;",     ""      ]
-[ "batsql",    "prod", "pattern batsql.prod(X_1:bat[:sht], X_2:bat[:lng], 
X_3:bat[:lng]):bat[:lng] ",  "SQLprod;",     ""      ]
+[ "batsql",    "prod", "pattern batsql.prod(X_1:bat[:bte], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:lng] ",   "SQLprod;",     ""      ]
+[ "batsql",    "prod", "pattern batsql.prod(X_1:bat[:dbl], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:dbl] ",   "SQLprod;",     ""      ]
+[ "batsql",    "prod", "pattern batsql.prod(X_1:bat[:flt], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:dbl] ",   "SQLprod;",     ""      ]
+[ "batsql",    "prod", "pattern batsql.prod(X_1:bat[:flt], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:flt] ",   "SQLprod;",     ""      ]
+[ "batsql",    "prod", "pattern batsql.prod(X_1:bat[:int], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:lng] ",   "SQLprod;",     ""      ]
+[ "batsql",    "prod", "pattern batsql.prod(X_1:bat[:lng], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:lng] ",   "SQLprod;",     ""      ]
+[ "batsql",    "prod", "pattern batsql.prod(X_1:bat[:sht], X_2:any, X_3:any, 
X_4:int, X_5:any, X_6:any):bat[:lng] ",   "SQLprod;",     ""      ]
 [ "batsql",    "rank", "pattern batsql.rank(X_1:bat[:any_1], X_2:any_2, 
X_3:any_3):bat[:int] ",        "SQLrank;",     ""      ]
 [ "batsql",    "restart",      "unsafe pattern batsql.restart(X_1:bat[:str], 
X_2:bat[:str], X_3:bat[:lng]):bat[:lng] ",        "mvc_bat_restart_seq;", ""    
  ]
 [ "batsql",    "restart",      "unsafe pattern batsql.restart(X_1:bat[:str], 
X_2:bat[:str], X_3:lng):bat[:lng] ",      "mvc_bat_restart_seq;", ""      ]
@@ -6424,66 +6426,66 @@ stdout of test 'MAL-signatures` in direc
 [ "batsql",    "restart",      "unsafe pattern batsql.restart(X_1:str, 
X_2:bat[:str], X_3:lng):bat[:lng] ",    "mvc_bat_restart_seq;", ""      ]
 [ "batsql",    "restart",      "unsafe pattern batsql.restart(X_1:str, 
X_2:str, X_3:bat[:lng]):bat[:lng] ",    "mvc_bat_restart_seq;", ""      ]
 [ "batsql",    "row_number",   "pattern batsql.row_number(X_1:bat[:any_1], 
X_2:any_2, X_3:any_3):bat[:int] ",  "SQLrow_number;",       ""      ]
-[ "batsql",    "stdev",        "pattern batsql.stdev(X_1:bat[:bte], 
X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_samp;",      ""      ]
-[ "batsql",    "stdev",        "pattern batsql.stdev(X_1:bat[:dbl], 
X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_samp;",      ""      ]
-[ "batsql",    "stdev",        "pattern batsql.stdev(X_1:bat[:flt], 
X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_samp;",      ""      ]
-[ "batsql",    "stdev",        "pattern batsql.stdev(X_1:bat[:int], 
X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_samp;",      ""      ]
-[ "batsql",    "stdev",        "pattern batsql.stdev(X_1:bat[:lng], 
X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_samp;",      ""      ]
-[ "batsql",    "stdev",        "pattern batsql.stdev(X_1:bat[:sht], 
X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ", "SQLstddev_samp;",      ""      ]
-[ "batsql",    "stdevp",       "pattern batsql.stdevp(X_1:bat[:bte], 
X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ",        "SQLstddev_pop;",       ""    
  ]
-[ "batsql",    "stdevp",       "pattern batsql.stdevp(X_1:bat[:dbl], 
X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ",        "SQLstddev_pop;",       ""    
  ]
-[ "batsql",    "stdevp",       "pattern batsql.stdevp(X_1:bat[:flt], 
X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ",        "SQLstddev_pop;",       ""    
  ]
-[ "batsql",    "stdevp",       "pattern batsql.stdevp(X_1:bat[:int], 
X_2:bat[:lng], X_3:bat[:lng]):bat[:dbl] ",        "SQLstddev_pop;",       ""    
  ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to