OK, if this query leads to crash every time, can you, please, check if it still crashes when index merge is NOT used:
set session optimizer_switch='index_merge_intersection=off'; set session optimizer_switch='index_merge=off'; <run your query>;
OK, if this query leads to crash every time, can you, please, check if it still crashes when index merge is NOT used:
set session optimizer_ switch= 'index_ merge_intersect ion=off' ; switch= 'index_ merge=off' ;
set session optimizer_
<run your query>;