239
239
CACHE INDEX t1 PARTITION (p0) KEY (`inx_b`) IN hot_cache;
240
240
CACHE INDEX t1 INDEX (`inx_b`) IN hot_cache;
241
241
DROP TABLE t1,t2;
244
--echo # Bug#12361113: crash when load index into cache
246
--echo # Note that this creates an empty disabled key cache!
247
SET GLOBAL key_cache_none.key_cache_block_size = 1024;
248
CREATE TABLE t1 (a INT, b INTEGER NOT NULL, KEY (b) )
250
PARTITION BY HASH(a) PARTITIONS 2;
251
INSERT INTO t1 VALUES (1, 1);
252
--error ER_UNKNOWN_KEY_CACHE
253
CACHE INDEX t1 IN key_cache_none;
254
--error ER_UNKNOWN_KEY_CACHE
255
CACHE INDEX t1 PARTITION (p0) IN key_cache_none;
256
--error ER_UNKNOWN_KEY_CACHE
257
CACHE INDEX t1 PARTITION (p1) IN key_cache_none;
258
--error ER_UNKNOWN_KEY_CACHE
259
CACHE INDEX t1 PARTITION (p0) KEY (`b`) IN key_cache_none;
260
--error ER_UNKNOWN_KEY_CACHE
261
CACHE INDEX t1 PARTITION (p1) KEY (`b`) IN key_cache_none;
262
--echo # The bug crashed the server at LOAD INDEX below. Now it will succeed
263
--echo # since the default cache is used due to CACHE INDEX failed for
264
--echo # key_cache_none.
265
LOAD INDEX INTO CACHE t1;
242
270
SET GLOBAL hot_cache.key_buffer_size = 0;
243
271
SET GLOBAL warm_cache.key_buffer_size = 0;
244
272
SET @@global.cold_cache.key_buffer_size = 0;