Differences between revisions 47 and 48
⇤ ← Revision 47 as of 2009-04-29 22:07:02 →
Size: 10217
Editor: MyrnavanLunteren
Comment:
← Revision 48 as of 2009-09-20 22:11:10 → ⇥
Size: 10317
Editor: localhost
Comment: converted to 1.6 markup
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:
[[TableOfContents(3)]] <<TableOfContents(3)>>
Line 13: Line 13:
||[http://people.apache.org/~myrnavl/derby-10.5.1.0-RC1/ Release Candidate 1 (10.5.1.0 - rev. 757599) ] || 2009-03-23 ||
||Sanity Testing and Voting (Blockers: [https://issues.apache.org/jira/browse/DERBY-4122 DERBY-4122], [https://issues.apache.org/jira/browse/DERBY-4125 DERBY-4125], [https://issues.apache.org/jira/browse/DERBY-4127 DERBY-4127]) || 2009-03-23 - 2009-04-13 ||
||[http://people.apache.org/~myrnavl/derby-10.5.1.1-RC2/ Release Candidate 2 (10.5.1.1 - rev. 764942) ] || 2009-04-14 ||		 ||[[http://people.apache.org/~myrnavl/derby-10.5.1.0-RC1/|Release Candidate 1 (10.5.1.0 - rev. 757599) ]] || 2009-03-23 ||
||Sanity Testing and Voting (Blockers: [[https://issues.apache.org/jira/browse/DERBY-4122|DERBY-4122]], [[https://issues.apache.org/jira/browse/DERBY-4125|DERBY-4125]], [[https://issues.apache.org/jira/browse/DERBY-4127|DERBY-4127]]) || 2009-03-23 - 2009-04-13 ||
||[[http://people.apache.org/~myrnavl/derby-10.5.1.1-RC2/|Release Candidate 2 (10.5.1.1 - rev. 764942) ]] || 2009-04-14 ||
Line 18: Line 18:
||[http://www.nabble.com/-RESULT--VOTE--10.5.1.1-release-td23290127.html 10.5.1.1 approved] || 2009-04-28 || ||[[http://www.nabble.com/-RESULT--VOTE--10.5.1.1-release-td23290127.html|10.5.1.1 approved]] || 2009-04-28 ||
Line 20: Line 20:
 * [http://issues.apache.org/jira/secure/IssueNavigator.jspa?mode=hide&requestId=12312965 Addressed issues]
 * [https://issues.apache.org/jira/secure/IssueNavigator.jspa?mode=hide&requestId=12312966 Addressed issues which need detailed release notes.]		  * [[http://issues.apache.org/jira/secure/IssueNavigator.jspa?mode=hide&requestId=12312965|Addressed issues]]
 * [[https://issues.apache.org/jira/secure/IssueNavigator.jspa?mode=hide&requestId=12312966|Addressed issues which need detailed release notes.]]
Line 25: Line 25:
|| [http://svn.apache.org/viewvc?view=rev&revision=755044 755044] || 10.5 source branch created (from rev [http://svn.apache.org/viewvc?view=rev&revision=755043 755043]) ||
|| [http://svn.apache.org/viewvc?view=rev&revision=755046 755046] || 10.5 doc branch created (from rev [http://svn.apache.org/viewvc?view=rev&revision=755043 755043]) ||
|| [http://svn.apache.org/viewvc?view=rev&revision=755053 755053] || trunk bumped to 10.6 ||
|| [http://svn.apache.org/viewvc?view=rev&revision=757597 757597] || 10.5 bumped to 10.5.1.0 (no longer beta); RC1 (10.5.1.0 rev. 757599) ||
|| [http://svn.apache.org/viewvc?view=rev&revision=757633 757633] || 10.5 bumped to 10.5.1.1; RC2 (10.5.1.1 rev. 764942 ||
|| [http://svn.apache.org/viewvc?view=rev&revision=764986 764986] || 10.5 bumped to 10.5.1.2 ||		 || [[http://svn.apache.org/viewvc?view=rev&revision=755044|755044]] || 10.5 source branch created (from rev [[http://svn.apache.org/viewvc?view=rev&revision=755043|755043]]) ||
|| [[http://svn.apache.org/viewvc?view=rev&revision=755046|755046]] || 10.5 doc branch created (from rev [[http://svn.apache.org/viewvc?view=rev&revision=755043|755043]]) ||
|| [[http://svn.apache.org/viewvc?view=rev&revision=755053|755053]] || trunk bumped to 10.6 ||
|| [[http://svn.apache.org/viewvc?view=rev&revision=757597|757597]] || 10.5 bumped to 10.5.1.0 (no longer beta); RC1 (10.5.1.0 rev. 757599) ||
|| [[http://svn.apache.org/viewvc?view=rev&revision=757633|757633]] || 10.5 bumped to 10.5.1.1; RC2 (10.5.1.1 rev. 764942 ||
|| [[http://svn.apache.org/viewvc?view=rev&revision=764986|764986]] || 10.5 bumped to 10.5.1.2 ||
Line 35: Line 35:
Feature numbers are found in the SQL 2003 standard and are mapped to Derby in ["SQLvsDerbyFeatures"]. Feature numbers are found in the SQL 2003 standard and are mapped to Derby in [[SQLvsDerbyFeatures]].
Line 38: Line 38:
|| SQL Roles || Most of feature T331 and parts of T332 || [https://issues.apache.org/jira/browse/DERBY-2207 DERBY-2207] || Feature complete and documented. ||
|| Generated Columns || Feature T175 || [https://issues.apache.org/jira/browse/DERBY-481 DERBY-481] || Feature complete and documented. ||
|| LOB Improvements || Many performance and usability improvements for BLOBs and CLOBs. || [https://issues.apache.org/jira/browse/DERBY-3805 DERBY-3805], [https://issues.apache.org/jira/browse/DERBY-3810 DERBY-3810], [https://issues.apache.org/jira/browse/DERBY-3907 DERBY-3907], [https://issues.apache.org/jira/browse/DERBY-3934 DERBY-3934], [https://issues.apache.org/jira/browse/DERBY-3935 DERBY-3935], [https://issues.apache.org/jira/browse/DERBY-3936 DERBY-3936], [https://issues.apache.org/jira/browse/DERBY-3970 DERBY-3970], [https://issues.apache.org/jira/browse/DERBY-3977 DERBY-3977] || Completed (one small fix remaining). ||
|| Replication of encrypted databases || Make it possible to replicate encrypted databases. || [https://issues.apache.org/jira/browse/DERBY-3890 DERBY-3890], [https://issues.apache.org/jira/browse/DERBY-3921 DERBY-3921] || Feature complete, tests needed. ||
|| OFFSET/FETCH FIRST || limit result set cardinality (new SQL 2008 syntax) || [https://issues.apache.org/jira/browse/DERBY-4079 DERBY-4079] || Feature complete and documented. ||
|| In-memory back end || Storage engine for Derby storing all data in-memory. || [https://issues.apache.org/jira/browse/DERBY-646 DERBY-646] || First revision feature/code complete. No documentation. ||
|| Update Statistics Stored Procedure || Make it possible to refresh statistics || [https://issues.apache.org/jira/browse/DERBY-269 DERBY-269] || Feature complete and documented. ||		 || SQL Roles || Most of feature T331 and parts of T332 || [[https://issues.apache.org/jira/browse/DERBY-2207|DERBY-2207]] || Feature complete and documented. ||
|| Generated Columns || Feature T175 || [[https://issues.apache.org/jira/browse/DERBY-481|DERBY-481]] || Feature complete and documented. ||
|| LOB Improvements || Many performance and usability improvements for BLOBs and CLOBs. || [[https://issues.apache.org/jira/browse/DERBY-3805|DERBY-3805]], [[https://issues.apache.org/jira/browse/DERBY-3810|DERBY-3810]], [[https://issues.apache.org/jira/browse/DERBY-3907|DERBY-3907]], [[https://issues.apache.org/jira/browse/DERBY-3934|DERBY-3934]], [[https://issues.apache.org/jira/browse/DERBY-3935|DERBY-3935]], [[https://issues.apache.org/jira/browse/DERBY-3936|DERBY-3936]], [[https://issues.apache.org/jira/browse/DERBY-3970|DERBY-3970]], [[https://issues.apache.org/jira/browse/DERBY-3977|DERBY-3977]] || Completed (one small fix remaining). ||
|| Replication of encrypted databases || Make it possible to replicate encrypted databases. || [[https://issues.apache.org/jira/browse/DERBY-3890|DERBY-3890]], [[https://issues.apache.org/jira/browse/DERBY-3921|DERBY-3921]] || Feature complete, tests needed. ||
|| OFFSET/FETCH FIRST || limit result set cardinality (new SQL 2008 syntax) || [[https://issues.apache.org/jira/browse/DERBY-4079|DERBY-4079]] || Feature complete and documented. ||
|| In-memory back end || Storage engine for Derby storing all data in-memory. || [[https://issues.apache.org/jira/browse/DERBY-646|DERBY-646]] || First revision feature/code complete. No documentation. ||
|| Update Statistics Stored Procedure || Make it possible to refresh statistics || [[https://issues.apache.org/jira/browse/DERBY-269|DERBY-269]] || Feature complete and documented. ||
Line 50: Line 50:
|| Allow standard SQL "SET" keyword in ALTER COLUMN syntax: ALTER TABLE ALTER [COLUMN] <column-name> SET DEFAULT <default-value> || [https://issues.apache.org/jira/browse/DERBY-4013 DERBY-4013] || Done. || || Allow standard SQL "SET" keyword in ALTER COLUMN syntax: ALTER TABLE ALTER [COLUMN] <column-name> SET DEFAULT <default-value> || [[https://issues.apache.org/jira/browse/DERBY-4013|DERBY-4013]] || Done. ||
Line 58: Line 58:
[http://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&&pid=10594&resolution=-1&customfield_12310090=Regression&sorter/field=issuekey&sorter/order=DESC Regressions] X-( [[http://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&&pid=10594&resolution=-1&customfield_12310090=Regression&sorter/field=issuekey&sorter/order=DESC|Regressions]] X-(
Line 60: Line 60:
[http://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&&pid=10594&resolution=-1&customfield_12310090=Existing+Application+Impact&customfield_12310090=Release+Note+Needed&sorter/field=issuekey&sorter/order=DESC User impact] :o [[http://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&&pid=10594&resolution=-1&customfield_12310090=Existing+Application+Impact&customfield_12310090=Release+Note+Needed&sorter/field=issuekey&sorter/order=DESC|User impact]] :o
Line 62: Line 62:
[http://issues.apache.org/jira/browse/DERBY?report=com.atlassian.jira.plugin.system.project:popularissues-panel Popular] {OK} [[http://issues.apache.org/jira/browse/DERBY?report=com.atlassian.jira.plugin.system.project:popularissues-panel|Popular]] {OK}
Line 64: Line 64:
[http://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&&pid=10594&priority=1&priority=2&resolution=-1&sorter/field=issuekey&sorter/order=DESC Blocker and Critical] /!\ (priority) [[http://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&&pid=10594&priority=1&priority=2&resolution=-1&sorter/field=issuekey&sorter/order=DESC|Blocker and Critical]] /!\ (priority)
Line 66: Line 66:
[http://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&&pid=10594&resolution=-1&customfield_12310050=Blocker&customfield_12310050=Urgent&sorter/field=issuekey&sorter/order=DESC Blocker and Urgent] <!> (urgency) [[http://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&&pid=10594&resolution=-1&customfield_12310050=Blocker&customfield_12310050=Urgent&sorter/field=issuekey&sorter/order=DESC|Blocker and Urgent]] <!> (urgency)
Line 68: Line 68:
[https://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&&pid=10594&status=1&component=11406&sorter/field=issuekey&sorter/order=ASC&sorter/field=priority&sorter/order=DESC Open Documentation Issues] {i} [[https://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&&pid=10594&status=1&component=11406&sorter/field=issuekey&sorter/order=ASC&sorter/field=priority&sorter/order=DESC|Open Documentation Issues]] {i}
Line 70: Line 70:
[https://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&&type=1&pid=10594&status=1&status=3&status=4&component=11407&component=12312171&component=11409&component=11690&component=11410&component=11709&component=12312050&component=11411&component=11415&component=11408&component=11412&component=11414&sorter/field=issuekey&sorter/order=DESC  Open Bugs] [[https://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&&type=1&pid=10594&status=1&status=3&status=4&component=11407&component=12312171&component=11409&component=11690&component=11410&component=11709&component=12312050&component=11411&component=11415&component=11408&component=11412&component=11414&sorter/field=issuekey&sorter/order=DESC|Open Bugs]]
Line 87: Line 87:
|| Suran|| 2009-03-26|| Soft upgrade testing: From 10.4. Create database system/wombat with the old version. Then using the old derbyTesting.jar and 10.5 product jars, run suites.All. Issues found: [http://issues.apache.org/jira/browse/DERBY-4122 DERBY-4122], [http://issues.apache.org/jira/browse/DERBY-4127 DERBY-4127], [http://issues.apache.org/jira/browse/DERBY-4128 DERBY-4128], [http://issues.apache.org/jira/browse/DERBY-4135 DERBY-4135], plus missing release notes for [http://issues.apache.org/jira/browse/DERBY-2085 DERBY-2085] and [http://issues.apache.org/jira/browse/DERBY-1062 DERBY-1062]. DboPowersTest was hard upgrading the database [http://issues.apache.org/jira/browse/DERBY-4154 DERBY-4154]. Kathey hacked the hard upgrade out of the 10.4 test, reran and verified that we could access with 10.4 after the soft upgrade run|| || Suran|| 2009-03-26|| Soft upgrade testing: From 10.4. Create database system/wombat with the old version. Then using the old derbyTesting.jar and 10.5 product jars, run suites.All. Issues found: [[http://issues.apache.org/jira/browse/DERBY-4122|DERBY-4122]], [[http://issues.apache.org/jira/browse/DERBY-4127|DERBY-4127]], [[http://issues.apache.org/jira/browse/DERBY-4128|DERBY-4128]], [[http://issues.apache.org/jira/browse/DERBY-4135|DERBY-4135]], plus missing release notes for [[http://issues.apache.org/jira/browse/DERBY-2085|DERBY-2085]] and [[http://issues.apache.org/jira/browse/DERBY-1062|DERBY-1062]]. DboPowersTest was hard upgrading the database [[http://issues.apache.org/jira/browse/DERBY-4154|DERBY-4154]]. Kathey hacked the hard upgrade out of the 10.4 test, reran and verified that we could access with 10.4 after the soft upgrade run||
Line 100: Line 100:
|| Suran|| 2009-04-23 || Client/Server compatibility testing. 10.4 client against 10.5.1.1 server. [https://issues.apache.org/jira/browse/DERBY-4180 DERBY-4180]. Hit [https://issues.apache.org/jira/browse/DERBY-4053?focusedCommentId=12700873&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_12700873  DERBY-4053] unless UnsupportedVetter was removed from suite. ||
|| Suran|| 2009-04-27 || Client/Server compatibility testing. 10.5.1.1 client against 10.4.2.0 server. Only 2 errors caused by [https://issues.apache.org/jira/browse/DERBY-3319 DERBY-3319]. ||
|| Myrna|| 2009-04-28 || Tested Eclipse plugins, which required a new build of the ui/doc plugin. See: [https://issues.apache.org/jira/browse/DERBY-4194 DERBY-4194]. Also noticed: [https://issues.apache.org/jira/browse/DERBY-4195 DERBY-4195]  ||		 || Suran|| 2009-04-23 || Client/Server compatibility testing. 10.4 client against 10.5.1.1 server. [[https://issues.apache.org/jira/browse/DERBY-4180|DERBY-4180]]. Hit [[https://issues.apache.org/jira/browse/DERBY-4053?focusedCommentId=12700873&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_12700873|DERBY-4053]] unless UnsupportedVetter was removed from suite. ||
|| Suran|| 2009-04-27 || Client/Server compatibility testing. 10.5.1.1 client against 10.4.2.0 server. Only 2 errors caused by [[https://issues.apache.org/jira/browse/DERBY-3319|DERBY-3319]]. ||
|| Myrna|| 2009-04-28 || Tested Eclipse plugins, which required a new build of the ui/doc plugin. See: [[https://issues.apache.org/jira/browse/DERBY-4194|DERBY-4194]]. Also noticed: [[https://issues.apache.org/jira/browse/DERBY-4195|DERBY-4195]] ||

Table of Contents

Contents

  1. 10.5.1 Release Summary
  2. 10.5 Branch Information
  3. 10.5.1 Features
  4. 10.5.1 Small improvements
  5. 10.5.1 Bug Fixing
  6. 10.5.1 Testing

10.5.1 Release Summary

Derby 10.5.1 is a feature release.

Release Manager

Myrna van Lunteren

Creating of 10.5 branch

2009-03-16

Beta build (10.5.1.0) (for release management purposes)

2009-03-17

Draft Release Notes Circulated

2009-03-17

Release Candidate 1 (10.5.1.0 - rev. 757599)

2009-03-23

Sanity Testing and Voting (Blockers: DERBY-4122, DERBY-4125, DERBY-4127)

2009-03-23 - 2009-04-13

Release Candidate 2 (10.5.1.1 - rev. 764942)

2009-04-14

Sanity Testing and Voting

2009-04-14 - 2009-04-28

Target Release Date

2009-04-28

10.5.1.1 approved

2009-04-28

10.5 Branch Information

Revision

Event

755044

10.5 source branch created (from rev 755043)

755046

10.5 doc branch created (from rev 755043)

755053

trunk bumped to 10.6

757597

10.5 bumped to 10.5.1.0 (no longer beta); RC1 (10.5.1.0 rev. 757599)

757633

10.5 bumped to 10.5.1.1; RC2 (10.5.1.1 rev. 764942

764986

10.5 bumped to 10.5.1.2

10.5.1 Features

Feature numbers are found in the SQL 2003 standard and are mapped to Derby in SQLvsDerbyFeatures.

Feature (!)

Description

Associated JIRAs

Status

SQL Roles

Most of feature T331 and parts of T332

DERBY-2207

Feature complete and documented.

Generated Columns

Feature T175

DERBY-481

Feature complete and documented.

LOB Improvements

Many performance and usability improvements for BLOBs and CLOBs.

DERBY-3805, DERBY-3810, DERBY-3907, DERBY-3934, DERBY-3935, DERBY-3936, DERBY-3970, DERBY-3977

Completed (one small fix remaining).

Replication of encrypted databases

Make it possible to replicate encrypted databases.

DERBY-3890, DERBY-3921

Feature complete, tests needed.

OFFSET/FETCH FIRST

limit result set cardinality (new SQL 2008 syntax)

DERBY-4079

Feature complete and documented.

In-memory back end

Storage engine for Derby storing all data in-memory.

DERBY-646

First revision feature/code complete. No documentation.

Update Statistics Stored Procedure

Make it possible to refresh statistics

DERBY-269

Feature complete and documented.

10.5.1 Small improvements

Description

Associated JIRAs

Status

Allow standard SQL "SET" keyword in ALTER COLUMN syntax: ALTER TABLE ALTER [COLUMN] <column-name> SET DEFAULT <default-value>

DERBY-4013

Done.

10.5.1 Bug Fixing

Bugs that could be candidates for 10.5, ranked according to various criteria:

HighValueFixCandidates {*}

Regressions X-(

User impact :o

Popular {OK}

Blocker and Critical /!\ (priority)

Blocker and Urgent <!> (urgency)

Open Documentation Issues {i}

Open Bugs

10.5.1 Testing

Testing details can be found on the following pages:

List other testing here:

RC1 (10.5.1.0 - 757599)

Tester

Date

Additional Tests

Rick

2009-03-24

Verified signatures and md5 checksums of build artifacts of Release Candidate 1 (10.5.1.0)

Rick

2009-03-24

Verified the integrity of the top level links in index.html in the bin distribution of Release Candidate 1 (10.5.1.0)

Soft upgrade testing: From 10.3 and 10.4. Create database system/wombat with the old version. Then using the old derbyTesting.jar and 10.5 product jars, run suites.All. For older versions this is more ad hoc

Suran

2009-03-26

Soft upgrade testing: From 10.4. Create database system/wombat with the old version. Then using the old derbyTesting.jar and 10.5 product jars, run suites.All. Issues found: DERBY-4122, DERBY-4127, DERBY-4128, DERBY-4135, plus missing release notes for DERBY-2085 and DERBY-1062. DboPowersTest was hard upgrading the database DERBY-4154. Kathey hacked the hard upgrade out of the 10.4 test, reran and verified that we could access with 10.4 after the soft upgrade run

Hard upgrade testing: From 10.3 and 10.4. Create database system/wombat with old version. Connect with 10.5 with upgrade=true. Then run suites.all with 10.5 derbyTesting.jar and product jars.

Client/Server compatibility testing: Put derbyclient.jar and derbyTesting.jar from the old version and the other product jars from 10.5 in your classpath. Run tests and analyze failures

Behaviour compatibility testing: Run tests from an old derbyTesting.jar against 10.5 product jars. Analyze failures. Make sure there are release notes for all expected failures.

Rick

2009-03-31

Generated a dummy release from the source distribution of Release Candidate 1 (10.5.1.0). Verified that the dummy release had the same number of files as the release candidate.

RC2 (10.5.1.1 - 764942)

Tester

Date

Additional Tests

Myrna

2009-04-14

Verified signatures and md5 checksums of build artifacts of Release Candidate 1 (10.5.1.1) directly from build location

Knut Anders

2009-04-15

Verified that all the signatures and the checksums are correct, that the corresponding zips and tars have the exact same contents, and that it is possible to build the jars from the source tarball

Kim

2009-04-15

Did a spot-check of the documentation.

Rick

2009-04-16

Verified the links in index.html in the bin-zip distribution.

Rick

2009-04-16

Verified that the SignatureChecker behaves as expected when run against a moderately complicated Derby-powered app.

Suran

2009-04-23

Client/Server compatibility testing. 10.4 client against 10.5.1.1 server. DERBY-4180. Hit DERBY-4053 unless UnsupportedVetter was removed from suite.

Suran

2009-04-27

Client/Server compatibility testing. 10.5.1.1 client against 10.4.2.0 server. Only 2 errors caused by DERBY-3319.

Myrna

2009-04-28

Tested Eclipse plugins, which required a new build of the ui/doc plugin. See: DERBY-4194. Also noticed: DERBY-4195

DerbyTenFiveOneRelease (last edited 2009-09-20 22:11:10 by localhost)