Announcement: New Oct2012-SP2 Bugfix release of MonetDB suite

Sjoerd Mullender sjoerd at
Fri Dec 21 13:31:35 CET 2012

The MonetDB team at CWI/MonetDB BV is pleased to announce the
Oct2012-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 2012-SP2 bugfix release
   SQL           * Fixed crash when performing an INSERT on a table with
                   string-like column defaulting to NULL and omitting that
                   column from VALUES, bug #3168
   Java Module   * Implemented type map support of Connection to allow custom
                   mapping of UDTs to Java classes. By default the INET and
                   URL UDTs are now mapped to
                   nl.cwi.monetdb.jdbc.types.{INET,URL}. Most notably,
                   ResultSet.getObject() and PreparedStatement.setObject()
                   deal with the type map.
                 * Fixed a problem in PreparedStatement where the prepared
                   statement's ResultSetMetaData (on its columns to be
                   produced) incorrectly threw exceptions about non existing
                   columns. Bug #3192
   Bug Fixes     * 2291: small doubles end up as NULL after arithmetic
                 * 2579: SQL: incorrect cast from double to int
                 * 2659: tuples INTERSECT vs count (... INTERSECT ...)
                 * 2805: row_number doesn't work in complex query
                 * 2886: warning: Catalog parameter '' ignored
                 * 2977: timestamp minus date results in program error
                 * 2978: now() + 1 results in illegal argument
                 * 2999: Up-cast from SQL drops order information?
                 * 3048: algebra.join undefined when using multiple
                   arithmetic operations in SQL where-clause
                 * 3124: insert into table with two foreign keys crashes
                 * 3136: Memleak (in querycache?) while querying
                 * 3143: Type resolution error in SQL procedural code
                 * 3163: mserver5 crashes with large number of concurrent
                 * 3168: crash when insert varchar/char/clob with default
                 * 3169: php driver uses call-time pass-by-reference
                 * 3173: SQL queries with limit and offset clauses are unable
                   to use bind parameters for either
                 * 3181: Join query returns zero results when there is an
                   index on the tables
                 * 3185: inconsistency between documentation and
                   implementation of command line options
                 * 3186: case evaluted to early
                 * 3188: Storage of client history
                 * 3189: Overflow in calculation
                 * 3190: When subtracting two columns of type "timestamp", no
                   results are returned
                 * 3191: rel_optimizer.c:5596: _rel_optimizer: Assertion `0'
                 * 3192: "No such column with index" error if CASE in SELECT
                 * 3199: Inconspicuous sequence of prepare, execute, commit
                   and close produces error
                 * 3205: Inet datatype handling inconsistent between int,
                   cast( as inet) and string
developers-list mailing list
developers-list at

More information about the developers-list mailing list