Return-Path: X-Original-To: apmail-db-derby-commits-archive@www.apache.org Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id C5559D782 for ; Fri, 2 Nov 2012 00:32:27 +0000 (UTC) Received: (qmail 35027 invoked by uid 500); 2 Nov 2012 00:32:27 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 34984 invoked by uid 500); 2 Nov 2012 00:32:27 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 34974 invoked by uid 99); 2 Nov 2012 00:32:27 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Nov 2012 00:32:27 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Nov 2012 00:32:24 +0000 Received: from eris.apache.org (localhost [127.0.0.1]) by eris.apache.org (Postfix) with ESMTP id B5B6223888EA; Fri, 2 Nov 2012 00:31:40 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1404841 - in /db/derby/code/branches/10.8: RELEASE-NOTES.html releaseSummary.xml tools/ant/properties/release.properties Date: Fri, 02 Nov 2012 00:31:40 -0000 To: derby-commits@db.apache.org From: kmarsden@apache.org X-Mailer: svnmailer-1.0.8-patched Message-Id: <20121102003140.B5B6223888EA@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Author: kmarsden Date: Fri Nov 2 00:31:40 2012 New Revision: 1404841 URL: http://svn.apache.org/viewvc?rev=1404841&view=rev Log: DERBY-5924 Tasks for 10.8.3 maintenance release Checking in release notes and version bump Modified: db/derby/code/branches/10.8/RELEASE-NOTES.html db/derby/code/branches/10.8/releaseSummary.xml db/derby/code/branches/10.8/tools/ant/properties/release.properties Modified: db/derby/code/branches/10.8/RELEASE-NOTES.html URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/RELEASE-NOTES.html?rev=1404841&r1=1404840&r2=1404841&view=diff ============================================================================== --- db/derby/code/branches/10.8/RELEASE-NOTES.html (original) +++ db/derby/code/branches/10.8/RELEASE-NOTES.html Fri Nov 2 00:31:40 2012 @@ -1,10 +1,10 @@ -Release Notes for Apache Derby 10.8.2.2 +Release Notes for Apache Derby 10.8.3.0

-Release Notes for Apache Derby 10.8.2.2

+Release Notes for Apache Derby 10.8.3.0
-

These notes describe the difference between Apache Derby release 10.8.2.2 and the preceding release 10.8.1.2.

+

