• Sergei Petrunia's avatar
    MDEV-21628: Index condition pushdown condition ... not used with BKA · affe7fab
    Sergei Petrunia authored
    (Backport to 10.3)
    Partitioning storage now supports MRR but doesn't support Index Condition
    Pushdown (aka ICP). This causes counter-intuitive query plans for queries
    that use BKA and conditions that depend on index fields:
    - If the condition refers to other tables, BKA's variant of ICP is used
       to handle it.
    - If the condition depends on this table only, the optimizer will try to
      use regular ICP for it, which will fail because the storage engine
      doesn't support ICP.
    
    Make the optimizer be smarter in the second case: if we were not able to
    use regular ICP, use BKA's variant of ICP..
    affe7fab
partition_mrr_myisam.result 4.47 KB