mirror of
https://github.com/MariaDB/server.git
synced 2025-10-15 04:02:12 +02:00
73e1e6d28f
Follow-up patch with adjustments of test files and updates of result files for tests. Part 3
29 lines
820 B
Text
29 lines
820 B
Text
-- source include/have_query_cache.inc
|
|
|
|
--echo #
|
|
--echo # MDEV-4520: Assertion `0' fails in Query_cache::end_of_result on
|
|
--echo # concurrent drop event and event execution
|
|
--echo #
|
|
set @save_query_cache_size=@@query_cache_size;
|
|
set GLOBAL query_cache_size=1355776;
|
|
|
|
create user mysqltest1@localhost;
|
|
grant SELECT on test.* to mysqltest1@localhost;
|
|
|
|
create table t1 (a int);
|
|
|
|
connect (con1,localhost,mysqltest1,,);
|
|
connection con1;
|
|
--echo # This explain put here to be sure that init connection query
|
|
--echo # has 'Impossible WHERE'.
|
|
explain extended select * from test.t1 where 0;
|
|
connection default;
|
|
disconnect con1;
|
|
revoke all privileges, grant option from mysqltest1@localhost;
|
|
--disable_warnings
|
|
drop user mysqltest1@localhost;
|
|
--enable_warnings
|
|
|
|
drop table t1;
|
|
|
|
set GLOBAL query_cache_size=@save_query_cache_size;
|