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

getColumns() doesn't work with auto generated identity columns that start with large numbers

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.7.1.1
    • Fix Version/s: 10.8.2.2, 10.9.1.0
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      Linux 10.3.
    • Bug behavior facts:
      Seen in production

      Description

      CREATE TABLE kb.constant_term
      (
      term_id BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 648518346341351400, INCREMENT BY 1),
      constant_name VARCHAR(1024) NOT NULL
      );

      The above SQL causes the table to be created but no columns to be defined (no error message is reported). If I change 648518346341351400 to a 0, then the table is created normally with all the columns defined correctly.

        Attachments

        1. derby-5274-1c-getColumns.diff
          4 kB
          Knut Anders Hatlen
        2. derby-5274-1b-getColumns.diff
          3 kB
          Knut Anders Hatlen
        3. derby-5274-1a-getColumns.diff
          3 kB
          Knut Anders Hatlen

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: