Announcement: New Apr2019-SP1 Bugfix release of MonetDB suite

Sjoerd Mullender sjoerd at
Mon Sep 2 16:12:35 CEST 2019

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

For details on this release, please see the release notes at

As usual, the download location is <>.

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

   Bug Fixes
     * 6576: Sqlitelogictest aritmetic expressions with negative numbers
     * 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
     * 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
     * 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
     * 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
     * 6751: ODBC driver(11.33.3) Seg Faults when "fn ucase" is used in

More information about the announce-list mailing list