1-- source include/have_query_cache.inc
2
3--echo #
4--echo # MDEV-4520: Assertion `0' fails in Query_cache::end_of_result on
5--echo # concurrent drop event and event execution
6--echo #
7set @save_query_cache_size=@@query_cache_size;
8set GLOBAL query_cache_size=1355776;
9
10create user mysqltest1@localhost;
11grant SELECT on test.* to mysqltest1@localhost;
12
13create table t1 (a int);
14
15connect (con1,localhost,mysqltest1,,);
16connection con1;
17--echo # This explain put here to be sure that init connection query
18--echo # has 'Impossible WHERE'.
19explain extended select * from test.t1 where 0;
20connection default;
21disconnect con1;
22revoke all privileges, grant option from mysqltest1@localhost;
23drop user mysqltest1@localhost;
24
25drop table t1;
26
27set GLOBAL query_cache_size=@save_query_cache_size;
28