db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4449) ArrayIndexOutOfBoundsException when inserting DEFAULT into unspecified column
Date Thu, 03 Jun 2010 09:25:54 GMT

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

Knut Anders Hatlen updated DERBY-4449:
--------------------------------------

    Attachment: derby-4449-1a.diff

The attached patch adds a check of the array index and skips the look-up in the array if the
index is out of range, so that the null check right below is triggered instead and makes the
statement fail gracefully. It also adds a regression test case in InsertTest.

I've started the full regression test suite.

> 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: Knut Anders Hatlen
>         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.


Mime
View raw message