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

Knut Anders Hatlen updated DERBY-4448:
--------------------------------------

    Attachment: forbid.diff

I tried a simple fix, removing the call to forbidGenerationOverrides() in 
InsertNode.bindStatement() and instead making sure 
InsertNode.enhanceAndCheckForAutoincrement() calls RCL.forbidOverrides() on all 
types of ResultSetNodes.

This made the problematic statement fail gracefully, but it introduced one 
failure in GeneratedColumnsTest.test_005_basicInsert(). That was the same 
failure as was seen with the first partial patch for DERBY-4433.

> ArrayIndexOutOfBoundsException when trying to override generated column
> -----------------------------------------------------------------------
>
>                 Key: DERBY-4448
>                 URL: https://issues.apache.org/jira/browse/DERBY-4448
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.3.0, 10.6.0.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Knut Anders Hatlen
>         Attachments: forbid.diff
>
>
> ij> create table t(a int, b generated always as (-a));
> 0 rows inserted/updated/deleted
> ij> insert into t(b) values (default), (2);
> ERROR XJ001: Java exception: '0 >= 0: 
> java.lang.ArrayIndexOutOfBoundsException'.

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

Reply via email to