• Gleb Shchepa's avatar
    Bug #39653: find_shortest_key in sql_select.cc does not · 89786381
    Gleb Shchepa authored
                consider clustered primary keys
    
    Choosing a shortest index for the covering index scan,
    the optimizer ignored the fact, that the clustered primary
    key read involves whole table data.
    
    The find_shortest_key function has been modified to
    take into account that fact that a clustered PK has a
    longest key of possible covering indices.
    89786381
innodb_mysql.test 15.5 KB