These notes describe the difference between Apache Derby release 10.8.3.0 and the preceding release 10.8.2.2.

  • @@ -87,492 +87,427 @@ This is a bug fix release. No new featur

    Bug Fixes

    -

    The following issues are addressed by Derby release 10.8.2.2. These issues are not addressed in the preceding 10.8.1.2 release.

    +

    The following issues are addressed by Derby release 10.8.3.0. These issues are not addressed in the preceding 10.8.2.2 release.

    - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - + - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
    Issue IdDescription
    DERBY-5452Possible NPE in NsTest.printException()DERBY-5951Missing method exception raised when using Clobs with territory based collation
    DERBY-5448In the 10.8 branch, back out the concurrency improvements introduced by using SequenceUpdaters to allocate identity values.DERBY-5937File handle is leaked when a Slave replication is shutdown with failover=true
    DERBY-5447Deadlock in AutomaticIndexStatisticsTest.testShutdownWhileScanningThenDelete (BasePage.releaseExclusive and Observable.deleteObserver (BaseContainerHandle))DERBY-5925Document derby.log changes resulting from DERBY-5240
    DERBY-5445Enhance existing concurrency test to stress sequence generators to also stress identity columnsDERBY-5918CREATE TABLE AS SELECT doesn't work on tables with BOOLEAN columns
    DERBY-5444SpawnedProcess.complete may fail to destroy the process when a timeout is specifiedDERBY-5916java.lang.NullPointerException org.apache.derby.impl.store.raw.data.BaseDataFileFactory.stop() connecting to network server
    DERBY-5438Empty MAPS table in toursdbDERBY-5912testIsValidImplemented fails for NetworkServer in some slow running machines/configurations
    DERBY-5426Improve the error raised by too much contention on a sequence/identity.DERBY-5911WHERE condition getting pushed into sub-query with FETCH
    DERBY-5421NullPointerException during system.nstest.utils.Dbutil.update_one_rowDERBY-5910Document use of Connection.close() with try-with-resources
    DERBY-5419Make Derby run on Oracle Java ME Embedded ClientDERBY-5909The lang attribute in toc.html always says 'en-us'
    DERBY-5418Network server session's close method neglects to close down any open trace fileDERBY-5906In the Reference Manual, sin() is used as the example for the sinh() function.
    DERBY-5414SysDiagVTIMappingTest.test_5391() failed: java.text.ParseException: Unparseable date: "Thu Sep 15 14:00:16 CEST 2011"DERBY-5905Derby html documentation doesn't render properly and prints garbage on Internet Explorer
    DERBY-5413NetworkServerControl#main can exit with status 1 without printing an error message to consoleDERBY-5900Need to correct Reference Guide description of contents of SYS.SYSPERMS.OBJECTTYPE
    DERBY-5412MemoryLeakFixesTest.testRepeatedDatabaseCreationWithAutoStats() fails on phoneME: java.lang.InternalError: Number of class names exceeds vm limit.DERBY-5898add ibm18 class to functionTests.harness
    DERBY-5409GrantRevokeDDLTest fails under Java 7DERBY-5838By using syscs_set_database_property, you can set the database version to a garbage string which prevents you from booting the database.
    DERBY-5408parameters for message 2200H - sequence generator does not cycle - is out of sync in non-English messagesDERBY-5830Make DoubleProperties.propertyNames() thread-safe
    DERBY-5404Document DBO restriction for four diagnostic VTIsDERBY-5822Document the new SQL standard behavior of the SPACE_TABLE vti
    DERBY-5402Assignment instead of comparison in Driver20.getPropertyInfoDERBY-5805Database encryption topics in Reference Manual need more information
    DERBY-5398NullPointerException in storemore/bug3498.sqlDERBY-5799add more info on when Derby chooses 32k page size for tables.
    DERBY-5396DRDAStatement and DRDAConnThread swallow IOExceptionsDERBY-5775Upgrade tests should print full IOException stack trace when it fails to access old versions
    DERBY-5395By default, only the DBO should be allowed to run several of the diagnostic VTIs.DERBY-5727Update POMs to deploy Maven artifacts to repository.apache.org and use ASF parent POM
    DERBY-5394Reduce chance of OOME with XAMemTest.testDerby4137_TransactionTimeoutSpecifiedNotExceeded in low memory suiteDERBY-5692intermittent test failure in storetests/st_derby715.java
    DERBY-5393Remove old in-memory database purge mechanismDERBY-5691Document that Write Caching must be disabled to avoid possible database corruption
    DERBY-5391The syscs_diag.error_log_reader() and syscs_diag.statement_duration() vtis do not work on derby error logs created since 10.7.1DERBY-5681When a foreign key constraint on a table is dropped, the associated statistics row for the conglomerate is not removed
    DERBY-5390NPE in BasicDatabase.stop in replication slave mode (dd.clearSequenceCaches)DERBY-5663Getting NPE when trying to set derby.language.logStatementText property to true inside a junit suite.
    DERBY-5389SequenceGeneratorTest failures with weme 6.2 sane build ASSERT FAILED Identity being changed on a live cacheableDERBY-5649make improvements to nstest so it's easier to run/analyze/debug
    DERBY-5385Improve documentation for OFFSET/FETCH NEXTDERBY-5638intermittent test failure in test_05_ClobNegative when running full largedata._Suite; LobLimitsTestjava.sql.SQLException: Table/View 'BLOBTBL' already exists in Schema 'APP'.
    DERBY-5384Reference Guide talks about a DriverManager method which does not exist.DERBY-5633Add tests for state transition and behavior with Lock Timeout in XA Transaction (DERBY-5552 testing task)
    DERBY-5376Documentation should state authentication/authorization requirements more stronglyDERBY-5624System can run out of stack space while processing DropOnCommit requests.
    DERBY-5372Need to document that the != and <> operators are pushed into Restricted table functions (once the work on DERBY-5369 wraps up)DERBY-5622Reduce the chance for hash collisions when checking bootPassword at boot time and when changing password.
    DERBY-5367Stale data retrieved when using new collation=TERRITORY_BASED:PRIMARY featureDERBY-5617Improve process handling in SpawnedProcess
    DERBY-5362HTML frameset files lack closing newline characterDERBY-5616demo/vtis/sql/demoFileVtis.sql needs to be adjusted: messages_en.properties has moved
    DERBY-5361Document use of URLs with SQLJ.INSTALL_JARDERBY-5614NullPointerException with INSERT INTO [global temporary table] SELECT ... FROM [VTI]
    DERBY-5354Remove unnecessary dita.regex build targetDERBY-5609Prepare old test harness for running tests on Java 8
    DERBY-5352Derby table functions stored in a jar file inside the database which implement VTICosting or RestrictedVTI fail with ClassNotFoundExceptionDERBY-5608BaseTestCase.readProcessOutput should read getInputStream() and getErrorStream() in separate threads
    DERBY-5350Devguide needs update for definer's rightsDERBY-5603EmbedConnection.clearLOBMapping() incorrectly clears lobFiles causing a ConcurrentModificationException
    DERBY-5339Sample domain names should follow RFC 2606 conventionsDERBY-5599readlocks.sql fails with extra locks.
    DERBY-5336Repeated database creation causes OutOfMemoryErrorDERBY-5598testStartWithPrintWriter(org.apache.derbyTesting.functionTests.tests.derbynet.DerbyNetNewServerTest)junit.framework.AssertionFailedError: Num of log item should add
    DERBY-5334Incorrect permission arguments given for SYSCS_UTIL.SYSCS_SET_USER_ACCESSDERBY-5586Remove the fo2html.xsl script from the docs repository and fix the docs and release builds so that they don't build monohtml versions of the Derby manuals.
    DERBY-5333Intermittent assert failure in testInterruptShutdown: thread's interrupted flag lost after shutdownDERBY-5584Select statement with subqueries with group by and count distinct statements returns wrong number of results
    DERBY-5331Incorrect use of CharsetEncoder in DDMWriterDERBY-5582Access denied (java.lang.RuntimePermission modifyThreadGroup) in IndexStatisticsDaemonImpl.schedule()
    DERBY-5329Document who is allowed to run which system procedures/functions.DERBY-5574encryption test in encryption nightly suite test fails with ERROR XBM0S: Unable to rename file error
    DERBY-5325Checkpoint fails with ClosedChannelException in InterruptResilienceTestDERBY-5567AlterTableTest#testDropColumn fails: drop view cannot be performed due to dependency
    DERBY-5318Use assertDirectoryDeleted in ReplicationRun and remove dead codeDERBY-5564Code does different things depending if derby.locks.deadlockTrace=true is set
    DERBY-5314Enable i18n tests in non-English localesDERBY-5562An read-only XA transaction that has a timeout never has the timer canceled when the transaction is complete
    DERBY-5312InterruptResilienceTest failed with ERROR 40XD1: Container was opened in read-only mode.DERBY-5561Race conditions in LogicalConnection checking for a null physical connection
    DERBY-5307Document the behavior of the derby.language.sequence.preallocator property.DERBY-5552Derby threads hanging when using ClientXADataSource and a deadlock or lock timeout occurs
    DERBY-5304test_derby_4779 (lang.GeneratedColumnsTest) fails with ibm 1.4.2; ERROR 42X50; No method was found that matched the method call java.lang.Integer.signum(int)DERBY-5547NSSecurityMechanismTest fixture testNetworkServerSecurityMechanism fails intermittentlyt
    DERBY-5299Document what you should expect to see if you enable authentication/authorization on a database which was created without those safeguards.DERBY-5531Assert failure when inserting NULL into indexed column with territory-based collation
    DERBY-5292SQLAuthorisation and viewsDERBY-5530SQLChar.getCollationKey NPE in index-stat-thread
    DERBY-5291test failure: NullPointerException with J2ME (weme 6.2) in testDerby4137_TransactionTimeoutSpecifiedNotExceeded(org.apache.derbyTesting.functionTests.tests.memory.XAMemTest)DERBY-5527Documentation problem: 5 - Verifying the copy of the files
    DERBY-5289Unable to boot 10.5.1.1 database - fails during soft/hard upgrade process for a new version number while trying to drop jdbc metadataDERBY-5526on upgrade from 10.5 to 10.8.2 , getting ERROR XBM0A: The database directory 'C:\cygwin\home\debugfat\clientdb' exists. However, it does not contain the expected 'service.properties' file.
    DERBY-5284A derby crash at exactly right time during a btree split can cause a corrupt db which can not be booted.DERBY-5517testReplication_Local_3_p1_StateNegativeTests failed with connection refused
    DERBY-5280Large batch of DDL in a database procedure dies on a transaction severity error.DERBY-5509javadoc for NetServlet and NetworkServerControl are missing a few closing tags
    DERBY-5278AssertionFailedError in IndexSplitDeadlockTest.testBTreeForwardScan_fetchRows_resumeAfterWait_unique_split()DERBY-5508Improve backup/restore documentation visibility and content to encourage proper backups and restore procedures
    DERBY-5276Reference manual has wrong length for BIGINT columns in system tablesDERBY-5467Copyright notice in the API documentation (generated by the Javadoc tool) is outdated
    DERBY-5274getColumns() doesn't work with auto generated identity columns that start with large numbersDERBY-5465Broken null checks in NsTest
    DERBY-5271Client may hang if the server crashes due to a java.lang.ErrorDERBY-5456Problems running SecureServerTest and replication tests on Open JDK 7 for Mac OS X
    DERBY-5264OOM issue using XA with timeouts with Java 1.4DERBY-5454ERROR 40001 deadlock in nstest on select max(serialkey)
    DERBY-5262Running JUnit tests with Java 1.4.2 fails if the package private tests are on the classpathDERBY-544910.8 client with 10.5 server gives java.lang.ClassCastException: java.lang.Boolean incompatible with java.lang.Short in NetStatementRequest.buildFDODTA with CursorTest.testCursorParam()
    DERBY-5258btree post commit releases latch before committing/aborting purges, possibly allowing other operation on pageDERBY-5440test failure in testBTreeForwardScan_fetchRows_resumeAfterWait_nonUnique_split(org.apache.derbyTesting.functionTests.tests.store.IndexSplitDeadlockTest)junit.framework.AssertionFailedError: expected:<1> but was:<0>
    DERBY-5255Fix more difficult table problemsDERBY-5427Unauthorized shutdown should not generate thread dump and javacore. AuthenticationTest dumps over 20 javacores with IBM JVM for normal user errors
    DERBY-5254The keywords introduced by the CREATE SEQUENCE work are treated as reserved rather than unreserved.DERBY-5425Updateable holdable ResultSet terminates early after 65638 updates
    DERBY-5253Engine code references org.apache.derby.shared.common.sanity.SanityManagerDERBY-5407When run across the network, dblook produces unusable DDL for VARCHAR FOR BIT DATA columns.
    DERBY-5252make GrantRevokeTest pass in non-English localeDERBY-5406Intermittent failures in CompressTableTest and TruncateTableTest
    DERBY-5251make ErrorCodeTest pass in non-English localeDERBY-5379testDERBY5120NumRowsInSydependsForTrigger - The number of values assigned is not the same as the number of specified or implied columns.
    DERBY-5249A table created with 10.0.2.1 with constraints cannot be dropped with 10.5 due to NullPointerException with insane build or ASSERT FAILED Failed to find sharable conglomerate descriptor for index conglomerate with sane buildDERBY-5377AssertionFailedError in testCaseCS4595B_NonUniqueIndex in AccessTest
    DERBY-5247Warnings regarding XPath displayed when generating JavaDocDERBY-5370The toSQL method of the org.apache.derby.vti.Restriction class does not output correct constants for VARCHAR, Timestamp, Date, Time, or CHAR FOR BIT DATA types
    DERBY-5243assert failure in test testRAFReadWriteMultipleThreads: interrupted flag clearedDERBY-5369Restricted Table Function support should pass NOT EQUAL restrictions to initScan
    DERBY-5239Remove usages of DriverManager to obtain an Embedded Connection in Derby ServerDERBY-5358SYSCS_COMPRESS_TABLE failed with conglomerate not found exception
    DERBY-5238VARCHAR size typos in some documentation topicsDERBY-5305Convert store/updatelocks.sql to JUnit
    DERBY-5236Client driver silently truncates strings that exceed 32KBDERBY-5272Stop building Eclipse plugins as Derby release artifacts
    DERBY-5233Interrupt of create table or index (i.e. a container) will throw XSDF1 under NIO - connection survivesDERBY-5240Log Operating system information to derby.log on boot
    DERBY-5226SQLJ system procedures should be documented in Reference ManualDERBY-5096DisconnectException: "Connection was refused because the database DB was not found" when creating db for first time
    DERBY-5223Thread's interrupted flag not always preserved after Derby returns from JDBC API callDERBY-4631Wrong join column returned by right outer join with NATURAL or USING and territory-based collation
    DERBY-5222Compatibility tests fail to delete database directoryDERBY-4291Intermittent failure in 'store/updatelocks.sql' on Windows Vista
    DERBY-5217make ImportExportIJTest pass in non-English localeDERBY-4279Statement cache deadlock
    DERBY-5215Localize messages introduced or changed in 10.7 and 10.8DERBY-4229encryptionKeyLength connection attribute should be documented
    DERBY-5212Reference Manual: language on authentication/authorization needs changes for several URL attribute topicsDERBY-4201SecureServerTest AssertionFailedError: Timed out waiting for network server to start
    DERBY-5211Make SysinfoCPCheckTest pass in non-English localeDERBY-3823NullPointerException in stress.multi test
    DERBY-5205Documentation: toc.html files need lang attributeDERBY-3808Convert subquery.sql to junit
    DERBY-5204Misplaced p tags in release notesDERBY-3740BlobClob4BlobTest.testLockingWithLongRowBlob fails with .AssertionFailedError: FAIL - statement should timeout
    DERBY-5203Documentation of drop=true attribute contains errorDERBY-2687store/encryptDatabase.sql fails intermittently with ClassNotFoundException, Log Corrupted
    DERBY-5198XPLAIN table documentation needs some cleanupDERBY-1913storetests/st_reclaim_longcol.java fails intermittently
    DERBY-5191Documentation needed for connection URL attribute retrieveMessageText
    DERBY-5184Tables in documentation need introductions and formatting fixes
    DERBY-5158Incomprehensible error message on client if attempting rollback after database has been shut down.
    DERBY-5120Row from SYSDEPENDS gets deleted when a table has update triggers defined on it and an upate is made to the table
    DERBY-5108Intermittent failure in AutomaticIndexStatisticsTest.testShutdownWhileScanningThenDelete on Windows
    DERBY-5098embedded/in-memory: SQLNonTransientConnectionException: No current connection due to invalid page format
    DERBY-5097testMTSelect(org.apache.derbyTesting.functionTests.tests.store.AutomaticIndex StatisticsMultiTest)junit.framework.AssertionFailedError: failed to get statisti cs for table MTSEL (#expected=2, timeout=0) on AIX IBM JDK 1.5
    DERBY-5084convert ijConnName.sql to a ScriptTest junit test
    DERBY-5044ALTER TABLE DROP COLUMN will not detect triggers defined on other tables with their trigger action using the column being dropped
    DERBY-5014Tests should restore the timeout values to default after they are done running.
    DERBY-4984ALTER TABLE DROP COLUMN may leave triggers invalid even if they are not using the column getting dropped.
    DERBY-4779NPE while inserting into a table which has a generated column and an insert trigger
    DERBY-4670ThreadDump class included in insane jars
    DERBY-4669ClassLoaderBootTest fails if derbyclient.jar comes before derby.jar on the classpath
    DERBY-4647BaseTestCase.execJavaCmd() does not work with weme 6.2
    DERBY-4637The Developer's Guide implies that, for in-memory database names, Derby does not resolve relative and absolute paths to the same in-memory database
    DERBY-4617Sysinfo.testSysinfoLocale failed with IB47 M 1.6 on Windows 7 64bit
    DERBY-4443Wrap rollback in exception handlers in try-catch
    DERBY-4408missing DOCTYPE and META tags in toc.html and index.html pages
    DERBY-4275Query executions fail when compressing a table using SYSCS_UTIL.SYSCS_COMPRESS_TABLE
    DERBY-4260Make derbynet/NetworkServerControlClientCommandTest run regardless of the locale
    DERBY-4200client side OutOfMemoryError running derbnetclientmats:jdbcapi/derbyStress
    DERBY-4137OOM issue using XA with timeouts
    DERBY-3870Concurrent Inserts of rows with XML data results in an exception
    DERBY-3337convert jdbcapi/derbyStress.java to JUnit
    DERBY-2625SEVERE error involving column-width property
    DERBY-2623SEVERE error involving column-number property
    DERBY-2254Assert during log file switch: log file position exceeded max log file size
    DERBY-1903Convert largedata/LobLimits.java to junit
    DERBY-1780Document all supplied system procedures in the Server and Administration Guide (e.g. class loading utils and import/export)
    DERBY-1046JVMInfo is duplicated in derbyclient.jar
    DERBY-484Documentation for derby.database.classpath in developers guide is misleading
    DERBY-159When Derby runs in Network Server mode, client does not receive warnings generated by Derby - should get documentedDERBY-1721DOCS - Remove duplicate information in Dev Guide re: Encryption

    Issues

    -

    Compared with the previous release (10.8.1.2), Derby release 10.8.2.2 introduces the following new features and incompatibilities. These merit your special attention.

    +

    Compared with the previous release (10.8.2.2), Derby release 10.8.3.0 introduces the following new features and incompatibilities. These merit your special attention.

    -Note for DERBY-5395

    +Note for DERBY-5564
    + +

    Summary of Change

    -Now, only the database owner may view several diagnostic VTIs: syscs_diag.statement_cache, syscs_diag.transaction_table, syscs_diag.error_log_reader( ), and syscs_diag.statement_duration(). +The SQL state of the error returned from a lock timeout when the property "derby.locks.deadlockTrace=true" is set will return 40XL1 rather than 40XL2. +

    Symptoms Seen by Applications Affected by Change

    -Previously in a database with SQL authorization enabled, any user -could select from those diagnostic VTIs. Now only the database owner -can. + In the previous release, applications which set + "derby.locks.deadlockTrace=true" would get error 40XL2 when a lock timeout + was received. This was confusing as simply setting the system to return + extra diagnostic information would change the SQL state of the error + returned by the system for a lock timeout.

    + +

    Incompatibilities with Previous Release

    -Application designers should ensure that only the database owner -selects from these VTIs. For most applications this should not be a -problem since the VTIs are intended to be used in production only as -technical support tools. + Applications which explicitly tested for SQL state error 40XL2 as a lock + timeout will no longer get that error. 40XL1 will now always be returned + for a lock timeout error whether lock diagnostics are enabled or not.

    + +

    Rationale for Change

    -These VTIs reveal sensitive information which only authorized persons -should see. + The previous behavior was not intended. Lock timeout should generate same + SQL state whether diagnostics are enabled or not. Only the text of the error + will change based on the requested diagnostic level.

    + +

    Application Changes Required

    -Table functions with definer's rights can be used to grant other users -access to the information in these VTIs. For instance, the following -technique can be used to let ordinary users view the non-sensitive data in syscs_diag.statement_cache: + If the application has been explicitly coded to take action when getting + error 40XL2 and does not do the same action for 40XL1, then the application + should be changed. This action is usually retry logic based on a lock + timeout or deadlock.

    -

    -First, create a static Java method which selects only the -non-sensitive columns: -

    +
    +
    +

    +Note for DERBY-4631

    +
    -
    -import java.sql.DriverManager;
-import java.sql.ResultSet;
-import java.sql.SQLException;
-
-public class SafeCacheViewer
-{
-    public  static  ResultSet   safeCacheViewer()   throws SQLException
-    {
-        return DriverManager.getConnection( "jdbc:default:connection" ).prepareStatement
-            ( "select id, schemaName, valid, compiled_at from syscs_diag.statement_cache" ).executeQuery();
-    }
-}
-
    + + + +

    Summary of Change

    -Then the database owner should register the method as a table function -enjoying definer's rights, and grant EXECUTE -privilege on it to PUBLIC: +Derby can pick incorrect join column value for a RIGHT OUTER JOIN with NATURAL/USING clause.

    -
    -create function safeCacheViewer()
-returns table
-(
-    id char( 36 ),
-    schemaName varchar( 128 ),
-    valid boolean,
-    compiled_at timestamp
-)
-language java parameter style derby_jdbc_result_set reads sql data
-external security definer
-external name 'SafeCacheViewer.safeCacheViewer';
+
 
 
+
    Symptoms Seen by Applications Affected by Change
    
+
 
    
-Finally, other users can select data from the table function as
-follows (here test_dbo is the schema of the database owner):
+In case of RIGHT OUTER JOIN with NATURAL/USING clause, Derby always picked the join column's value from the 
+right table. This could lead to incorrect join column value depending on the data in the tables. The correct
+value should be determined by doing equivalent of COALESCE(leftTableValue, rightTableValue). This correct 
+behavior has been implemented as a fix for DERBY-4631.
 
    
 
 
-
    -select * from table( test_dbo.safeCacheViewer() ) s;
-
    
+
+
+
+
    Incompatibilities with Previous Release
    
+
+
    
+The data returned for join column value for a RIGHT OUTER JOIN with NATURAL/USING clause can now be different(and correct).
+
    
 
 
 
@@ -581,22 +516,31 @@ select * from table( test_dbo.safeCacheV
 
    
 Build Environment
    
 
    
-
    Derby release 10.8.2.2 was built using the following environment:
    
+
    Derby release 10.8.3.0 was built using the following environment:
    
 
      
 
    • 
 Branch - Source code came from the 10.8 branch.
      • 
 
    • 
-Machine - Windows XP Professional Version 2002 Service Pack 3
      • 
+Machine - Cygwin on Windows 7 Service Pack 1 
 
    • 
 Ant - Apache Ant version 1.7.0 compiled on December 13 2006.
      • 
 
    • 
-JDK 1.4 - Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2) Classic VM (build 1.4.2, J2RE 1.4.2 IBM Windows 32 build cn142ifx-20110211 (SR13 FP8+PM31983)).
      • 
+JDK 1.4 -  Classic VM (build 1.4.2, J2RE 1.4.2 IBM Windows 32 build cn142ifx-20110211 (SR13 FP8+PM31983) (JIT enabled: jitc))
+
 
    • 
-Java 6 - Java(TM) SE Runtime Environment (build pwi3260sr9fp1-2011-0208_03(SR9 FP1) IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 Windows XP x86-32 jvmwi3260sr9-20110203_74623).
      • 
+Java 6 - 
+java version "1.6.0"
+Java(TM) SE Runtime Environment (build pwi3260sr9fp1-20110208_03(SR9 FP1))
+IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 Windows 7 x86-32 jvmwi3260sr9-20110203_74623 (JIT enabled, AOT enabled)
+J9VM - 20110203_074623
+JIT  - r9_20101028_17488ifx3
+GC   - 20101027_AA)
+JCL  - 20110203_01
+
 
    • 
