Changeset: 38f1ee2374db for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/38f1ee2374db Modified Files: clients/Tests/MAL-signatures-hge.test clients/Tests/MAL-signatures.test clients/Tests/exports.stable.out gdk/gdk.h gdk/gdk_bat.c sql/backends/monet5/sql.c sql/storage/bat/bat_storage.c sql/storage/sql_storage.h sql/storage/store.c Branch: nilmask Log Message:
merged with default diffs (truncated from 27672 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -804,3 +804,4 @@ ed34ab4283cbfcc57fb9d7387bc9d781c91902b1 d11af9398029c117b92a9be9efa971ac0299ffc4 Sep2022_15 8b736d6dcfd63d0560c99fc5427b504c116b74b0 Sep2022_17 8b736d6dcfd63d0560c99fc5427b504c116b74b0 Sep2022_SP3_release +aba8c31c60480148cd388a09ac99b42679406258 Jun2023_1 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/Sep2022-SP3/%{name}-%{version}.tar.bz2 +Source: https://www.monetdb.org/downloads/sources/Jun2023/%{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 @@ -118,7 +118,7 @@ BuildRequires: pkgconfig(readline) BuildRequires: pkgconfig(cfitsio) %endif %if %{with geos} -BuildRequires: geos-devel >= 3.4.0 +BuildRequires: geos-devel >= 3.10.0 %endif BuildRequires: pkgconfig(libcurl) BuildRequires: pkgconfig(liblzma) @@ -860,6 +860,120 @@ fi %endif %changelog +* Fri Jun 16 2023 Sjoerd Mullender <sjo...@acm.org> - 11.47.1-20230616 +- Rebuilt. +- GH#7311: Missing `REGEXP_REPLACE` function. +- GH#7348: Subquery inside case always evaluated + +* Tue Jun 6 2023 Lucas Pereira <lucas.pere...@monetdbsolutions.com> - 11.47.1-20230616 +- sql: Function 'similarity(x string, y string)' marked as deprecated and will + be removed in the next release. + +* Tue Jun 6 2023 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.47.1-20230616 +- odbc: Extended Windows MonetDB ODBC Data Source setup program with option + to specify a logfile to enable tracing of ODBC Driver API calls. + On other platforms users can edit the odbc.ini file and add a line: + logfile=/home/username/odbctrace.log + When a logfile is specified it will start logging the ODBC Driver API calls + to the logfile after a new connection is made via SQLConnect() or + SQLDriverConnect() or SQLBrowseConnect(). + Note that enabling ODBC logging will slow down the performance of ODBC + applications, so enable it only for analysing ODBC Driver problems. + +* Tue Jun 6 2023 Lucas Pereira <lucas.pere...@monetdbsolutions.com> - 11.47.1-20230616 +- sql: New functionality for string matching and similarity: startswith, + endswith, contains, Levenshtein distance and Jaro-Winkler similarity. + The functions startswith, endswith and contains have a version where + a case insentive flag can be used. + Also, there are new custom join functionality for startswith, endswith, + contains, Levenshtein distance and Jaro-Winkler similarity. +- sql: Renamed previous Levenshtein distance to Damerau-Levenshtein distance. +- sql: New string function that transform from UTF-8 encoding to Ascii called + asciify. + +* Tue Jun 6 2023 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.47.1-20230616 +- odbc: Enhanced SQLTables() by adding support for table type names: 'BASE TABLE', + 'GLOBAL TEMPORARY' and 'LOCAL TEMPORARY' in parameter TableType. These are + synonyms of: 'TABLE', 'GLOBAL TEMPORARY TABLE' and 'LOCAL TEMPORARY TABLE'. + +* Tue Jun 6 2023 Lucas Pereira <lucas.pere...@monetdbsolutions.com> - 11.47.1-20230616 +- sql: Session timeout feature improvement to start evaluating from the moment + the procedure is called, instead of beginning of the session. + +* Tue Jun 6 2023 Lucas Pereira <lucas.pere...@monetdbsolutions.com> - 11.47.1-20230616 +- sql: Queries stopped with the stop procedure are now marked as 'aborted' + 'finished'. + +* Tue Jun 6 2023 Niels Nes <ni...@monetdbsolutions.com> - 11.47.1-20230616 +- monetdb5: The MAL debugger code has been removed. + +* Tue Jun 6 2023 Niels Nes <ni...@monetdbsolutions.com> - 11.47.1-20230616 +- sql: The DEBUG statement has been removed. + +* Tue Jun 6 2023 Lucas Pereira <lucas.pere...@monetdbsolutions.com> - 11.47.1-20230616 +- sql: SQL function sys.queue() overloaded with sys.queue(username string), + SYSADMIN only, allowing to filter the global queue by username or + use 'ALL' to retrieve the global queue. Calling the function without + arguments returns the queue for the current user. +- sql: SQL procedures sys.pause(tag bigint), sys.resume(tag bigint), + sys.stop(tag bigint) overloaded with sys.pause(tag bigint, username string), + sys.resume(tag bigint, username string) and sys.stop(tag bigint, username + string), SYSADMIN only, allowing to pause, resume and stop query + executions by TAG, USERNAME. The call without arguments is a public + procedure giving access to users to pause, resume and stop their + own query executions. + +* Tue Jun 6 2023 svetlin <svetlin.stali...@monetdbsolutions.com> - 11.47.1-20230616 +- sql: Added support of ODBC escape sequences syntax to SQL layer. Now all clients + (including ODBC/JDBC/pymonetdb) can use them without further processing. + For details on ODBC escape sequences syntax see: + https://learn.microsoft.com/en-us/sql/odbc/reference/appendixes/odbc-escape-sequences + +* Tue Jun 6 2023 Aris Koning <aris.kon...@monetdbsolutions.com> - 11.47.1-20230616 +- merovingian: The monetdb get, inherit, lock and release commands are extended with + ‘apply-to-all’ syntax similar to related functionality: + Usage: monetdb set property=value [database ...] + sets property to value for the given database(s), or all + Usage: monetdb inherit property [database ...] + unsets property, reverting to its inherited value from the + default configuration for the given database(s), or all + Usage: monetdb lock [-a] database [database...] + Puts the given database in maintenance mode. + Options: + -a locks all known databases + Usage: monetdb release [-a] database [database ...] + Brings back a database from maintenance mode. + Options: + -a releases all known databases + +* Tue Jun 6 2023 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.47.1-20230616 +- sql: It is no longer allowed to create a merge table or remote table or + replica table or unlogged table in schema "tmp". The tmp schema is + reserved for temporary objects only, such as local/global temp tables. + +* Tue Jun 6 2023 Martin van Dinther <martin.van.dint...@monetdbsolutions.com> - 11.47.1-20230616 +- sql: System views sys.dependency_tables_on_functions and + dependency_views_on_functions have been extended with column: function_id. + +* Tue Jun 6 2023 Joeri van Ruth <joeri.van.r...@monetdbsolutions.com> - 11.47.1-20230616 +- mapilib: Deprecate mapi_setfilecallback() in favor of mapi_setfilecallback2() which + can handle binary downloads. For the time being, the old callback still works. + +* Tue Jun 6 2023 Joeri van Ruth <joeri.van.r...@monetdbsolutions.com> - 11.47.1-20230616 +- sql: When loading data using COPY BINARY INTO, apply default values instead of just + inserting NULLs. +- sql: When loading data using COPY BINARY INTO, validate DECIMAL(prec,scale) and + VARCHAR(n) column width. +- sql: When loading data using COPY BINARY INTO, string used to have their line + endings converted from CR LF to LF. Do not do this, it is the responsibility + of the client. +- sql: Implemented dumping binary data using COPY SELECT ... INTO BINARY <file(s)>. + +* Tue Jun 6 2023 Sjoerd Mullender <sjo...@acm.org> - 11.47.1-20230616 +- sql: Removed code for Workload Capture and Replace, including system schemas + "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. @@ -1275,337 +1389,3 @@ fi clamp the result to the calculated month instead of wrapping to the beginning of the next month. See bug 7227. -* Fri Aug 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.21-20220819 -- Rebuilt. - -* Mon Aug 15 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.19-20220815 -- Rebuilt. - -* Thu Aug 11 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.17-20220811 -- Rebuilt. -- GH#7040: Memory leak detected for MAPI interface -- GH#7298: Irresponsive database server after reading incomplete SQL - script. -- GH#7308: Race condition in MVCC transaction management - -* Wed Aug 10 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.17-20220811 -- gdk: A bug was fixed when upgrading a database from the Oct2020 releases - (11.39.X) or older when the write-ahead log (WAL) was not empty and - contained instructions to create new tables. - -* Tue Aug 2 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.17-20220811 -- gdk: When destroying a bat, make sure there are no files left over in - the BACKUP directory since they can cause problems when the bat id - gets reused. - -* Thu Jul 28 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.17-20220811 -- gdk: Fixed an off-by-one error in the logger which caused older log files - to stick around longer in the write-ahead log than necessary. -- gdk: When an empty BAT is committed, skip writing (and synchronizing to - disk) the heap (tail and theap) files and write 0 for their sizes to - the BBP.dir file. When reading the BBP.dir file, if an empty BAT is - encountered, set the sizes of those files to 0. This fixes potential - issues during startup of the server (BBPcheckbats reporting errors). - -* Thu Jun 23 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.17-20220811 -- merovingian: When multiple identical messages are written to the log, write the - first one, and combine subsequent ones in a single message. - -* Wed Jun 22 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.17-20220811 -- gdk: Make sure heap files of transient bats get deleted when the bat is - destroyed. If the bat was a partial view (sharing the vheap but not - the tail), the tail file wasn't deleted. -- gdk: Various changes were made to satisfy newer compilers. -- gdk: The batDirtydesc and batDirtyflushed Boolean values have been deprecated - and are no longer used. They were both holdovers from long ago. -- gdk: Various race conditions (data races) have been fixed. - -* Wed Jun 22 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.17-20220811 -- merovingian: Fixed a leak where the log file wasn't closed when it was reopened - after a log rotation (SIGHUP signal). -- merovingian: Try to deal more gracefully with "inherited" mserver5 processes. - This includes not complaining about an "impossible state", and allowing - such processes to be stopped by the monetdbd process. -- merovingian: When a transient failure occurs during processing of a new connection to - the monetdbd server, sleep for half a second so that if the transient - failure occurs again, the log file doesn't get swamped with error - messages. - -* Wed Jun 22 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.17-20220811 -- monetdb5: Various race conditions (data races) have been fixed. - -* Fri Jun 10 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.17-20220811 -- clients: Implemented dump of global grants, that is to say, grants for COPY INTO - and COPY FROM which grant permission to users to write to or read from - files on the server (COPY INTO queries without the ON CLIENT option). - -* Tue May 31 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.17-20220811 -- clients: Fixed a bug where when the semicolon at the end of a COPY INTO query - that reads from STDIN is at exactly a 10240 byte boundary in a file, - the data isn't read as input for the COPY INTO but instead as a new - SQL query. - -* Fri May 20 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.17-20220811 -- gdk: All accesses to the BACKUP directory need to be protected by the - same lock. The lock already existed (GDKtmLock), but wasn't used - consistently. This is now fixed. Hopefully this makes the hot snapshot - code more reliable. - -* Fri May 20 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.15-20220520 -- Rebuilt. -- GH#7036: Generate column names instead of labels - -* Thu May 19 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.15-20220520 -- gdk: All accesses to the BACKUP directory need to be protected by the - same lock. The lock already existed (GDKtmLock), but wasn't used - consistently. This is now fixed. Hopefully this makes the hot snapshot - code more reliable. - -* Tue May 10 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.15-20220520 -- gdk: When exiting, long running instructions are aborted using the same - mechanism that is used for query timeouts. - -* Mon Apr 25 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.15-20220520 -- sql: GLOBAL TEMPORARY tables are now treated like LOCAL TEMPORARY tables - as far as the table content is concerned. The schema information - stays global. This fixes an issue with concurrent access and cleanup - of stale data. - -* Thu Apr 14 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.15-20220520 -- sql: The NO CONSTRAINT option of the COPY INTO query has been removed. - It didn't work and it was never a good idea anyway. - -* Fri Apr 01 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.13-20220401 -- Rebuilt. -- GH#7278: BUG when there is more than one field/filter in the having - clause - -* Fri Apr 1 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.13-20220401 -- gdk: Improved speed of BATappend to empty varsized bat: we now just copy - the heaps instead of inserting individual values. - -* Fri Apr 1 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.13-20220401 -- monetdb5: Improved parsing speed of blob values, especially on Windows. - On Windows, using the locale-aware functions isdigit and isxdigit is - comparatively very slow, so we avoid them. - -* Tue Mar 29 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.13-20220401 -- gdk: Improved speed of projection (BATproject) on varsized bats by sharing - the data heap (vheap). - -* Fri Mar 25 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.11-20220325 -- Rebuilt. -- GH#7252: Segmentation fault on second run -- GH#7253: Extremely slow INSERT INTO <table> SELECT -- GH#7254: Commit with deletions is very slow -- GH#7263: PRIMARY KEY constraint is not persistent through server restarts -- GH#7267: Update after delete does not update some rows - -* Fri Mar 18 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.11-20220325 -- gdk: Fixed a race condition which could cause a too large size being written - for a .theap file to the BBP.dir file after the correct size file had - been saved to disk. -- gdk: We now ignore the size and capacity columns in the BBP.dir file. - These values are essential during run time, but not useful in the - on-disk image of the database. - -* Wed Mar 9 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.11-20220325 -- gdk: Fixed a bug in the append code for msk (bit mask) bats. -- gdk: Conversions from floating point types to integral types that involve - multiplication now use the "long double" as intermediate type, thereby - loosing as few significant bits as is feasible. -- gdk: Found and fixed another source for the now infamous BBPcheckbats error - that sometimes occurs at startup of the server. - -* Wed Feb 16 2022 Sjoerd Mullender <sjo...@acm.org> - 11.43.11-20220325 -- clients: Improved the handling of the \r (internal pager) command in mclient. - It now properly counts the header of table, and when a (very) long - table is being printed and aborted part way in the built-in pager, not _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
