Changeset: 3ce5153fae91 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3ce5153fae91 Removed Files: debian/libmonetdb-client14.install debian/libmonetdb-stream16.install debian/libmonetdb24.install debian/libmonetdbe3.install sql/test/sysmon/timeout/Tests/timeout_cross.SQL.py Modified Files: clients/Tests/exports.stable.out clients/Tests/melcheck.timeout debian/libmonetdb-client25.install debian/libmonetdb-stream25.install debian/libmonetdb25.install debian/libmonetdbe25.install geom/sql/pg_regression/Tests/removeTmpFiles.py sql/backends/monet5/CMakeLists.txt sql/backends/monet5/sql.c sql/storage/bat/bat_storage.c sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320-Windows.test sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.test sql/test/VOC/Tests/VOCinsert.test sql/test/VOC/Tests/VOCmanual_examples.test sql/test/VOC/Tests/VOCquery.test sql/test/VOC/Tests/VOCschema.test Branch: directappend Log Message:
Merge branch 'default' into 'directappend' diffs (truncated from 177422 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -827,3 +827,6 @@ e730f4981db58bb336d6b17a022eec95d9f0eae5 34d6df33e954fe8fbee1cb3d4e2bde0bbd903d74 Jan2022_3 e730f4981db58bb336d6b17a022eec95d9f0eae5 Jan2022_release 34d6df33e954fe8fbee1cb3d4e2bde0bbd903d74 Jan2022_release +9fbec5dab8167d2189582fbe75e5f9c8bef82380 Jan2022_5 +34d6df33e954fe8fbee1cb3d4e2bde0bbd903d74 Jan2022_release +9fbec5dab8167d2189582fbe75e5f9c8bef82380 Jan2022_release diff --git a/ChangeLog-Archive b/ChangeLog-Archive --- a/ChangeLog-Archive +++ b/ChangeLog-Archive @@ -1,6 +1,9 @@ # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY # This file contains past ChangeLog entries +* Wed Jan 12 2022 Sjoerd Mullender <[email protected]> - 11.43.5-20220118 +- A couple of concurrency issues have been fixed. + * Mon Aug 10 2020 Ying Zhang <[email protected]> - 11.39.1-20201006 - Finished a first version of the new monitoring function user_statistics(), which is only intended for the DBAs. diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -850,6 +850,28 @@ fi %endif %changelog +* Tue Jan 18 2022 Sjoerd Mullender <[email protected]> - 11.43.5-20220118 +- Rebuilt. + +* Thu Jan 13 2022 Sjoerd Mullender <[email protected]> - 11.43.5-20220118 +- NT: We now build Windows binaries using Visual Studio 2022. + +* Wed Jan 12 2022 Panagiotis Koutsourakis <[email protected]> - 11.43.5-20220118 +- gdk: Implement string imprints (strimps for short) a pre-filter structure + for strings in order to accelerate LIKE queries. If a strimp exists + for a specific string column the strings are pre-filtered, rejecting + strings that cannot possibly match, before the more expensive and + accurate matching algorithms run. + +* Wed Jan 12 2022 Panagiotis Koutsourakis <[email protected]> - 11.43.5-20220118 +- sql: Add string imprints to the existing imprints index creation syntax. On + string column "col" of a table "tbl" marked read only ("ALTER TABLE tbl + SET READ ONLY") the user can create a string imprint using the syntax: + "CREATE IMPRINTS INDEX index_name ON tbl(col);". + +* Wed Jan 12 2022 Sjoerd Mullender <[email protected]> - 11.43.5-20220118 +- MonetDB: A couple of concurrency issues have been fixed. + * Tue Jan 11 2022 Sjoerd Mullender <[email protected]> - 11.43.3-20220111 - Rebuilt. - GH#7215: ODBC Driver SQLStatistics returns duplicate rows/rows for other @@ -862,8 +884,8 @@ fi * Thu Jan 6 2022 Martin van Dinther <[email protected]> - 11.43.3-20220111 - merovingian: Disabled logging into merovingian.log of next info message types: - - proxying client <host>:<port> for database '<dbname>' to <url> - - target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying + "proxying client <host>:<port> for database '<dbname>' to <url>" and + "target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying". These messages were written to the log file at each connection. In most cases this information is not used. The disabling reduces the log file size. @@ -878,18 +900,6 @@ fi result set - GH#7202: DISTINCT does not work when sorting by additional columns -* Mon Jan 3 2022 Panagiotis Koutsourakis <[email protected]> - 11.43.1-20220103 -- gdk: Implement string imprints (strimps for short) a pre-filter structure - for strings in order to accelerate LIKE queries. If a strimp exists - for a specific string column the strings are pre-filtered, rejecting - strings that cannot possibly match, before the more expensive and - accurate matching algorithms run. Strimps are created automatically - or using 'sys.strimp_create' with arguments the names of the schema, - table and column. Automatic strimp creation is controlled by two - user settable gdk options: 'gdk_use_strimps' (default value "no") and - 'gdk_strimps_threshold' (default value 1.000.000). See the manual for - more details. - * Wed Dec 15 2021 Pedro Ferreira <[email protected]> - 11.43.1-20220103 - monetdb5: The storage cleanup in the 11.41.5 (Jul2021) release made the OLTP optimizer pipeline obsolete, thus it was removed. diff --git a/NT/ChangeLog-Archive b/NT/ChangeLog-Archive --- a/NT/ChangeLog-Archive +++ b/NT/ChangeLog-Archive @@ -1,6 +1,9 @@ # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY # This file contains past ChangeLog entries +* Thu Jan 13 2022 Sjoerd Mullender <[email protected]> - 11.43.5-20220118 +- We now build Windows binaries using Visual Studio 2022. + * Fri Apr 23 2021 Sjoerd Mullender <[email protected]> - 11.39.17-20210503 - Added the monetdbe library to the Windows installer. diff --git a/NT/ChangeLog.Jan2022 b/NT/ChangeLog.Jan2022 new file mode 100644 --- /dev/null +++ b/NT/ChangeLog.Jan2022 @@ -0,0 +1,3 @@ +# ChangeLog file for NT +# This file is updated with Maddlog + diff --git a/NT/mkodbcwxs.py b/NT/mkodbcwxs.py --- a/NT/mkodbcwxs.py +++ b/NT/mkodbcwxs.py @@ -82,10 +82,10 @@ def main(): id = 1 print(r' <Directory Id="lib" Name="lib">') id = comp(features, id, 14, - [r'bin\mapi.dll', # r'lib\mapi.pdb', - r'lib\MonetODBC.dll', # r'lib\MonetODBC.pdb', - r'lib\MonetODBCs.dll', # r'lib\MonetODBCs.pdb', - r'bin\stream.dll', # r'lib\stream.pdb', + [r'bin\mapi.dll', r'lib\mapi.pdb', + r'lib\MonetODBC.dll', r'lib\MonetODBC.pdb', + r'lib\MonetODBCs.dll', r'lib\MonetODBCs.pdb', + r'bin\stream.dll', r'lib\stream.pdb', vcpkg.format(r'bin\iconv-2.dll'), vcpkg.format(r'bin\bz2.dll'), vcpkg.format(r'bin\charset-1.dll'), # for iconv-2.dll diff --git a/NT/mksqlwxs.py b/NT/mksqlwxs.py --- a/NT/mksqlwxs.py +++ b/NT/mksqlwxs.py @@ -86,7 +86,7 @@ def main(): print(r' </Property>') print(r' <Property Id="DEBUGEXISTS">') print(r' <DirectorySearch Id="CheckFileDir1" Path="[INSTALLDIR]\bin" Depth="0">') - print(r' <FileSearch Id="CheckFile1" Name="libbat.pdb"/>') + print(r' <FileSearch Id="CheckFile1" Name="mserver5.pdb"/>') print(r' </DirectorySearch>') print(r' </Property>') print(r' <Property Id="INCLUDEEXISTS">') @@ -161,14 +161,14 @@ def main(): vcpkg.format(r'bin\lzma.dll'), vcpkg.format(r'bin\pcre.dll'), vcpkg.format(r'bin\zlib1.dll')]) - # id = comp(debug, id, 14, - # [r'bin\mclient.pdb', - # r'bin\mserver5.pdb', - # r'bin\msqldump.pdb', - # r'lib\libbat.pdb', - # r'lib\libmapi.pdb', - # r'lib\libmonetdb5.pdb', - # r'lib\libstream.pdb']) + id = comp(debug, id, 14, + [r'bin\mclient.pdb', + r'bin\mserver5.pdb', + r'bin\msqldump.pdb', + r'lib\bat.pdb', + r'lib\mapi.pdb', + r'lib\monetdb5.pdb', + r'lib\stream.pdb']) id = comp(geom, id, 14, [vcpkg.format(r'bin\geos_c.dll'), vcpkg.format(r'bin\geos.dll')]) diff --git a/clients/Tests/All b/clients/Tests/All --- a/clients/Tests/All +++ b/clients/Tests/All @@ -1,4 +1,5 @@ exports -HAVE_FITS&HAVE_GEOM&HAVE_LIBR&HAVE_LIBPY3&HAVE_NETCDF&HAVE_SHP&NOT_WIN32?MAL-signatures -#MERCURIAL?malcheck +HAVE_HGE&HAVE_FITS&HAVE_GEOM&HAVE_LIBR&HAVE_LIBPY3&HAVE_NETCDF&HAVE_SHP&NOT_WIN32?MAL-signatures-hge +!HAVE_HGE&HAVE_FITS&HAVE_GEOM&HAVE_LIBR&HAVE_LIBPY3&HAVE_NETCDF&HAVE_SHP&NOT_WIN32?MAL-signatures +NOT_WIN32&MERCURIAL?melcheck mclient-uri diff --git a/clients/Tests/MAL-signatures-hge.test b/clients/Tests/MAL-signatures-hge.test new file mode 100644 --- /dev/null +++ b/clients/Tests/MAL-signatures-hge.test @@ -0,0 +1,65665 @@ +hash-threshold 100000 +query TTTTT nosort +select * from sys.malfunctions() order by module, "function", address, signature, comment +---- +aggr +all +command aggr.all(X_0:bat[:any_1]):any_1 +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; +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(X_0:any_1, X_1:any_1):bit +CMDvarEQ; +(empty) +aggr +anyequal +pattern aggr.anyequal(X_0:bat[:any_1], X_1: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(X_0:bat[:bte], X_1:bat[:oid], X_2:bat[:any_1]):bat[: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; +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; +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; +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; +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; +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; +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; +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; +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; +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; +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; +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; +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; +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; +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; +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; +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; +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; +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; +Grouped tail average on sht, also returns count +aggr _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