-Compiler - The 1.6.0-b105 javac was used to compile all classes.
      • 
+Compiler - The IBM javac 1.6.0  javac was used to compile all classes.
 
    • 
-JSR 169 - Java ME support was built using libraries from IBM's j9 jvm from WEME 6.2.
      • 
+JSR 169 -  Java ME support was built using libraries from IBM's j9 jvm from WEME 6.2.
 
    
 
    
 
    

Modified: db/derby/code/branches/10.8/releaseSummary.xml
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/releaseSummary.xml?rev=1404841&r1=1404840&r2=1404841&view=diff
==============================================================================
--- db/derby/code/branches/10.8/releaseSummary.xml (original)
+++ db/derby/code/branches/10.8/releaseSummary.xml Fri Nov  2 00:31:40 2012
@@ -33,7 +33,7 @@ with real information.
     E.g.: 10.2.1.7
 
 -->
-10.8.1.2
+10.8.2.2
 
 
-  Windows XP Professional Version 2002 Service Pack 3
+  Cygwin on Windows 7 Service Pack 1 
 
   
   Apache Ant version 1.7.0 compiled on December 13 2006.
 
   
-  Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2) Classic VM (build 1.4.2, J2RE 1.4.2 IBM Windows 32 build cn142ifx-20110211 (SR13 FP8+PM31983)).
+   Classic VM (build 1.4.2, J2RE 1.4.2 IBM Windows 32 build cn142ifx-20110211 (SR13 FP8+PM31983) (JIT enabled: jitc))
+
 
   
-  Java(TM) SE Runtime Environment (build pwi3260sr9fp1-2011-0208_03(SR9 FP1) IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 Windows XP x86-32 jvmwi3260sr9-20110203_74623).
+  
+java version "1.6.0"
+Java(TM) SE Runtime Environment (build pwi3260sr9fp1-20110208_03(SR9 FP1))
+IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 Windows 7 x86-32 jvmwi3260sr9-20110203_74623 (JIT enabled, AOT enabled)
+J9VM - 20110203_074623
+JIT  - r9_20101028_17488ifx3
+GC   - 20101027_AA)
+JCL  - 20110203_01
+
 
   
-  The 1.6.0-b105 javac was used to compile all classes.
+  The IBM javac 1.6.0  javac was used to compile all classes.
 
   
-  Java ME support was built using libraries from IBM's j9 jvm from WEME 6.2.
+   Java ME support was built using libraries from IBM's j9 jvm from WEME 6.2.
 
 
 

Modified: db/derby/code/branches/10.8/tools/ant/properties/release.properties
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/tools/ant/properties/release.properties?rev=1404841&r1=1404840&r2=1404841&view=diff
==============================================================================
--- db/derby/code/branches/10.8/tools/ant/properties/release.properties (original)
+++ db/derby/code/branches/10.8/tools/ant/properties/release.properties Fri Nov  2 00:31:40 2012
@@ -15,12 +15,12 @@
 
 
 drdamaint=1
-maint=2000003
+maint=3000000
 major=10
 minor=8
 eversion=10.8
 beta=false
-copyright.comment=Copyright 1997, 2011 The Apache Software Foundation or its licensors, as applicable.
+copyright.comment=Copyright 1997, 2012 The Apache Software Foundation or its licensors, as applicable.
 vendor=The Apache Software Foundation
 copyright.year=2011
-release.id.long=10.8.2.3
+release.id.long=10.8.3.0