The MonetDB team at CWI/MonetDB BV is pleased to announce the
Apr2019-SP1 bugfix release of the MonetDB suite of programs.
More information about MonetDB can be found on our website at
<https://www.monetdb.org/>.
For details on this release, please see the release notes at
<https://www.monetdb.org/Downloads/ReleaseNotes>.
As usual, the download location is <https://dev.monetdb.org/downloads/>.
Apr 2019-SP1 bugfix release (11.33.11)
Build Environment
* Removed restriction on using combinations of --enable-assert,
--enable-debug, and --enable-optimize. --enable-debug adds a -g (or
-even -g3) option, --enable-debug=gdb adds a -ggdb3 flag (for GCC);
--enable-optimize adds a bunch of optimization flags;
--disable-debug (or --enable-debug=no) removes any -g flags;
--disable-optimize removes any -O flags; --enable-optimize=auto
leaves the optimization flags untouched.
MonetDB Common
* We now look at the limits imposed by cgroups and the setrlimit
system call to initialize some internal values related to how much
(virtual) memory we think is available.
SQL Frontend
* Many fixes for using the server in a highly concurrent setting with
many clients doing read-only queries mixed with clients doing
updating queries.
* Changed the internal representation of RANGE MINVALUE and RANGE
MAXVALUE in MERGE TABLE partitions. Before, the limits were
represented by the smallest and largest value of the domain of the
column, now these are represented by a NULL value. This has the
added benefit that if you use TO RANGE MAXVALUE, the largest value
of the domain is included in the partition (before it wasn't).
Also, these new limits now work for any ordered type, so including
VARCHAR.
Bug Fixes
* 6576: Sqlitelogictest aritmetic expressions with negative numbers
handling
* 6697: Duplicate expressions not eliminated with long CASE statement
* 6701: When changing the schema name of a table, referencing rows
from sys.columns, sys.keys and more tables are not removed
* 6703: SQL optimizer enters loop and goes into stack overflow
* 6706: prepare doesn't recognize merge statement
* 6712: Where clause with cast ignores sub-select
* 6713: COPY INTO FROM 'file.xz' does not work
* 6714: Assertion failure in rel_select.c for correlated subquery in
aggregation query (with group by and having and order by and limit)
* 6715: Assertion failure in rel_bin.c for MERGE INTO command
* 6716: COPY INTO does not load UTF8 encoded text
* 6718: Can't copy table into another table with constraints
(mkey.bulk_rotate_xor_hash)
* 6720: Compilation issues on gcc 9.1.1 [-Werror=stringop-truncation]
* 6721: Possibly incorrect call to pcre_exec
* 6725: Prepare statement on non-existing function crashes
* 6728: SELECT DISTINCT not removing duplicates
* 6729: Creating a table with duplicate column name should not be
possible
* 6730: sys.stop or sys.pause a INSERT query triggers "BATproject:
does not match always"
* 6736: Unexpected query result with merge tables and view after
upgrade
* 6738: issue with window functions and hugeint type coercion
* 6741: report no such table when execute “alter table tb1 rename to
tb2” according to using mapi
* 6744: CREATE SEQUENCE seq; fails
* 6748: MonetDB "forgets" columns after ALTER TABLE statements
* 6749: mserver5 restart aborts/segfaults after dropping column with
constraint
* 6751: ODBC driver(11.33.3) Seg Faults when "fn ucase" is used in
SQL
