Table of Contents
Contents
10.6.1 Release Summary
Derby 10.6.1 is a feature release.
Release Manager |
Rick Hillegas |
Draft Release Notes Circulated |
April 19, 2010 |
Release candidate to be posted |
April 26, 2010 |
Sanity Testing and Voting |
April 26 - May 17, 2010 |
Target Release Date |
May 19, 2010 |
10.6.1 Features
The following features are planned for 10.6.1. Note that this is not a contract. The contents of 10.6.1 will shift as development proceeds. See the latest 10.6 release notes.
Legend:
- Done. ![/!\](/wiki/modernized/img/alert.png "/!\")
- Needs buddy testing. 
- Needs documentation and buddy testing.
Status |
Feature |
JIRAs |
Comments |
Documentation |
Buddy Tester |
|
Sequence Generators (T176) |
ANSI/ISO Sequence Generators |
Done. DERBY-4568 |
Lily Wei |
|
|
User-defined types |
ANSI/ISO types bound to serializable objects |
Done. DERBY-4572 |
Kathey |
|
|
Restricted Table Functions |
Push projections and simple restrictions into table functions. |
Done. See DERBY-4507 |
Read the new docs, which seemed clear enough to me. -Dag. Knut A. - logged minor issues DERBY-4650, DERBY-4651, DERBY-4654 |
|
|
XPLAIN statistics collection |
Capture statistics about the execution of a query into database tables for further analysis |
Done. See DERBY-4065 |
Mamta |
|
|
GROUP BY ROLLUP (T431, limited) |
Implement a subset of the SQL Standard ROLLUP functionality on the GROUP BY clause |
Done. See DERBY-4394 |
Knut A. - No new problems found. |
|
|
CROSS JOIN (F401-04) |
Implement SQL Standard CROSS JOIN syntax. |
Done. See DERBY-4374 |
Dag. Reads the docs and tested the stated equivalences between the shown queries from from tours db. |
|
|
Named columns join |
Allow USING clauses in joins. |
Done. DERBY-4401 |
Jayaram. No problems found except for one scenario which was recorded under Derby 4631. |
|
|
SHOW FUNCTIONS |
Add a command that lists stored functions in ij. |
Done. See DERBY-4445 |
Mamta |
|
|
In-memory back end enhancements |
Add a proper delete mechanism. |
Done. DERBY-4525 |
Rick: Looks good. Logged a minor documentation issue related to this feature: DERBY-4637 |
|
|
ORDER BY in subqueries (F851, F852, F855) |
Add syntax for explicit ordering of rows returned by subqueries. |
Done. See DERBY-4518 |
Mikem, testing done, no new problems found. verified cases on a windows machine and read over new documentation. |
|
|
OFFSET, FETCH FIRST/NEXT in subqueries (F856,F857,F858,F859,F861,F862,F863,F864) |
Generalize allowed syntax for retrieving row subsets. |
Done. See DERBY-4518 |
Tiago. Testing Report |
|
|
NATURAL JOIN (F401-01) |
Add support for NATURAL JOIN. |
Done. DERBY-4506 |
Dag. This feature looks good, including documentation. I have not managed to shoot holes in it so far.. |
|
|
Qualified identifers in ij |
Add ability to reference cursors and prepared statements in other connections. |
Done. DERBY-4567 |
Eranda |
|
|
Configurable hash algorithm |
Add ability to customize the hash algorithm used by BUILTIN authentication. |
Done. DERBY-4579 |
Rick: Verified the following: 1) Specifying a missing algorithm generates errors when you try to set a password. 2) Old credentials work even after changing the default hash algorithm. 3) The new hash algorithm property is ignored after soft-upgrade to 10.6. 4) Password substitution is rejected if engine is at level 10.6. |
|
|
Allow scripts to run without DERBY_HOME |
The scripts in the bin directory can now locate the jar files even if the DERBY_HOME environment variable has not been set. |
- |
Myrna: Verified this works for scripts that used to call derby_common. The *CP scripts still need DERBY_HOME set. |
|
|
Global case insensitive setting |
Territory based collation can now be configured to be case insensitive |
Done. DERBY-4591 |
Rick: Seems to work as advertised. However, I thought that it was a little difficult for users to figure out how to get Derby to perform case-insensitive searches and sorts. To track this, I logged DERBY-4629. |
10.6.1 Bug Fixes
We will put some effort into fixing bugs on the following lists:
10.6.1 Testing
Testing details can be found on the following pages:
List other testing here:
RC1
Tester |
Date |
Additional Tests |
Comments |
Rick |
4/28/2010 |
Verified links in index.html |
Top-level links work. |
Dag |
4/30/2010 |
Verified .asc signatures and md5 sums for all artifacts |
|
Kristian W. |
2010-05-04 |
Verified that the two source bundles have the same contents (.tar.gz and .zip) |
|
Kristian W. |
2010-05-04 |
Built Derby from the source bundle (.zip) on OpenSolaris dev_137 using Sun Java SE 6 (1.6.0_18) and on Linux Mint 8 using OpenJDK 6 (IcedTea 1.6.1) |
|
Rick |
5/4/2010 |
Build a release from the source distribution |
Did so on Mac OS X 10.5.8 |
Myrna |
5/10/2010 |
verified workings of /bin scripts |
sh scripts on cygwin on windows XP (SP3) and SUSE Linux (10); bat scripts on DOS (windows XP SP3). |
Myrna |
5/10/2010 |
basic test of eclipse plugins |
eclipse 3.4.2 (ganymede) on windows XP with ibm 1.6. New install (both eclipse & plugins) & project without classes only. |
Deferred Work (Not Included in 10.6)
Status |
Feature |
JIRAs |
Comments |
Documentation |
Buddy Tester |
|
DBLOOK Improvements |
Sort DDL by dependencies; add GRANT/REVOKE statements |
- |
- |