• Sergey Petrunya's avatar
    BUG#962667: Assertion `0' failed in QUICK_INDEX_SORT_SELECT::need_sorted_output() · d0547098
    Sergey Petrunya authored
    - The problem was that
      = we've picked a LooseScan that used full index scan (tab->type==JT_ALL) on certain index.
      = there was also a quick select (tab->quick!=NULL), that used other indexes.
      = some old code assumes that (tab->type==JT_ALL && tab->quick) -> means that the
        quick select should be used, which is not true.
    Fixed by discarding the quick select as soon as we know we're using LooseScan
    without using the quick select.
    d0547098
subselect_sj2_jcl6.result 33.7 KB