June 2007

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

Release “2007-11-22” (released on Nov 22 2007) consists of the following updatedparts MonetDB Clients 1.20.2, MonetDB5 Server 5.2.2, MonetDB5/SQL 2.20.2. This release is a bug fix release, covering the following items:

  1. Clients: The APIs for python, perl and php have been synchronized by the latest state of the Mapi protocol and implementation. JDBC contains a non-blocking IO fix for slow network connections.
  2. A performance fix of the group module. Improved grouping functionality significantly through a better estimate of the intermediate sizes.
  3. The MonetDB/SQL embedded version has been made to work again.
  4. Memory leakage in both the Server and SQL module have been addressed.

Bug fixes List of fixed bugs

  • 1834941 cursor.executemany (python) fails * 1834442 Compiling clients (Stable) failed on GNU.32.32.d-Gentoo1.12.
  • 1833800 Python errors not getting passed through MAPI * 1831630 Clients: Debian gcj/ant doesn’t work.
  • 1828314 make failed on MonetDB5
  • 1827627 –enable-bits doesn’t work with icc
  • 1826708 Merovingian: cannot start out of the box, as dbfarm doesn’t
  • 1823387 Cascade operations in different sessions…
  • 1823378 Incorrect return type of “with - seeded by - recurse”
  • 1819168 sql/src/test/mapi/python_dbapi test fails
  • 1814768 Python Client problems

Release “2007-10-17”

(released on Oct 22 2007) consists of MonetDB Common 1.20, MonetDB Clients 1.20, MonetDB4 Server 4.20, MonetDB4/XQuery 0.20, MonetDB5 Server 5.2, MonetDB5/SQL 2.20. This release marks a long summer of mostly core software development and maintenance. The restructuring of the source tree was partly successful. Semantic dependencies amongst packages, however, forced us to release more components together than originally planned. Close interaction with some large users provided valuable input for bug fixes and performance improvements.

SQL We added a way to bulk request sequence numbers. When loading (copying) data into tables which have an auto_increment (or alike) column lots of time was spend in the many calls to get all the sequence numbers (observed a performance increase of about 10x when loading pieces of 100K rows) TINYINT was added to the standard repertoire. We changed how selections over multiple columns of a single table are handled. Furthermore, several bugs stemming from large-scale deployment have been resolved.

XQuery In the XQuery area many issues have been dealt related to the transaction safe update functionality. Furthermore, a value based indexing scheme has been added to speedup the search.

Clients The mclient utility has undergone a major overhaul. It moved from a Spartan rendering of SQL results towards a more user friendly tabular rendering on ascii terminals. In passing, the option structure and command options has been stratified and extended with a few use full functions, e.g. piping the tabular result as a CSV to an external program. Use the –help for an overview.

MonetDB 5 Merovingian has been added as the gatekeeper of all SQL database services in a particular farm. It redirect clients to the proper connection. The accompanying Monetdb toolkit provides a textual frontend for assessing the status of a collection of MonetDB servers.

Bug fixes A summary with the highlights is given below. The detailed list of changes can be found in the source code CVS change logs.


  • 1806869 SQL: prepare output has unqualified table_name header
  • 1790101 SQL: parser warnings
  • 1786908 SQL+PF: loading both “sql_server” and “pathfinder” fails
  • 1775550 SQL: implied conversion from numeric to varchar disconnect
  • 1774312 SQL: conversion from decimal to varchar error
  • 1774217 SQL: order by timestamps column with limit crash
  • 1757923 SQL: Prepared statement type mismatch
  • 1737777 select id not in another select…
  • 1737668 Alter table to add Fkey….
  • 1734143 Update fkey with a values not in the pkey…
  • 1733712 Update pKey with the same value for different rows…


  • 1786397 XQ: SAX serialization not working properly
  • 1771532 MIL-optimizer fails sometimes for big queries
  • 1766414 XQ: third pf-add into collection fails
  • 1763575 XQ: insert attribute gives ERROR in merged_union
  • 1763495 XQ: illegal offsets in swizzle (2)
  • 1760811 XQ: illegal offsets in swizzle
  • 1758902 XQUF replace function seems to corrupt the database
  • 1757327 XQ: attributes in 2nd doc don’t show
  • 1755466 XQ: printing special characters in comment nodes
  • 1751684 XQ: merged_union error with fn:sum()
  • 1747017 XQ: admin console images not installed
  • 1743442 XQ: illegal XML syntax in serialized attributes
  • 1743433 XQ: problem with ampersand in attribute value
  • 1766173 Double for / position / sub-sequence bug
  • 1760445 PF: test attribute_access_mposjoin_error.SF-1726928 fails
  • 1760168 PF: wrong use of leftfetchjoin causes segfault in bat_cast
  • 1741459 PF: ws_create inconsistently adds a collection node
  • 1740502 PF: live-variable-limit-handling in mil_opt.c buggy
  • 1737735 128MB RAM needed to compile ‘1’?


  • 1774575 Single page manual damaged
  • 1754452 NullPoin

MonetDB 4.18, MonetDB/XQuery 0.18, MonetDB 5.0, MonetDB 5.0/SQL 2.18. The Mars release marks the official release of the MonetDB server 5 line as the basis for future investments in application development. This affects first and foremost the maintenance of SQL code base, where the MIL version is not being maintained actively anymore by the MonetDB team. A synopsis of the major improvements

  1. implementation of delete/update with cascading
  2. PSM procedure call implementation
  3. support for polymorphic functions
  4. autoloading of sql scripts upon server restart

WarningThe SQL catalog structure has been changed, which requires a database dump before you install the new version.WarningThe old Window installers do not always remove MonetDB DLLs. You may have to manually remove them from system32 before (re-)installing the new version. It concerns:

  • libstream.dll
  • libmutils.dll
  • libMonetODBCs.dll
  • libMonetODBC.dll
  • libMapi.dll

MonetDB XQuery XQuery Update Facility has undergone a large series of stress tests to improve correctness, performance and robustness under concurrent updates. In many areas the functionality has been improved:

  1. a completely revised and enhanced type checking code
  2. the administrative console for XQuery
  3. automatic use of value indexing
  4. improved and extended XRpc functionality (javascript library)
  5. all XPath axes looplifted (siblings will come soon)
  6. Intel-based native Windows build (i.e., 64-bit)

This release containsPF/Tijah,, a text search extension for XQuery. It provides a flexible environment for setting up search systems by supporting out-of-the-box solutions for common tasks, like index creation and result ranking of XML elements. Work continuous on the algebra version compiler and its SQL backend code generator.Release model The months passed since the bug-fix release of February 2007 showed that the MonetDB product family has grown to a size that more frequent releases are only possible if we continue our decomposition process. The SQL and XQuery release dependencies have now been cut. Source distribution The Super Source Tarball has become a stable means to access and install the packages on Linux platforms. Bug fixes A detailed list of changes can be found in the source code CVS change logs. A summary with the highlights is given below.MonetDB/SQLBug fixes SQL/Core:

  1. 1734143 Update fkey with a values not in the pkey…
  2. 1733712 Update pKey with the same value for different rows…
  3. 1730987 cast of expression hangs
  4. 1725349 large COPY INTO with primary key
  5. 1724151 SQL: mixing auto-commit with explicit transactions
  6. 1723863 SQL Query Crashes Server - CRITICAL
  7. 1723791 rand() is not executed for every row
  8. 1720934 Bind Variable with CAST function Crashes Server
  9. 1720293 WITH queries works only once!
  10. 1718253 SQL: decimal handling errors
  12. 1715672 LOCAL AND GLOBAL temporary table
  13. 1715669 Temporary tables….
  14. 1715659 LIKE for time values…
  15. 1715553 Set default value…..
  16. 1714829 SQL: CHECK CONSTRAINT…
  17. 1714814 SQL: View creation using a function….
  18. 1714809 Infinite loop….
  19. 1711947 src/test/Update_Delete_action: missing stable output files
  20. 1711251 M5: mserver5 segfaults after the second query
  21. 1711242 M5/SQL: wrong result for range predicate
  22. 1710678 CREATE PROCEDURE…
  23. 1710677 DROP PROCEDURE…..
  24. 1709182 SQL: M4 and M5 crash on Solaris/x86 when SQL module is loaded
  25. 1703497 The mserve crash due the null control…
  26. 1701823 copy into from ‘filename’ not closed
  27. 1695290 SQL changing column default gives error
  28. 1691646 REVOKE authorization crash
  29. 1691344 SQL UNION with ORDER BY crash
  30. 1691098 Mserver/SQL crashes on empty window_specification
  31. 1688915 SQL: crash on nested query
  32. 1684798 LIKE clause
  33. 1670739 SQL: Corrupt database after restart
  34. 1659889 SQL: sequence not restored properly

