1set @subselect_extra_no_sj_tmp=@@optimizer_switch; 2 3set @optimizer_switch_for_subselect_extra_test='semijoin=off,firstmatch=off,loosescan=off,semijoin_with_cache=off'; 4 5--source subselect_extra.test 6 7set optimizer_switch= @subselect_extra_no_sj_tmp; 8 9set @optimizer_switch_for_subselect_extra_test=null; 10 11--echo # 12--echo # MDEV-6439: Server crashes in Explain_union::print_explain with explain in slow log, tis620 charset 13--echo # 14 15## Using a separate client connection is easier than restoring state 16connect(con1,localhost,root,,); 17 18SET NAMES tis620; 19set @tmp= @@global.slow_query_log; 20SET GLOBAL slow_query_log = 1; 21SET long_query_time = 0.000001; 22SET log_slow_verbosity = 'explain'; 23 24CREATE TABLE t1 (a VARCHAR(3)) ENGINE=MyISAM; 25SELECT * FROM t1 WHERE a >= ANY ( SELECT 'foo'); 26--error ER_CANT_AGGREGATE_2COLLATIONS 27SELECT * FROM t1 WHERE a >= ANY ( SELECT 'foo' UNION SELECT 'bar' ); 28 29create table t2 (b int); 30insert into t2 values (1),(2),(3); 31 32--error ER_CANT_AGGREGATE_2COLLATIONS 33SELECT * FROM t1 WHERE a >= ANY ( SELECT 'foo' FROM t2); 34 35drop table t1,t2; 36SET GLOBAL slow_query_log=@tmp; 37disconnect con1; 38connection default; 39