• Sergey Petrunya's avatar
    BUG#920713: Wrong result (missing rows) with firstmatch+BNL, IN subquery, ... · 424f56b3
    Sergey Petrunya authored
    - Disable use of join cache when we're using FirstMatch strategy, and the join
      order is such that subquery's inner tables are interleaved with outer.  Join 
      buffering code is incapable of handling such join orders.
    
    - The testcase requires use of @@debug_optimizer_prefer_join_prefix to hit the bug, 
      but I'm pushing it anyway (including the mention of the variable in .test file), 
      so that it can be found and enabled when/if we get something comparable in the 
      main tree.
    424f56b3
subselect_sj.test 63.6 KB