• Igor Babaev's avatar
    MDEV-21356 ERROR 1032 Can't find record when running simple, single-table query · 4de32015
    Igor Babaev authored
    This bug could happen when both optimizer switches 'mrr' and 'mrr_sort_keys'
    are enabled and the optimizer decided to use a rowid filter when
    accessing an InnoDB table by a secondary key. With the above setting
    any access by a secondary is converted to the rndpos access. In InnoDB the
    rndpos access uses the primary key.
    Currently usage of a rowid filter within InnoDB engine is not supported
    if the table is accessed by the primary key.
    
    Do not use pushed rowid filter if the table is accessed actually by the
    primary key. Use the rowid filter outside the egine code instead.
    4de32015
multi_range_read.cc 63.6 KB