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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 10.7.1.1
    • 10.8.2.2, 10.9.1.0
    • SQL
    • None
    • Linux 10.3.
    • 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-1a-getColumns.diff
          3 kB
          Knut Anders Hatlen
        2. derby-5274-1b-getColumns.diff
          3 kB
          Knut Anders Hatlen
        3. derby-5274-1c-getColumns.diff
          4 kB
          Knut Anders Hatlen

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: