These release notes are replicated for historical purposes only. The release is not supported anymore.
Client Package
- Resolved a cosmetical error where tab-characters would cause misalignments in tabular result views. For the time being, tabs are now represented as a single space in tabular view.
MonetDB Common*
- Limit number of detected CPU cores to 16 on 32-bits systems to avoid running quickly out of addressable resources followed by a kill from the OS.
Bug Fixes
- 2594: NULL cannot automatically be casted to every other type
- 3085: assertion fails upon execution of a valid SQL query
- 3086: Modulo function does not work in select from table
- 3087: query causes “Not yet implemented” message
- 3089: mserver5 crashed if join condition has two column and incorrect order
- 3090: crashed if using single identifier for where condition
- 3096: Type of median error
Apr 2012-SP1
Build Environment
- Windows: we now use OpenSSL 1.0.1b.
SQL
- Databases that were upgraded from the Aug2011 release have an error in the catalog for SQL procedures. This is now fixed.
Merovingian
- Fixed a bug where connecting to a stopped multiplex-funnel would result in a ’there are no available connections’ error.
MonetDB Common
- Implemented MT_getrss for Mac OS X systems, this allows the server to know about how much memory is currently in use.
Bug Fixes
- 2454: SQL: add various statistical functions
- 2916: non admin user cannot create temporary tables
- 2949: SQL exception during execution of a correct user defined function that just returns a relation table constructed by a simple SQL select query
- 2958: Grant does’t work with schema syntax
- 2960: mclient terminates connection during insertion of a large number of records from a file
- 2972: SQL URL functionality contains errors
- 2987: Broken type inference when using sql round
- 2992: SQL module truncates DECIMALS when passing integers to MAL module
- 3000: Inconsistency between read-only and read-write modes after dropping a schema
- 3028: Segmentation fault in seqscan_eq_bte_bte_tloc_void_void
- 3046: mserver5 terminates with segmentation fault
- 3063: datacell functions no longer work after restart of database
- 3072: Database upgrade from Dec2011 to Apr2012 broken for storage()
- 3073: VERY slow foreign key check (due to missing batcalc.isnil() ?)
- 3074: Name resolution in procedures
- 3077: No errors on UDF returning table with too many columns
- 3079: Converting an Oracle schema DDL for MonetDB fails to create a column named “no”.
Apr 2012
Build Environment
- Fixed some of the package names for Debian/Ubuntu. Packages for libraries should contain the major number of the library version number. This was not always the case.
- On Debian and Ubuntu, install Python modules in dist-packages instead of site-packages. This fixed bug 2997Z.
SQL
- Fixed a crash that happened at the end of a database upgrade to the Dec2011 database scheme. The crash happened during cleanup after the database was upgraded, so it was merely inconvenient.
- Stripped off implementation-specific parts from error messages before they get presented to the user.
Java Module
- Password reading by JdbcClient no longer results in strange artifacts
- JdbcClient now returns exit code 1 in case of failures
- Implemented missing Number types support in PreparedStatement.setObject()
- Fixed bug in DatabaseMetaData.getSchemas() method that caused an SQL error when called with catalog and schema argument.
- Resolved a bug where JDBC and Control connections could terminate abruptly with ‘Connection closed’ messages
Client Package
- ODBC: Implemented the SQL_ATTR_CONNECTION_TIMEOUT attribute.
- mclient now has a -a (–autocommit) option to turn off autocommit mode.
MonetDB5 Server
- The type “chr” has been removed. chr has long been superseded by bte for 1 byte arithmetic plus it is pretty useless to hold single characters since we use Unicode and thus only a tiny subset of the supported character set would fit.
- Fixed potential crash by dealing better with non-standard types.
- A couple of memory leaks have been plugged.
Merovingian
- The logfile and pidfile monetdbd properties are now displayed with dbfarm path when relative
- Fixed a bug in the multiplex-funnel where certain clients would abort on responses for update queries.
- Fixed problem where version and mserver properties for monetdbd were not always successfully retrieved. Bug #2982Z.
- Fixed problem where shutdown of monetdbd would lead to shutting down database ‘control’ which does not exist. Bug #2983Z.
- Fixed issue causing (harmless) ’error reading from control channel’ messages. Bug #2984Z.
- Resolved problem where remote start/stop/etc. commands with monetdb would report error ‘OK’. Bug #2984Z.
MonetDB Common
- The type “chr” has been removed. chr has long been superseded by bte for 1 byte arithmetic plus it is pretty useless to hold single characters since we use Unicode and thus only a tiny subset of the supported character set would fit.
Bug Fixes
- 2994: test monetdb5/modules/kernel/Tests/vacuum.mal fails since changeset ada288cef37c
- 3023: SQL tests fail as error messages now go to stdout iso. stderr
- 3030: optimizer tests fail with new optimizer framework
- 3032: numerous M5/MAL tests fail on SunOS/Solaris as TypeExecptions do no longer show arguments in command signatures