Table of 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:

Status

Feature

JIRAs

Comments

Documentation

Buddy Tester

/!\

Sequence Generators (T176)

DERBY-712

ANSI/ISO Sequence Generators

Done. DERBY-4568

Lily Wei

/!\

User-defined types

DERBY-651

ANSI/ISO types bound to serializable objects

Done. DERBY-4572

Kathey

(./)

Restricted Table Functions

DERBY-4357

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

DERBY-2487

Capture statistics about the execution of a query into database tables for further analysis

Done. See DERBY-4065

Mamta

(./)

GROUP BY ROLLUP (T431, limited)

DERBY-3002

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)

DERBY-4355

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

DERBY-4370

Allow USING clauses in joins.

Done. DERBY-4401

Jayaram. No problems found except for one scenario which was recorded under Derby 4631.

/!\

SHOW FUNCTIONS

DERBY-3809

Add a command that lists stored functions in ij.

Done. See DERBY-4445

Mamta

(./)

In-memory back end enhancements

DERBY-4428

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)

DERBY-4397

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)

DERBY-4398

Generalize allowed syntax for retrieving row subsets.

Done. See DERBY-4518

Tiago. Testing Report

(./)

NATURAL JOIN (F401-01)

DERBY-4495

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

DERBY-4550

Add ability to reference cursors and prepared statements in other connections.

Done. DERBY-4567

Eranda

(./)

Configurable hash algorithm

DERBY-4483

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

DERBY-3207

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

DERBY-1748

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

X-(

DBLOOK Improvements

DERBY-4272

Sort DDL by dependencies; add GRANT/REVOKE statements

-

-

DerbyTenSixOneRelease (last edited 2010-12-14 20:23:23 by RichardHillegas)