Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-4449

ArrayIndexOutOfBoundsException when inserting DEFAULT into unspecified column

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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.

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: