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