• Igor Babaev's avatar
    MDEV-16917 Index affects query results · c5a9a632
    Igor Babaev authored
    The optimizer erroneously allowed to use join cache when joining a
    splittable materialized table together with splitting optimization.
    As a consequence in some rare cases the server returned wrong result
    sets for queries with materialized derived.
    
    This patch allows to use either join cache without usage of splitting
    technique for materialization of a splittable derived table or splitting
    without usage of join cache when joining such table. The costs the these
    alternatives are compared and the best variant is chosen.
    c5a9a632
opt_split.cc 39.3 KB