• unknown's avatar
    Fix for bug #31137: Assertion failed: primary_key_no == -1 || primary_key_no == 0, · d7d93cf5
    unknown authored
    file .\ha_innodb.
    
    Problem: if a partial unique key followed by a non-partial one we declare
    the second one as a primary key.
    
    Fix: sort non-partial unique keys before partial ones.
    
    
    include/my_base.h:
      Fix for bug #31137: Assertion failed: primary_key_no == -1 || primary_key_no == 0, 
      file .\ha_innodb.
        - sort unique keys that don't contain partial segments before other keys:
            set HA_KEY_HAS_PART_KEY_SEG flag for such keys in the mysql_prepare_table(),
            use it in the sort_keys();
    mysql-test/r/innodb_mysql.result:
      Fix for bug #31137: Assertion failed: primary_key_no == -1 || primary_key_no == 0, 
      file .\ha_innodb.
        - test result.
    mysql-test/r/key.result:
      Fix for bug #31137: Assertion failed: primary_key_no == -1 || primary_key_no == 0, 
      file .\ha_innodb.
        - test result.
    mysql-test/t/innodb_mysql.test:
      Fix for bug #31137: Assertion failed: primary_key_no == -1 || primary_key_no == 0, 
      file .\ha_innodb.
        - test case.
    mysql-test/t/key.test:
      Fix for bug #31137: Assertion failed: primary_key_no == -1 || primary_key_no == 0, 
      file .\ha_innodb.
        - test case.
    sql/sql_table.cc:
      Fix for bug #31137: Assertion failed: primary_key_no == -1 || primary_key_no == 0, 
      file .\ha_innodb.
        - sort unique keys that don't contain partial segments before other keys:
            set HA_KEY_HAS_PART_KEY_SEG flag for such keys in the mysql_prepare_table(),
            use it in the sort_keys();
    sql/structs.h:
      Fix for bug #31137: Assertion failed: primary_key_no == -1 || primary_key_no == 0, 
      file .\ha_innodb.
        - sort unique keys that don't contain partial segments before other keys:
            set HA_KEY_HAS_PART_KEY_SEG flag for such keys in the mysql_prepare_table(),
            use it in the sort_keys();
    d7d93cf5
innodb_mysql.result 32.7 KB