July 2012

July 2012 fabian Tue, 10/23/2012 - 11:34

Jul 2012 feature release

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-<gem-name>.
  • 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.
  • 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 bugfix release

Java Module
  • Fixed adaptive cache size used when retrieving results, not to cause divide by zero errors when memory gets short, bug #3119.
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.
  • Starting a server now waits for as long as the server needs to possibly recover, bug #3134. In case of a long wait, the monetdbd logfile gives extra information on what the server is doing to recover.
  • Fixed a crash of monetdbd when local databases were unshared, bug #3135
  • Resolved a problem where automatic starting of a database initiated by multiple clients at the same time could cause failed starts. Bug #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 bugfix release

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.
  • Resolved a problem where monetdb could fail to start a database with the message "database 'X' started up, but failed to open up a communication channel". Bug #3134, comment #7.
MonetDB Common
  • Fixed a bug in BATantijoin when either side is a singleton BAT. This fixes bug 3139.
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)