MonetDB Feb2013 Release

 

Feb 2013 feature release
Testing Environment
  • enabled "top-level" Mtest.py So far, while Mtest.py could be called in any subdirectory of the MonetDB source tree (and could then run all tests in the entire sub-tree), it was not possible to call Mtest.py in the top-level MonetDB source directory to run all tests. Instead, to run all tests, Mtest.py had to be called at least 4 times, once in each of these directories: "clients", "monetdb5", "sql", "geom". Now, it is possible to call Mtest.py once in the top-level MonetDB source directory to run all tests in one go. The behaviour of calling Mtest.py in any subdirectory, including the four mentioned above, did not changed, other than that now obsolete command line options "-p / --package <package>" and "-5 / --monetdb5" have been removed.
Java Module
  • merocontrol was changed to return server URIs, and lastStop time. Connections and dbpath were removed.
  • Mapi protocol v8 support was removed from MapiSocket. Protocol v8 has not been used by the servers any more since Apr2012 release
Client Package
  • Mapi protocol v8 support was removed from all client drivers. Protocol v8 has not been used by the servers any more since Apr2012 release
  • The tool mnc was removed from installations
  • msqldump: Implmented an option (--table/-t) to dump a single table.
  • Changed msqdump's trace option to be in line with mclient. In both cases, the long option is --Xdebug and the short option is -X.
MonetDB5 Server
  • mserver5: The --dbname and --dbfarm options have been replaced by the single --dbpath option.
  • The scheduler of mserver5 was changed to use a fixed set of workers to perform the work for all connected clients. Previously, each client connection had its own set of workers, easily causing resource problems upon multiple connections to the server.
Merovingian
  • Upgrade support for dbfarms from Mar2011 and Aug2011 was dropped
  • monetdb status now uses a more condensed output, to cater for the uris being shown, and prints how long a database is stopped, or how long ago it crashed
  • monetdb status now prints the connection uri for each database, when available. The connections and database path properties have been dropped.
  • monetdb status now prints last crash date only if the database has not been started since.
Bug Fixes
  • 2291: small doubles end up as NULL after arithmetic
  • 3215: Calculation Date function using interval and year
  • 3033: stethoscope needs better documentation
  • 3084: Timestamp arithmetic very slow (especially on Windows)
  • 3125: Python tests fail after recent Python API changes
  • 3172: assertion fails on table function with subselects as parameters
  • 3178: one scan is enough to implement ALGstdev_@1 in monetdb5/modules/kernel/algebra.mx
  • 3179: LIKE: batstr.like+algebra.uselect called instead of pcre.like_filter
  • 3193: Expressions not supported in the GROUP BY or ORDER BY clause.
  • 3216: "unknown property" error setting format and width in .monetdb file
  • 3217: gdk_posix fails to compile under NetBSD
  • 3221: can no execute large statements
  • 3222:  Monet DB giving wrong value from a table when a value is queried after insertion/ Data Loss
  • 3225: mserver segfault on select
  • 3227: MT_set_lock() call on an non-initialized lock

 

Feb 2013-SP1 bugfix release
Bug Fixes
  • 3228: Python client - mapi.Connection.__getbyes should throw exception when 0 bytes received from socket
  • 3229: GRANT does not work for UPDATE
  • 3230: GRANT SELECT priveleges not set in SQL FUNCTIONs
  • 3233: getting a crash of server with segmentation fault on SLES 11 64 SP2
  • 3235: MapiPP.pm unquote '0' as 'undef'
  • 3236: mclient \d produces no output
  • 3237: Assertion on BATgroup_internal
  • 3241: SEGFAULT on string processing when using optimizer.reduce()

In addition to these changes, we also fixed the database upgrade.  Due to internal changes in the Feb2013 release, some changes had to be made to the SQL catalog.  These changes were done incompletely in the Feb2013 release.  This has now been fixed in the Feb2013-SP1 release.  Both a direct upgrade from Oct2012 and from Feb2013 should work.

Feb 2013-SP2 bugfix release
MonetDB5 Server

  • Fixed argument parsing of mapi.reconnect() with 5 arguments.
MonetDB Common

  • Fixed a bug in case the candidate list is dense and completely outside the range of the bat being worked upon.
Java Module

  • The pre-compiled .jar files are now created using Java 7 instead of Java 6.
SQL

  • Added TEMPORARY to the non-reserved keywords, ie no need for double quotes when used as identifier.
Bug Fixes
  • 3245: SELECT from a view of a view
  • 3250: SELECT fails with subquery result missing when adding condition
  • 3251: Name of coercions optimizer wrong in opt_wrapper.c
  • 3257: stddev_pop and stddev_samp break during a GROUP BY
  • 3259: BETWEEN clause not producing rangejoin
  • 3261: Incorrect empty string values in query results
  • 3264: select + group by expression alias from a view kills database by signal SIGSEGV
  • 3276: Problem with starting monetdb on debian sqeeze