Repeatable with both materialization and in_to_exists. Full optimizer_switch:
index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=off,derived_with_keys=off,firstmatch=off,loosescan=off,materialization=off,in_to_exists=on,semijoin=off,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=off,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on
Repeatable with both materialization and in_to_exists. Full optimizer_switch:
index_merge= on,index_ merge_union= on,index_ merge_sort_ union=on, index_merge_ intersection= on,index_ merge_sort_ intersection= off,index_ condition_ pushdown= on,derived_ merge=off, derived_ with_keys= off,firstmatch= off,loosescan= off,materializa tion=off, in_to_exists= on,semijoin= off,partial_ match_rowid_ merge=on, partial_ match_table_ scan=on, subquery_ cache=off, mrr=off, mrr_cost_ based=off, mrr_sort_ keys=off, join_cache_ incremental= on,join_ cache_hashed= on,join_ cache_bka= on,optimize_ join_buffer_ size=off, table_eliminati on=on