• Sergey Petrunya's avatar
    BUG#962667: Assertion `0' failed in QUICK_INDEX_SORT_SELECT::need_sorted_output() · 85af7417
    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.
    85af7417
subselect_sj2.test 44.6 KB