Changeset: 87e9f956e042 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/87e9f956e042 Modified Files: MonetDB.spec cmake/monetdb-versions.cmake debian/control Branch: default Log Message:
Merge with Dec2023 branch. diffs (truncated from 2290 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -818,3 +818,4 @@ 5683fd900f28d65ad7c98d1ed1efd992023a7fa4 c5b17681b55e6ca155db28be59913699e561502a Dec2023_root c9e6096e7519636a4e840c7a0c2e27cccb7dc0fe Jun2023_17 c9e6096e7519636a4e840c7a0c2e27cccb7dc0fe Jun2023_SP3_release +1230526af30f40eeea30fb87c47c3e414920561f Dec2023_1 diff --git a/ChangeLog-Archive b/ChangeLog-Archive --- a/ChangeLog-Archive +++ b/ChangeLog-Archive @@ -1,6 +1,28 @@ # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY # This file contains past ChangeLog entries +* Fri Dec 1 2023 Sjoerd Mullender <sjo...@acm.org> - 11.49.1-20231221 +- All binary packages are now signed with a new key with key fingerprint + DBCE 5625 94D7 1959 7B54 CE85 3F1A D47F 5521 A603. + +* Mon Oct 30 2023 Sjoerd Mullender <sjo...@acm.org> - 11.49.1-20231221 +- The ranges of merge partitions are now pushed down into the low + level GDK operations, giving them a handle to sometimes execute more + efficiently. + +* Thu Jul 27 2023 Niels Nes <ni...@cwi.nl> - 11.49.1-20231221 +- Removed the PYTHON MAP external language option, as after a fork the + synchronization primitives could be in any state, leading to deadlocks. + During the upgrade function definitions will fallback to the normal + PYTHON language option. + +* Mon Jul 17 2023 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 11.49.1-20231221 +- Implemented direct masking for strimp construction. The strimps + datastructure now keeps an array of 65K 64-bit integers that is zero + everywhere except at the indexes that correspond to header pairs. The + entry for the nth pair in order has the nth bit of the bitstring + on. These can be used to quickly construct bitstrings. + * Fri Sep 29 2023 Sjoerd Mullender <sjo...@acm.org> - 11.47.11-20230929 - Fixed an installation issue on Debian and Ubuntu introduced in the last build. diff --git a/ChangeLog.Dec2023 b/ChangeLog.Dec2023 --- a/ChangeLog.Dec2023 +++ b/ChangeLog.Dec2023 @@ -1,24 +1,3 @@ # ChangeLog file for devel # This file is updated with Maddlog -* Fri Dec 1 2023 Sjoerd Mullender <sjo...@acm.org> -- All binary packages are now signed with a new key with key fingerprint - DBCE 5625 94D7 1959 7B54 CE85 3F1A D47F 5521 A603. - -* Mon Oct 30 2023 Sjoerd Mullender <sjo...@acm.org> -- The ranges of merge partitions are now pushed down into the low - level GDK operations, giving them a handle to sometimes execute more - efficiently. - -* Thu Jul 27 2023 Niels Nes <ni...@cwi.nl> -- Removed the PYTHON MAP external language option, as after a fork the - synchronization primitives could be in any state, leading to deadlocks. - During the upgrade function definitions will fallback to the normal - PYTHON language option. - -* Mon Jul 17 2023 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> -- Implemented direct masking for strimp construction. The strimps - datastructure now keeps an array of 65K 64-bit integers that is zero - everywhere except at the indexes that correspond to header pairs. The - entry for the nth pair in order has the nth bit of the bitstring - on. These can be used to quickly construct bitstrings. diff --git a/ChangeLog.Jun2023 b/ChangeLog.Jun2023 deleted file mode 100644 --- a/ChangeLog.Jun2023 +++ /dev/null @@ -1,3 +0,0 @@ -# ChangeLog file for devel -# This file is updated with Maddlog - diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -89,7 +89,7 @@ Group: Applications/Databases License: MPL-2.0 URL: https://www.monetdb.org/ BugURL: https://github.com/MonetDB/MonetDB/issues -Source: https://www.monetdb.org/downloads/sources/Jun2023-SP3/%{name}-%{version}.tar.bz2 +Source: https://www.monetdb.org/downloads/sources/Dec2023/%{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 @@ -915,6 +915,158 @@ fi %endif %changelog +* Thu Dec 21 2023 Sjoerd Mullender <sjo...@acm.org> - 11.49.1-20231221 +- Rebuilt. +- GH#6933: Add support for scalar function IFNULL(expr1, expr2) +- GH#7044: Improve error message regarding 3-level SQL names +- GH#7261: Misleading error message +- GH#7274: Aggregate function ST_Collect crashes mserver5 +- GH#7376: Concurrency Issue: Second Python UDF Awaits Completion of First + UDF +- GH#7391: SQL 2023 : greatest/least functions with unlimited arguments + (not only 2) +- GH#7403: Join not recognized between two row_number() columns +- GH#7413: MonetDB server crashes in `BATcalcbetween_intern` + +* Tue Dec 19 2023 Sjoerd Mullender <sjo...@acm.org> - 11.49.1-20231221 +- monetdb5: Removed MAL functions bat.reuse and bat.reuseMap. + +* Tue Dec 12 2023 Lucas Pereira <lucas.pere...@monetdbsolutions.com> - 11.49.1-20231221 +- gdk: Introduced options wal_max_dropped, wal_max_file_age and + wal_max_file_size that control the write-ahead log file rotation. + +* Wed Dec 6 2023 Sjoerd Mullender <sjo...@acm.org> - 11.49.1-20231221 +- monetdb5: The MAL functions io.import and io.export have been removed. + +* Tue Dec 5 2023 Lucas Pereira <lucas.pere...@monetdbsolutions.com> - 11.49.1-20231221 +- sql: Introduction of table returning function `persist_unlogged(schema + string, table string)` that attempts to persist data in disk if + "schema"."table" is unlogged table in insert only mode. If persist + attempt is successful, the count of the persisted rows is returned, + otherwise the count is 0. + +* Fri Dec 1 2023 Sjoerd Mullender <sjo...@acm.org> - 11.49.1-20231221 +- MonetDB: All binary packages are now signed with a new key with key fingerprint + DBCE 5625 94D7 1959 7B54 CE85 3F1A D47F 5521 A603. + +* Thu Nov 30 2023 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.49.1-20231221 +- odbc: Corrected the output value of column CHAR_OCTET_LENGTH of ODBC functions + SQLColumns() and SQLProcedureColumns(). + +* Thu Nov 23 2023 Sjoerd Mullender <sjo...@acm.org> - 11.49.1-20231221 +- geom: Because recent changes to the geom module require the use of geos + 3.10, the geom module is no longer available in older versions of + Debian and Ubuntu. Specifically, Debian 10 and 11 (buster and + bullseye) and Ubuntu 20.04 (Focal Fossa) are affected. There is no + automatic upgrade available for databases that were geom enabled to + databases that are not, so dump + restore is the only option (if no + geom types are actually used). + +* Thu Nov 23 2023 stefanos mavros <stemav...@gmail.com> - 11.49.1-20231221 +- geom: Implements Rtree index in GDK layer based on librtree. The index is + used in the implementation of the filter functions ST_Intersects and + ST_Dwithin for geometric points. +- geom: Improves shapefile support by replacing functions SHPattach, + SHPpartialimport, ahd SHPimport with SHPload. +- geom: Introduces functions ST_DistanceGeographic, ST_DwithinGeographic, + ST_IntersectsGeographic, ST_CoversGeographic, ST_Collects with geodesic + semantics. ST_Transform can be used to convert geodetic into geographic + data using libPROJ. + +* Tue Nov 21 2023 Sjoerd Mullender <sjo...@acm.org> - 11.49.1-20231221 +- gdk: Fixed a (rare) race condition between copying a bat (COLcopy) and + updates happening in parallel to that same bat. This may only be + an actual problem with string bats, and then only in very particular + circumstances. + +* Mon Nov 20 2023 Sjoerd Mullender <sjo...@acm.org> - 11.49.1-20231221 +- gdk: Removed function BATroles to set column names on BATs. + +* Mon Nov 20 2023 Sjoerd Mullender <sjo...@acm.org> - 11.49.1-20231221 +- monetdb5: Removed MAL functions bat.getRole and bat.setColumn since the + underlying function BATroles was removed. + +* Thu Nov 16 2023 Sjoerd Mullender <sjo...@acm.org> - 11.49.1-20231221 +- gdk: Removed the compiled-in limit on the number of threads that can be used. + The number of threads are still limited, but the limit is dictated + solely by the operating system and the availability of enough memory. + +* Thu Nov 16 2023 Sjoerd Mullender <sjo...@acm.org> - 11.49.1-20231221 +- MonetDB: The ranges of merge partitions are now pushed down into the low + level GDK operations, giving them a handle to sometimes execute more + efficiently. + +* Thu Nov 16 2023 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 11.49.1-20231221 +- monetdb5: Change how json is stored in the database: We now normalize json + strings after parsing, removing whitespace and eliminating duplicate + keys in objects. +- monetdb5: The function json.filter now properly returns json scalars instead of + wrapping them in an array. + +* Thu Nov 16 2023 Sjoerd Mullender <sjo...@acm.org> - 11.49.1-20231221 +- gdk: We now prevent accidental upgrades from a database without 128 bit + integers to one with 128 bit integers (also known as HUGEINT) from + happening. Upgrades will only be done if the server is started with + the option --set allow_hge_upgrade=yes. + +* Thu Nov 16 2023 Sjoerd Mullender <sjo...@acm.org> - 11.49.1-20231221 +- monetdb5: Removed the MAL tokenizer module. It was never usable from SQL and + in this form never would be. + +* Thu Nov 16 2023 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.49.1-20231221 +- sql: Added ISO/IEC 9075-11 SQL/Schemata (SQL:2011) with SQL system views: + information_schema.schemata + information_schema.tables + information_schema.views + information_schema.columns + information_schema.character_sets + information_schema.check_constraints + information_schema.table_constraints + information_schema.referential_constraints + information_schema.routines + information_schema.parameters + information_schema.sequences + For details see + https://www.monetdb.org/documentation/user-guide/sql-catalog/information_schema/ + Most views have been extended (after the standard columns) with MonetDB + specific information columns such as schema_id, table_id, column_id, etc. + This simplifies filtering and joins with system tables/views in sys schema + when needed. + Note: MonetDB does NOT support catalog qualifiers in object names, so all the + CATALOG columns in these information_schema views will always return NULL. + +* Thu Nov 16 2023 Niels Nes <niels....@monetdbsolutions.com> - 11.49.1-20231221 +- sql: Added support for generated column syntax: + GENERATED BY DEFAULT AS IDENTITY ... + This allows the user to override the default generated sequence value + during inserts. + +* Thu Nov 16 2023 Niels Nes <ni...@cwi.nl> - 11.49.1-20231221 +- MonetDB: Removed the PYTHON MAP external language option, as after a fork the + synchronization primitives could be in any state, leading to deadlocks. + During the upgrade function definitions will fallback to the normal + PYTHON language option. + +* Thu Nov 16 2023 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 11.49.1-20231221 +- MonetDB: Implemented direct masking for strimp construction. The strimps + datastructure now keeps an array of 65K 64-bit integers that is zero + everywhere except at the indexes that correspond to header pairs. The + entry for the nth pair in order has the nth bit of the bitstring + on. These can be used to quickly construct bitstrings. + +* Thu Nov 16 2023 Niels Nes <niels....@monetdbsolutions.com> - 11.49.1-20231221 +- sql: Added SQL support for: <result offset clause> and <fetch first clause> + in <query expression> ::= + [ <with clause> ] <query expression body> + [ <order by clause> ] + [ <result offset clause> ] + [ <fetch first clause> ] + [ <sample clause> ] + <result offset clause> ::= + OFFSET <offset row count> [ {ROW|ROWS} ] + <fetch first clause> ::= + FETCH {FIRST|NEXT} <fetch first row count> {ROW|ROWS} ONLY + * Thu Nov 16 2023 Sjoerd Mullender <sjo...@acm.org> - 11.47.17-20231116 - Rebuilt. @@ -1159,418 +1311,3 @@ fi "wlc" and "wlr" and the objects in those schemas. The code was experimental, and it didn't work out. A different approach will be taken. -* Tue Jun 06 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.17-20230606 -- Rebuilt. - -* Tue Jun 6 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.17-20230606 -- sql: Fixed a regression introduced in the previous build: when a table is - dropped in the same transaction where it was created, the data wasn't - removed from disk. - -* Tue May 30 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.15-20230530 -- Rebuilt. -- GH#7360: Aggregates returning string crash -- GH#7361: Table data is lost on DB restart, but only when a table has - 2147483647 or more rows. - -* Tue May 16 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.15-20230530 -- gdk: Warnings and informational messages are now sent to stdout instead of - stderr, which means that monetdbd will now log them with the tag MSG - instead of ERR. - -* Tue Apr 25 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.15-20230530 -- gdk: Fixed parsing of the BBP.dir file when BAT ids grow larger than 2**24 - (i.e. 100000000 in octal). - -* Thu Apr 20 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.15-20230530 -- gdk: Fixed yet another occurrence of a missing .tailN file. This one could - happen if a string bat was appended to in stages so that between appends - the column was committed. If an append caused both a realloc of the - tail heap because it was getting longer and a realloc because it got - wider, the file might get removed before the GDK level commit happened. - -* Mon Apr 17 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.15-20230530 -- clients: If the number of rows in mclient is set to 0 (using either --rows=0 - option or \r0 on the mclient command line), the internal pager is used - and it then uses the height of the terminal window. - -* Wed Apr 5 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.15-20230530 -- sql: When creating a hot snapshot, allow other clients to proceed, even - with updating queries. - -* Fri Mar 24 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.15-20230530 -- gdk: When processing the WAL, if a to-be-destroyed object cannot be found, - don't stop, but keep processing the rest of the WAL. - -* Fri Mar 24 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.15-20230530 -- monetdb5: Client connections are cleaned up better so that we get fewer instances - of clients that cannot connect. - -* Fri Mar 24 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.15-20230530 -- sql: Increased the size of a variable counting the number of changes made _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
