Changeset: f2589c280581 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f2589c280581
Modified Files:
cmake/monetdb-defines.cmake
cmake/monetdb-findpackages.cmake
cmake/monetdb-options.cmake
monetdb5/mal/mal_embedded.c
monetdb_config.h.in
sql/backends/monet5/rel_bin.c
sql/server/rel_updates.c
sql/server/sql_parser.y
tools/mserver/mserver5.c
Branch: parquet
Log Message:
merged with default
diffs (truncated from 50837 to 300 lines):
diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -796,3 +796,13 @@ e8b0e5558313f4d98bc48316368299decc55ed4e
8a95168e853382b9b89ac7b67e343788ea837f3a Jul2021_31
8a95168e853382b9b89ac7b67e343788ea837f3a Jul2021_SP9_release
bb95192134c0d8ef8fea525204eefcd0de099a54 Jun2023_root
+24385ee6130494440e09d31ec73f4aa2e2893e98 Jul2021_33
+05b3d9ea9165baf1d2956d5b06ad85f817ecc6d2 Jul2021_33
+05b3d9ea9165baf1d2956d5b06ad85f817ecc6d2 Jul2021_SP10_release
+ed34ab4283cbfcc57fb9d7387bc9d781c91902b1 Jan2022_27
+ed34ab4283cbfcc57fb9d7387bc9d781c91902b1 Jan2022_SP7_release
+d11af9398029c117b92a9be9efa971ac0299ffc4 Sep2022_15
+8b736d6dcfd63d0560c99fc5427b504c116b74b0 Sep2022_17
+8b736d6dcfd63d0560c99fc5427b504c116b74b0 Sep2022_SP3_release
+aba8c31c60480148cd388a09ac99b42679406258 Jun2023_1
+79dbf838f04483a2d9ccce8332090ff91b18caec Jun2023_3
diff --git a/CMakeLists.txt b/CMakeLists.txt
--- a/CMakeLists.txt
+++ b/CMakeLists.txt
@@ -54,7 +54,6 @@ include(monetdb-toolchain)
monetdb_default_compiler_options()
include(monetdb-defines)
-monetdb_hg_revision()
# required for symbol existance tests
if(${CMAKE_SYSTEM_NAME} STREQUAL "Linux")
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-SP2/%{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)
@@ -432,6 +432,7 @@ install it.
Summary: Integration of MonetDB and Python, allowing use of Python from within
SQL
Group: Applications/Databases
Requires: MonetDB5-server%{?_isa} = %{version}-%{release}
+Requires: python3-numpy
%description python3
MonetDB is a database management system that is developed from a
@@ -859,6 +860,222 @@ fi
%endif
%changelog
+* Thu Jun 22 2023 Sjoerd Mullender <sjo...@acm.org> - 11.47.3-20230622
+- Rebuilt.
+- GH#7344: Database upgrade failure due to user object dependency on
+ system procedure
+- GH#7378: MonetDB server crashes at sql_trans_copy_key
+- GH#7379: MonetDB server 11.46.0 crashes at cs_bind_ubat
+- GH#7380: MonetDB server 11.46.0 crashes at `BLOBcmp`
+- GH#7381: MonetDB server 11.46.0 crashes at `log_create_delta`
+- GH#7382: MonetDB server 11.46.0 crashes at `gc_col`
+- GH#7383: MonetDB server 11.46.0 crashes at `list_append`
+- GH#7384: MonetDB server 11.46.0 crashes at `__nss_database_lookup`
+- GH#7386: MonetDB server 11.46.0 crashes in `rel_deps`
+- GH#7387: MonetDB server 11.46.0 crashes in `rel_sequences`
+
+* Tue Jun 20 2023 Sjoerd Mullender <sjo...@acm.org> - 11.47.3-20230622
+- clients: The COPY INTO from file ON CLIENT was extended to also look for a
+ relative path name relative to the file from which the query was read.
+ This is only possible if the name of the query file is known, so when
+ it is specified on the command line or read using the interactive
+ \< command.
+
+* Fri Jun 16 2023 Joeri van Ruth <joeri.van.r...@monetdbsolutions.com> -
11.47.3-20230622
+- sql: Add MAX_MEMORY and MAX_WORKERS options to the ALTER USER statement
+
+* 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.
+
+* 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
+ to the database (e.g. in case more than 2 billion rows are added to
+ a table).
+- sql: Improved cleanup after failures such as failed memory allocations.
+
+* Mon Feb 20 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.15-20230530
+- gdk: A race condition was fixed where certain write-ahead log messages
+ could get intermingled, resulting in a corrupted WAL file.
+- gdk: If opening of a file failed when it was supposed to get memory mapped,
+ an incorrect value was returned to indicate the failure, causing
+ crashes later on. This has been fixed.
+
+* Thu Feb 16 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.15-20230530
+- gdk: A race condition was fixed that could result in a missing tail file
+ for a string bat (i.e. a file with .tail1, .tail2, or .tail4 extension).
+
+* Mon Feb 13 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.15-20230530
+- gdk: When saving a bat failed for some reason during a low-level commit,
+ this was logged in the log file, but the error was then subsequently
+ ignored, possibly leading to files that are too short or even missing.
+- gdk: The write-ahead log (WAL) is now rotated a bit more efficiently by
+ doing multiple log files in one go (i.e. in one low-level transaction).
+
+* Mon Feb 13 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.15-20230530
+- sql: An insert into a table from which a column was dropped in a parallel
+ transaction was incorrectly not flagged as a transaction conflict.
+
+* Thu Jan 26 2023 Joeri van Ruth <joeri.van.r...@monetdbsolutions.com> -
11.45.15-20230530
+- sql: Fix bug where boolean NULLs were not recognized by COPY BINARY INTO
+
* Tue Jan 24 2023 Sjoerd Mullender <sjo...@acm.org> - 11.45.13-20230124
- Rebuilt.
- GH#7343: GDKmmap requesting 0 virtual memory
@@ -1196,337 +1413,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
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
