db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4442) Evaluation of default value and identity in an INSERT result set evaluated too early.
Date Mon, 05 Jul 2010 23:18:53 GMT

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

Mike Matrigali updated DERBY-4442:

backporting change #885421 from trunk to 10.5 branch.

m105_jdk16:76>svn commit
Sending        .
Sending        java/engine/org/apache/derby/impl/sql/compile/InsertNode.java
Sending        java/engine/org/apache/derby/impl/sql/compile/ResultSetNode.java
Sending        java/engine/org/apache/derby/impl/sql/compile/RowResultSetNode.java
Sending        java/engine/org/apache/derby/impl/sql/compile/UnionNode.java
Sending        java/testing/org/apache/derbyTesting/functionTests/master/intersect.out
Sending        java/testing/org/apache/derbyTesting/functionTests/tests/lang/DistinctTest.java
Sending        java/testing/org/apache/derbyTesting/functionTests/tests/lang/intersect.sql
Transmitting file data .......
Committed revision 960731.

> Evaluation of default value and identity in an INSERT result set evaluated too early.
> -------------------------------------------------------------------------------------
>                 Key: DERBY-4442
>                 URL: https://issues.apache.org/jira/browse/DERBY-4442
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions:
>            Reporter: Dag H. Wanvik
>            Assignee: Mike Matrigali
>             Fix For:
>         Attachments: always_prn.diff, backout-derby-4425.diff, d4442-1a.diff, d4442-1a.stat,
d4442-1b.diff, insert.diff
> In contrast to generated column, which are evaluated when the next row from the result
set to be inserted, currently default values and identity columns are generated "early", that
is as part of avaluating the subquery (SELECT or VALUES as the case may be). 
> This does not currently cause a user visible bug in Derby, but it lies behind DERBY-3
and the effect Bryan observed in DERBY-4.
> Additionally, "early" computation has given rise to much special handling and ensuing
bugs, cf. DERBY-1644, DERBY-4413, DERBY-4419, DERBY-4425 and others.
> DERBY-4397 requires this fix for correct behaviour with INSERT.
> See also
> https://issues.apache.org/jira/browse/DERBY-4413?focusedCommentId=12769532&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#action_12769532

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message