db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (Updated) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-5687) Back out the concurrency improvements for identity columns introduced by derby-4437
Date Mon, 09 Apr 2012 15:41:17 GMT

     [ https://issues.apache.org/jira/browse/DERBY-5687?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Rick Hillegas updated DERBY-5687:

    Attachment: derby-5687-01-aa-backOutImprovement.diff

Attaching derby-5687-01-aa-backOutImprovement.diff. This patch backs out concurrency improvements
introduced by DERBY-4437. Regression tests passed cleanly for me. Committed at subversion

More specifically, this patch backs out the following patches:


  The main patch which ported the work on sequences to identity columns.


  Test cases to verify that the port did not break various features.


  Upgrade/downgrade tests for the port.

Touches the following files:

M       java/storeless/org/apache/derby/impl/storeless/EmptyDictionary.java
M       java/engine/org/apache/derby/impl/sql/compile/CreateSequenceNode.java
M       java/engine/org/apache/derby/impl/sql/compile/NextSequenceNode.java
M       java/engine/org/apache/derby/impl/sql/execute/InsertResultSet.java
M       java/engine/org/apache/derby/impl/sql/execute/BaseActivation.java
M       java/engine/org/apache/derby/impl/sql/execute/InsertConstantAction.java
M       java/engine/org/apache/derby/impl/sql/catalog/DataDictionaryImpl.java
M       java/engine/org/apache/derby/impl/sql/catalog/SequenceUpdater.java
M       java/engine/org/apache/derby/iapi/sql/dictionary/DataDictionary.java
M       java/engine/org/apache/derby/iapi/sql/dictionary/SequenceDescriptor.java
M       java/engine/org/apache/derby/iapi/reference/Property.java
M       java/testing/org/apache/derbyTesting/functionTests/tests/lang/AlterTableTest.java
M       java/testing/org/apache/derbyTesting/functionTests/tests/lang/AutoIncrementTest.java
D       java/testing/org/apache/derbyTesting/functionTests/tests/lang/t_4437_2.dat
M       java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/Changes10_9.java

> Back out the concurrency improvements for identity columns introduced by derby-4437
> -----------------------------------------------------------------------------------
>                 Key: DERBY-5687
>                 URL: https://issues.apache.org/jira/browse/DERBY-5687
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions:
>            Reporter: Rick Hillegas
>         Attachments: derby-5687-01-aa-backOutImprovement.diff
> DERBY-4437 attempted to improve the concurrency of identity columns by using SYSSEQUENCE-style
sequence generators. These improvements caused NsTest to behave differently than it used to
and they disclosed a problem in clearing the identity cache. The community lost confidence
in this solution and it was backed out of the 10.8 branch under issue DERBY-5448. This new
issue is filed to back the improvements out of the 10.9 trunk. Further useful discussion about
how to improve the concurrency and correctness of identity columns has been taking place on
DERBY-5443 and DERBY-5493.
> For the 10.9 release, identity columns will return to their old behavior of being ill-suited
for high concurrency applications. Applications which need higher concurrency should be re-coded
to use sequences rather than identity columns.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message