Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-15987

PK index inline size is not calculated correctly for keys with a single field

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.11
    • 2.13
    • sql
    • Implemented generate create table sql key type by original column type
    • Release Notes Required

    Description

      Example:

      CREATE TABLE IF NOT EXISTS TABLE1 (

        col1 varchar(15),

        col2 varchar(100),

        PRIMARY KEY(col1)

      );

      In this case PK inline size would be default 10. 

      CREATE TABLE IF NOT EXISTS TABLE2 (

        col1 varchar(15),

        col2 varchar(100),

        PRIMARY KEY(col1)

      ) WITH "WRAP_KEY=true";

      This one works correctly, inline size is 18.

      It seems that it works as expected only for  WRAP_KEY=true.

      Attachments

        Issue Links

          Activity

            People

              Berkov Alexander Belyak
              Berkov Alexander Belyak
              Iurii Gerzhedovich Iurii Gerzhedovich
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 20m
                  20m