Derby
  1. Derby
  2. DERBY-5274

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

    Details

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

      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

        No work has yet been logged on this issue.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development