Skip to main content

June 2007

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
  11. 1715679 CREATE TABLE WITH DATA...
  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