Skip to content
  • Aakanksha Verma's avatar
    c58c6f8f
    Bug #27155294 MAX_EXECUTION_TIME NOT INTERUPTED WITH FULLTEXT SEARCH · c58c6f8f
    Aakanksha Verma authored
    USING MECAB
    
    PROBLEM
    
    While running select with optimizer hint -> max_execution_time to return
    the count of rows using the column that is primary key,the query doesn't
    get interrupted after the max_execution_time is reached.
    Optimizer does some optimization to fetch count of rows without actually
    searchin of rows if the column in count expression can never be NULL .
    Since there is no trx interruption check inside fts optimize query the
    query isn't interrupted.
    
    FIX
    
    Add an interruption check in the long running fts_ast_visit function so
    that query gets interrupted as expected.
    
    Reviewed by: Jimmy Yang<Jimmy.Yang@oracle.com>
    RB: 19490
    c58c6f8f
    Bug #27155294 MAX_EXECUTION_TIME NOT INTERUPTED WITH FULLTEXT SEARCH
    Aakanksha Verma authored
    USING MECAB
    
    PROBLEM
    
    While running select with optimizer hint -> max_execution_time to return
    the count of rows using the column that is primary key,the query doesn't
    get interrupted after the max_execution_time is reached.
    Optimizer does some optimization to fetch count of rows without actually
    searchin of rows if the column in count expression can never be NULL .
    Since there is no trx interruption check inside fts optimize query the
    query isn't interrupted.
    
    FIX
    
    Add an interruption check in the long running fts_ast_visit function so
    that query gets interrupted as expected.
    
    Reviewed by: Jimmy Yang<Jimmy.Yang@oracle.com>
    RB: 19490
Loading