With my optimizer switch settings and MariaDB 5.3.7:
Thread pointer: 0x02BD73F8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
004D1D02 mysqld.exe!select_describe()[sql_select.cc:21198]
004E6FBC mysqld.exe!JOIN::exec()[sql_select.cc:2240]
004E7EE2 mysqld.exe!mysql_select()[sql_select.cc:2954]
004E80A8 mysqld.exe!mysql_explain_union()[sql_select.cc:21671]
004D32A6 mysqld.exe!select_describe()[sql_select.cc:21628]
004E6FBC mysqld.exe!JOIN::exec()[sql_select.cc:2240]
004E7EE2 mysqld.exe!mysql_select()[sql_select.cc:2954]
004E80A8 mysqld.exe!mysql_explain_union()[sql_select.cc:21671]
004D32A6 mysqld.exe!select_describe()[sql_select.cc:21628]
004E6FBC mysqld.exe!JOIN::exec()[sql_select.cc:2240]
004E7EE2 mysqld.exe!mysql_select()[sql_select.cc:2954]
004E80A8 mysqld.exe!mysql_explain_union()[sql_select.cc:21671]
00422732 mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5130]
004252E1 mysqld.exe!mysql_execute_command()[sql_parse.cc:2284]
00429F35 mysqld.exe!mysql_parse()[sql_parse.cc:6156]
0042A844 mysqld.exe!dispatch_command()[sql_parse.cc:1230]
0042B40E mysqld.exe!do_command()[sql_parse.cc:927]
004536AC mysqld.exe!handle_one_connection()[sql_connect.cc:1218]
0076EBFD mysqld.exe!pthread_start()[my_winthread.c:90]
00741CB9 mysqld.exe!_callthreadstart()[thread.c:259]
00741D37 mysqld.exe!_threadstart()[thread.c:241]
75D8ED4C kernel32.dll!BaseThreadInitThunk()
777837E3 ntdll.dll!RtlInitializeExceptionChain()
777837B6 ntdll.dll!RtlInitializeExceptionChain()
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (02C2FE08): explain select 1 from `t1` where 1 like
( select 1 from t1 where 1 <=>
(select 1 from t1 group by `a1`)
)Connection ID (thread ID): 1
Status: NOT_KILLED
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=on,firstmatch=on,loosescan=on,materialization=off,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on
With my optimizer switch settings and MariaDB 5.3.7:
Thread pointer: 0x02BD73F8 exe!select_ describe( )[sql_select. cc:21198] exe!JOIN: :exec() [sql_select. cc:2240] exe!mysql_ select( )[sql_select. cc:2954] exe!mysql_ explain_ union() [sql_select. cc:21671] exe!select_ describe( )[sql_select. cc:21628] exe!JOIN: :exec() [sql_select. cc:2240] exe!mysql_ select( )[sql_select. cc:2954] exe!mysql_ explain_ union() [sql_select. cc:21671] exe!select_ describe( )[sql_select. cc:21628] exe!JOIN: :exec() [sql_select. cc:2240] exe!mysql_ select( )[sql_select. cc:2954] exe!mysql_ explain_ union() [sql_select. cc:21671] exe!execute_ sqlcom_ select( )[sql_parse. cc:5130] exe!mysql_ execute_ command( )[sql_parse. cc:2284] exe!mysql_ parse() [sql_parse. cc:6156] exe!dispatch_ command( )[sql_parse. cc:1230] exe!do_ command( )[sql_parse. cc:927] exe!handle_ one_connection( )[sql_connect. cc:1218] exe!pthread_ start() [my_winthread. c:90] exe!_callthread start() [thread. c:259] exe!_threadstar t()[thread. c:241] dll!BaseThreadI nitThunk( ) RtlInitializeEx ceptionChain( ) RtlInitializeEx ceptionChain( )
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
004D1D02 mysqld.
004E6FBC mysqld.
004E7EE2 mysqld.
004E80A8 mysqld.
004D32A6 mysqld.
004E6FBC mysqld.
004E7EE2 mysqld.
004E80A8 mysqld.
004D32A6 mysqld.
004E6FBC mysqld.
004E7EE2 mysqld.
004E80A8 mysqld.
00422732 mysqld.
004252E1 mysqld.
00429F35 mysqld.
0042A844 mysqld.
0042B40E mysqld.
004536AC mysqld.
0076EBFD mysqld.
00741CB9 mysqld.
00741D37 mysqld.
75D8ED4C kernel32.
777837E3 ntdll.dll!
777837B6 ntdll.dll!
Trying to get some variables. 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= on,firstmatch= on,loosescan= on,materializat ion=off, in_to_exists= on,semijoin= on,partial_ match_rowid_ merge=on, partial_ match_table_ scan=on, subquery_ cache=on, mrr=off, mrr_cost_ based=off, mrr_sort_ keys=off, outer_join_ with_cache= on,semijoin_ with_cache= on,join_ cache_increment al=on,join_ cache_hashed= on,join_ cache_bka= on,optimize_ join_buffer_ size=off, table_eliminati on=on
Some pointers may be invalid and cause the dump to abort.
Query (02C2FE08): explain select 1 from `t1` where 1 like
( select 1 from t1 where 1 <=>
(select 1 from t1 group by `a1`)
)Connection ID (thread ID): 1
Status: NOT_KILLED
Optimizer switch: index_merge=