Bug fixes XQuery:

  1. 1731850 Error in preceding axis
  2. 1730556 XQ/JDBC: 250 results
  3. 1730547 XQ: Mserver crashes on concatenated query
  4. 1726954 XQuery: inserting (large) doc into other doc
  5. 1726928 XQuery: Attribute access causes mposjoin error
  6. 1726599 XQuery: collection management broken
  7. 1726548 XQuery: Administrative Console
  8. 1725352 PFtijah: failing alloc() causes assertion failure (segfault)
  9. 1724118 PF: coreopt optimization eats all available memory and swap
  10. 1723931 XQuery compiler warning treated as error
  11. 1723217 PF: compiler/sql/lalg2sql.brg fails to compile w/o assertion
  12. 1722078 PF: WebSite tests books[123] fail since 2007.05.03
  13. 1721701 PF: “!ERROR: Division by zero” after latest checkins
  14. 1719164 PF: new loop-lifted following step still buggy?
  15. 1718709 PF: select deleted node results in error
  16. 1718622 PF: strange behaviour of “rename”
  17. 1718066 PF: put() to /tmp crashes Mserver
  18. 1716158 PF: compiler/algebra/opt/opt_thetajoin.c icc-compil. fails
  19. 1712578 Mix-up in nested element construction
  20. 1706520 XQuery: boolean every
  21. 1705898 “forgot to cope with type ‘double’ in cast to integer”
  22. 1682059 XQ: internal integer representation
  23. 1698498 id-function fails to locate some kinds of nodes
  24. 1684416 Pathfinder does not compile due to undefined LLFMT
  25. 1718709 PF: select deleted node results in error
  26. 1718635 PF: node’s sibling not accessable after deletion of the node
  27. 1718622 PF: strange behaviour of “rename”
  28. 1718066 PF: put() to /tmp crashes Mserver
  29. 1714603 PF: XRpc tests fail on MacOS (Darwin) since
  30. 1714399 XQuery/XRPC: refresh admin-page causes segmentation fault
  31. 1714360 PF/runtime: find_qn_bulk() adds new qnames twice
  32. 1712595 Error mposjoin: missing matches
  33. 1711754 shredder msync() bug
  34. 1706438 PF: property error when adding a doc. to an existing coll.
  35. 1683730 XQuery: mserver (0.16.2) sometimes crashes on complex query
  36. 1681921 XQ: Character escaping is bogus
  37. 1678593 XQ: document added/deleted with error occured
  38. 1676443 XQ: Interleave of put and doc via mod. func. crashes
  39. 1719164 PF: new loop-lifted following step still buggy?
  40. 1712463 PF: various tests fail since 2007.05.04
  41. 1712461 PF: several tests fail since 2007.05.03
  42. 1712459 PF: several tests fail since 2007.04.28
  43. 1712458 PF: prop. err. in update tests since 2007.04.26 (64-bit OIDs
  44. 1712456 PF: various tests fail since 2007.04.04
  45. 1712455 PF: test fails since 2007.04.03
  46. 1712454 PF: tests/W3C_use_cases/XQ/XMP/Q04alg fails since 2007.04.03
  47. 1712449 PF: “bogus_text_step” test fails since 2007.03.08
  48. 1714133 PFtijah: “/tmp/TIJAH_LOGGER” never cleaned => fills /tmp/ !
  49. 1714129 PFtijah: hard-wired “/tmp/TIJAH_LOGGER” not portable

Bug fixes APIs:

  1. 1733744 Cannot connect via ODBC (from Powerbuilder 10)
  2. 1675795 Float to decimal conversion still broken in v5.0.0_beta1_2
  3. 1671737 JDBC: exception in getChallengeResponse
  4. 1670732 XQ/JDBC: escaping backslash
  5. 1693694 ODBC driver not honoring host, username, or password
  6. 1473288 SQLTables fails if previous statement failed
  7. 1702698 Mapi < problem

Bug fixes Kernel:

  • 1713584 delete on committed dense persistent BAT causes prop. error
  • 1709519 M5: Linux process killed
  • 1706713 Database corruption after out-of-memory condition
  • 1705726 crash in leftfetchjoin due to lack of range checking
  • 1704972 GDK change causes FATAL BATpropcheck with XQuery
  • 1686756 Implicit declaration of function .fdatasync.
  • 1679800 Mserver segfaults during recursive module loading
  • 1673410 STREAM_DEBUG causes compilation error in stream.mx

terException in MonetConnection * 1739356 TRACE,PROFILE,DEBUG should be impossible for JDBC and ODBC * 1739353 EXPLAIN support from JDBC * 1733744 Cannot connect via ODBC (from Powerbuilder 10)