Derby 10.6.1 has been released
By kah on May 19, 2010
Apache Derby 10.6.1.0 has just been released. This is a new feature release, and the first release in the 10.6 series. See the full announcement here. The downloads and the release notes can be found at this URL: http://db.apache.org/derby/releases/release-10.6.1.0.cgi
Make sure that you read the release notes carefully before you upgrade. Pay special attention to the note about the security issue CVE-2009-4269, which details how to protect your database from a vulnerability in Derby's BUILTIN authentication and password substitution in previous releases. (The vulnerable code is still there to make it possible to access old databases, but the defaults have changed so that new databases will not have the vulnerability.)
The new features in this release include:
- Sequence Generators - Named generators for allocating successive, evenly spaced numbers. See feature T176 of the SQL Standard.
- User-defined types - Named types bound to serializable Java objects.
- Restricted table functions - Limits on the columns and rows returned by table functions.
- XPLAIN statistics collection - Query plan statistics stored in tables for later analysis.
- GROUP BY ROLLUP - A subset of the SQL Standard ROLLUP functionality on the GROUP BY clause. See feature T431 of the SQL Standard.
- CROSS JOIN - CROSS JOIN syntax. See feature F401-04 of the SQL Standard.
- Named columns join - USING clauses in joins.
- SHOW FUNCTIONS - IJ command that lists stored functions.
- In-memory back end enhancements - Numerous improvements, including the ability to delete in-memory databases.
- ORDER BY in subqueries - Syntax for explicitly ordering rows returned by subqueries. See features F851, F852, and F855 of the SQL Standard.
- OFFSET, FETCH FIRST/NEXT in subqueries - Generalized syntax for retrieving row subsets. See features F856, F857, F858, F859, F861, F862, F863, and F864 of the SQL Standard.
- NATURAL JOIN - Support for NATURAL JOIN. See feature T431 of the SQL Standard.
- Qualified identifers in ij - Ability to reference cursors and prepared statements in other connections.
- Configurable hash algorithm - Ability to customize the hash algorithm used by BUILTIN authentication.
- Context-sniffing scripts - Ability of shipped scripts to locate Derby jars when DERBY_HOME isn't set.
- Case-insensitive strings - Ability to ignore case in string comparisons and sorts.