[jira] Commented: (DERBY-4449) ArrayIndexOutOfBoundsException when inserting DEFAULT into unspecified column

["Lily Wei (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-4449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12886460#action_12886460 ] 

Lily Wei commented on DERBY-4449:
---------------------------------

Will back port to 10.5

> ArrayIndexOutOfBoundsException when inserting DEFAULT into unspecified column
> -----------------------------------------------------------------------------
>
>                 Key: DERBY-4449
>                 URL: https://issues.apache.org/jira/browse/DERBY-4449
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.3.0, 10.6.1.0
>            Reporter: Knut Anders Hatlen
>            Assignee: Lily Wei
>             Fix For: 10.7.0.0
>
>         Attachments: derby-4449-1a.diff
>
>
> When inserting rows into a table, with just a subset of the table's columns in the target column list, an ArrayIndexOutOfBoundsException is raised if the table constructor contains the same number of columns as the target table, and the extra columns are specified as DEFAULT:
> ij> create table t (a int, b int);
> 0 rows inserted/updated/deleted
> ij> insert into t(a) values (1,default);
> ERROR XJ001: Java exception: '1 >= 1: java.lang.ArrayIndexOutOfBoundsException'.
> The insert statement should have failed with this error:
> ERROR 42802: The number of values assigned is not the same as the number of specified or implied columns.

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