• V Narayanan's avatar
    Bug#45983 ibmdb2i_create_index_option=1 not working for primary key · 2e8eb6ce
    V Narayanan authored
    With ibmdb2i_create_index_option set to 1, creating an IBMDB2I table
    with a primary key should produce an additional index that uses EBCDIC
    hexadecimal sorting. However, this does not work. Adding indexes that
    are not primary keys does work. The ibmdb2i_create_index_option should
    be honoured when creating a table with a primary key.
    
    This patch adds code to the create() function to check for the value
    of the ibmdb2i_create_index_option variable and, when appropriate, to 
    generate a *HEX-based shadow index in DB2 for the primary key. Previously 
    this behavior was limited to secondary indexes.
    
    Additionally, this patch restricts the creation of shadow indexes to
    cases in which a non-*HEX sort sequence is used, as the documentation
    for ibmdb2i_create_index_option describes. Previously, the shadow index
    would in some cases be created even when the MySQL-specific index used
    *HEX sorting, leading to redundant indexes.
    
    Finally, the code used to generate the list of fields for indexes 
    and the code used to generate the SQL statement for the shadow
    indexes has been refactored into individual functions.
    
    mysql-test/suite/ibmdb2i/r/ibmdb2i_bug_45983.result:
      Bug#45983 ibmdb2i_create_index_option=1 not working for primary key
      
      Result file for the test case.
    mysql-test/suite/ibmdb2i/t/ibmdb2i_bug_45983.test:
      Bug#45983 ibmdb2i_create_index_option=1 not working for primary key
      
      Add tests to verify that the ibmdb2i_create_index_option is being honoured
      when creating a table with a primary key.
    storage/ibmdb2i/ha_ibmdb2i.cc:
      Bug#45983 ibmdb2i_create_index_option=1 not working for primary key
      
      - Add code to the create() function to check for the value of the
        ibmdb2i_create_index_option variable and, when appropriate, to 
        generate a *HEX-based shadow index in DB2 for the primary key.
      
      - Restrict the creation of shadow indexes to cases in which a
        non-*HEX sort sequence is used.
      
      - Refractor code used to generate the list of fields for indexes
        and the code used to generate the SQL statement for the shadow
        indexes into individual functions.
    storage/ibmdb2i/ha_ibmdb2i.h:
      Bug#45983 ibmdb2i_create_index_option=1 not working for primary key
      
      Add function prototypes for the functions that.
      
      - Generate the list of fields for indexes
      - Generate the SQL statement for the shadow
        indexes
    2e8eb6ce
ha_ibmdb2i.h 24.4 KB