Announcement: New Oct2014-SP2 Bugfix release of MonetDB suite

Sjoerd Mullender sjoerd at
Thu Jan 29 14:44:37 CET 2015

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

   Oct 2014-SP2 bugfix release
   Client Package
     * Changes to the Perl interface, thanks to Stefan O'Rear: 1. removes
       "use sigtrap", because this has global effects and should not be
       used by modules, only by the application. 2. allows Perl 5.8.1+
       Unicode strings to be passed to quote() and included in statements
       (UTF-8 encoded, as expected by Monet's str module) 3. quote and
       unquote now use the same quoting rules as the MonetDB server,
       allowing for all characters except NUL to be round-tripped 4.
       several character loops have been reimplemented in regex for much
       greater performance 5. micro-optimizations to the result fetch loop
       6. block boundaries are preserved in piggyback data so that Xclose
       is not appended or prepended to a SQL command 7. diagnostic
       messages #foo before a result header are ignored, this is necessary
       to use recycler_pipe 8. fail quickly and loudly if we receive a
       continuation prompt (or any other response that starts with a
       non-ASCII character) 9. header lines must start with %, not merely
       contain %, fixing a bug when querying a table where string values
       contain % 10. after closing a large resultset, account for the fact
       that a reply will come and do not lose sync 11. allow a MAPI_TRACE
       environment variable to dump wire protocol frames to standard
       output 12. fixes maximum MAPI block size to match the server limit
       of 16k. previously would crash on blocks larger than 16k

     * Fixed a typo in a column name of the sys.tablestoragemodel view
       (auxillary changed to auxiliary).

   Bug Fixes
     * 3467: Field aliases with '#' character excise field names in result
     * 3605: relational query without result
     * 3619: Missing dll on MonetDB Start
     * 3622: Type resolution error
     * 3624: insert of incomplete or invalid ip address values in inet
       column is silently accepted but the values are not stored (they
       become/show nil)
     * 3626: casting a type without alias results in program contains
     * 3628: mclient and ODBC driver report 'type mismatch' when
       stddev_pop used in a select which returns 0 rows
     * 3629: IF THEN ELSEIF always evaluates the first test as true
     * 3630: segv on rel_order_by_column_exp
     * 3632: running make clean twice gives an error in
     * 3633: Wrong result for HAVING with floating-point constant
     * 3640: Missing implementation of scalar function: sql_sub(<date>,
       <month interval>)
     * 3641: SQL lexer fails to detect string end if it the last character
     * 3642: Combined WHERE conditions less-than plus equals-to produce
       incorrect results
     * 3643: Missing implementations of scalar function: sql_sub(<timetz>,
     * 3644: COPY INTO fails to import "inet" data type when value has
       prefix length in CIDR notation
     * 3646: ORDER BY clause does not produce proper results on 'inet'
     * 3649: recycler crashes with concurrent transactions

More information about the developers-list mailing list