• Monty's avatar
    MDEV-29677 Wrong result with join query and innodb fulltext search · aa5e7880
    Monty authored
    InnoDB FTS scan was used by a subquery. A subquery execution may start
    a table read and continue until it finds the first matching record
    combination. This can happen before the table read returns EOF.
    
    The next time the subquery is executed, it will start another table read.
    InnoDB FTS table read fails to re-initialize its data structures in this
    scenario and will try to continue the scan started at the first execution.
    
    Fixed by ha_innobase::ft_init() to stop the FTS scan if there is one.
    
    Author: Sergei Petrunia <sergey@mariadb.com>
    Reviewer: Monty
    aa5e7880
ha_innodb.cc 610 KB