July 2012

These release notes are replicated for historical purposes only. The release is not supported anymore.

Jul 2012

Build Environment

  • Created seperate RPM and DEB packages for MonetDB/JAQL.
  • Removed –enable-bits option from configure.
  • Split the MonetDB-client-ruby RPM package into two and named them in accordance with the Fedora packaging guidelines as rubygem-.

SQL

  • COPY INTO now accepts optional parenthesis for file argument. Binary COPY INTO now requires ‘COPY BINARY INTO’.

Client Package

  • ODBC: Fixed a bug where SQLNativeSql expected a statment handle instead of a connection handle.

MonetDB5 Server

  • Crackers code has been removed. Development continues in the holindex branch.

Merovingian

  • Fixed misc memory leaks, which caused monetdbd to grow in memory size over time.
  • Removed erroneously (re-)added master and slave properties, this functionality is currently not working.

MonetDB Common

  • Fixed intermittent problem that joins and selects return incorrect results and possibly inconsistent databases. The problems only occurred after a series of queries and updates, therefore it was hard to reproduce.
  • The sorted property, which was used to maintain whether a column in a BAT was sorted or reverse sorted, has been replaced by a pair of properties, sorted and revsorted. These new properties can be set independently (unlike the old sorted property), and so if both are set, the column must be constant. In addition, internal property checking has been overhauled. Now, when a property is set incorrectly, and when assertions are enabled, an assertion will go off. There is also a function which can derive properties.
  • Implemented proper overflow checking on all arithmetic operations.

Bug Fixes

  • 3016: Overflowing double multiplication leads to incorrect result
  • 3091: Since Apr2012-SP1 !TypeException:user.s11_1[59]:‘bat.reverse’ undefined in: _89:any := bat.reverse(_86:wrd)
  • 3099: ambiguous attributes in query with WITH clause and EXISTS clause
  • 3100: charset problem with the odbc driver for windows
  • 3103: display_size and internal_size of Cursor.description or incorrect
  • 3105: Leaking using Python
  • 3109: Wrong order in autoload mal script causes warning on startup
  • 3111: memory leak, monetdb set/get command
  • 3112: Median over temporal domains
  • 3113: Cannot set value of indexed column when doing UPDATE
  • 3114: Foreign Key prblems
  • 3116: Segfault in SQL

Jul 2012-SP1

Java Module

Client Package

  • mclient no longer prints the SQLSTATE at the start of each error returned by the SQL-server.

MonetDB5 Server

  • The server now distinguishes between starting and started states, such that monetdbd can wait for it to finish starting.

Merovingian

  • 3134. In case of a long wait, the monetdbd logfile gives extra information on what the server is doing to recover.
  • 3135
  • 3107

Bug Fixes

  • 3075: inconsistent declaration of algebra.markH with 3 input arguments
  • 3090: crashed if using single identifier for where condition
  • 3093: sql fail if use scalar subquery with alias
  • 3107: concurrent connections to the same stopped database yield in multiple mserver5 starts by monetdbd
  • 3119: MonetConnection$ResultSetResponse throws java.lang.ArithmeticException: divide by zero
  • 3132: test/BugTracker-2011/func_iter_vs_bulk.Bug-2826 fails
  • 3134: Database gets killed by timeout during startup
  • 3135: monetdbd crash while creating & loading database

Jul 2012-SP2

Java Module

  • Fixed a bug where DatabaseMetaData.getURL() did return null:0 for hostname:port.

MonetDB5 Server

  • Changed the way nclients maximum was calculated to avoid ‘out of client slots’ errors way before the maximum was reached.

Merovingian

MonetDB Common

Bug Fixes

  • 3117: test sql/test/BugTracker-2011/Tests/history.Bug-2909.sql produces extra profiling output since changeset 817328b74e2f
  • 3134: Database gets killed by timeout during startup
  • 3139: Not equal evaluation does not work
  • 3144: Memleak when connecting to a database (mclient and mapi)
  • 3145: mclient error when enabling history
  • 3150: Multiple string equality tests fail to match (Test_JdbcClient)