Announcement: New Jul2017-SP4 Bugfix release of MonetDB suite

Sjoerd Mullender sjoerd at
Mon Feb 12 16:12:21 CET 2018

The MonetDB team at CWI/MonetDB BV is pleased to announce the
Jul2017-SP4 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 <>.

Jul 2017-SP4 bugfix release (11.27.13)

   Build Environment
     * Added the .lib and .h files needed for building extensions to the
       Windows installer.

   Bug Fixes
     * 3470: Support setClob without length restrictions
     * 6468: JDBC 2.27 fails with year < 1000
     * 6482: Query failures on order by on union
     * 6483: Monetdb crashes, on query
     * 6487: UNION of NULLs with several tables fails
     * 6488: Semijoin returns duplicate values from a column with unique
     * 6489: Sqlitelogictest - Wrong result set of complex conditional
     * 6490: Sqlitelogictest - Select query with an IN clause parse error
     * 6491: SELECT IN returns NULL instead of false when not found
     * 6492: Persistent hashes stored and then ignored. Storage info not
       in sync with actual indices.
     * 6493: Sqlitelogictest - Aggregation query on empty table with
       DISTINCT clause
     * 6494: Sqlitelogictest - Algebra operators priority in select query
     * 6495: Sqlitelogictest - Omitting AS in a result set column alias
     * 6496: Sqlitelogictest - Select interval comparisons between
       floating-points and NULL
     * 6497: Sqlitelogictest - Select not between query producing wrong
     * 6498: large virtual memory spike on BLOB column COUNT
     * 6499: Crash when trying to replace a function defined in sys from a
       different schema
     * 6502: Query with multiple limit clauses does not return anything
     * 6508: Segmentation fault in mserver5 on Python2 UDF with TIMESTAMP
       column input that has NULL values (conversion.c:438,
     * 6510: Sqlitelogictest: Wrong output in aggregation query
     * 6512: Monetdb crashes on query with limit after sort with case
     * 6514: Sqlitelogictest: Range query between NULL values not possible
     * 6515: Insert null second interval value results in 0
     * 6516: Sqlitelogictest unknown bat append operation
     * 6517: Sqlitelogictest overflow in conversion during MAL plan
     * 6518: Sqlitelogictest: count aggregation with not in operator
     * 6519: Sqlitelogictest: algebra join between lng and int BATs
     * 6520: UPDATE with correlated subquery causes assertion (or
     * 6522: Sqlitelogictest: IN operator return a single column
     * 6523: Sqlitelogictest: Case statement subquery missing
     * 6524: Sqlitelogictest: Crash in aggregation query with IN operator
     * 6527: Crash using order by alias in subquery

More information about the announce-list mailing list