Announcement: New Apr2019-SP1 Bugfix release of MonetDB suite

Sjoerd Mullender sjoerd at acm.org
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
<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


More information about the developers-list mailing list