-
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
Aakanksha Verma authoredUSING 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