• Georgi Kodinov's avatar
    Bug #47930: MATCH IN BOOLEAN MODE returns too many results · 49a7e818
    Georgi Kodinov authored
      inside subquery
    
    Re-setting a fulltext index was a no-operation if not all
    the matches of a search were consumed by reading them.
    This was preventing a joined table using a fulltext index
    in a subquery that requires only 1 row of output (e.g. EXISTS) 
    from working correctly because the second execution of the 
    sub-query has the fulltext index cursor in a wrong state and
    was not finding results.
    Fixed by making the re-init code _ftb_init_index_search() 
    to re-set open cursors in addition to depleted ones.
    49a7e818
ft_boolean_search.c 30.7 KB