Derby
  1. Derby
  2. DERBY-4449

ArrayIndexOutOfBoundsException when inserting DEFAULT into unspecified column

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.3.0, 10.6.1.0
    • Fix Version/s: 10.5.3.1, 10.7.1.1
    • Component/s: SQL
    • Labels:
      None

      Description

      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.

      1. derby-4449-10.6.diff
        2 kB
        Lily Wei
      2. derby-4449-10.5.diff
        2 kB
        Lily Wei
      3. derby-4449-1a.diff
        2 kB
        Knut Anders Hatlen

        Issue Links

          Activity

          Knut Anders Hatlen created issue -
          Knut Anders Hatlen made changes -
          Field Original Value New Value
          Assignee Knut Anders Hatlen [ knutanders ]
          Knut Anders Hatlen made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Knut Anders Hatlen made changes -
          Attachment derby-4449-1a.diff [ 12446236 ]
          Knut Anders Hatlen made changes -
          Issue & fix info [Patch Available]
          Knut Anders Hatlen made changes -
          Status In Progress [ 3 ] Closed [ 6 ]
          Issue & fix info [Patch Available]
          Fix Version/s 10.7.0.0 [ 12314971 ]
          Resolution Fixed [ 1 ]
          Kathey Marsden made changes -
          Link This issue is required by DERBY-4728 [ DERBY-4728 ]
          Kathey Marsden made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Lily Wei made changes -
          Assignee Knut Anders Hatlen [ knutanders ] Lily Wei [ lilywei ]
          Lily Wei made changes -
          Attachment derby-4449-10.5.diff [ 12449013 ]
          Lily Wei made changes -
          Assignee Lily Wei [ lilywei ] Knut Anders Hatlen [ knutanders ]
          Lily Wei made changes -
          Status Reopened [ 4 ] Closed [ 6 ]
          Fix Version/s 10.5.3.1 [ 12314182 ]
          Fix Version/s 10.7.0.0 [ 12314971 ]
          Resolution Fixed [ 1 ]
          Knut Anders Hatlen made changes -
          Fix Version/s 10.7.0.0 [ 12314971 ]
          Lily Wei made changes -
          Attachment derby-4449-10.6.diff [ 12449323 ]
          Rick Hillegas made changes -
          Fix Version/s 10.7.1.1 [ 12315564 ]
          Fix Version/s 10.7.1.0 [ 12314971 ]
          Gavin made changes -
          Workflow jira [ 12482459 ] Default workflow, editable Closed status [ 12800835 ]

            People

            • Assignee:
              Knut Anders Hatlen
              Reporter:
              Knut Anders Hatlen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development