EVOLUTION-MANAGER

Edit File: cache_index.rdiff

--- /data/src/bb-10.2-mdev12528/mysql-test/suite/storage_engine/cache_index.result 2017-06-22 00:33:46.419995639 +0300 +++ /data/src/bb-10.2-mdev12528/mysql-test/suite/storage_engine/cache_index.reject 2017-06-22 01:11:22.479981459 +0300 @@ -12,31 +12,31 @@ SET GLOBAL <CACHE_NAME>.key_buffer_size=128*1024; CACHE INDEX t1 INDEX (a), t2 IN <CACHE_NAME>; Table Op Msg_type Msg_text -test.t1 assign_to_keycache status OK -test.t2 assign_to_keycache status OK +test.t1 assign_to_keycache note The storage engine for the table doesn't support assign_to_keycache +test.t2 assign_to_keycache note The storage engine for the table doesn't support assign_to_keycache LOAD INDEX INTO CACHE t1, t2; Table Op Msg_type Msg_text -test.t1 preload_keys status OK -test.t2 preload_keys status OK +test.t1 preload_keys note The storage engine for the table doesn't support preload_keys +test.t2 preload_keys note The storage engine for the table doesn't support preload_keys INSERT INTO t1 (a,b) VALUES (3,'c'),(4,'d'); SET GLOBAL <CACHE_NAME>.key_buffer_size=8*1024; LOAD INDEX INTO CACHE t1, t2 IGNORE LEAVES; Table Op Msg_type Msg_text -test.t1 preload_keys status OK -test.t2 preload_keys status OK +test.t1 preload_keys note The storage engine for the table doesn't support preload_keys +test.t2 preload_keys note The storage engine for the table doesn't support preload_keys SET GLOBAL <CACHE_NAME>.key_cache_age_threshold = 100, <CACHE_NAME>.key_cache_block_size = 512, <CACHE_NAME>.key_cache_division_limit = 1, <CACHE_NAME>.key_cache_segments=2; INSERT INTO t1 (a,b) VALUES (5,'e'),(6,'f'); LOAD INDEX INTO CACHE t1; Table Op Msg_type Msg_text -test.t1 preload_keys status OK +test.t1 preload_keys note The storage engine for the table doesn't support preload_keys SET GLOBAL new_<CACHE_NAME>.key_buffer_size=128*1024; CACHE INDEX t1 IN new_<CACHE_NAME>; Table Op Msg_type Msg_text -test.t1 assign_to_keycache status OK +test.t1 assign_to_keycache note The storage engine for the table doesn't support assign_to_keycache INSERT INTO t1 (a,b) VALUES (7,'g'),(8,'h'); LOAD INDEX INTO CACHE t1 IGNORE LEAVES; Table Op Msg_type Msg_text -test.t1 preload_keys status OK +test.t1 preload_keys note The storage engine for the table doesn't support preload_keys INSERT INTO t1 (a,b) VALUES (9,'i'); DROP TABLE t2; DROP TABLE t1; @@ -47,11 +47,11 @@ ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; CACHE INDEX t1 IN <CACHE_NAME>; Table Op Msg_type Msg_text -test.t1 assign_to_keycache status OK +test.t1 assign_to_keycache note The storage engine for the table doesn't support assign_to_keycache INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'); LOAD INDEX INTO CACHE t1; Table Op Msg_type Msg_text -test.t1 preload_keys status OK +test.t1 preload_keys note The storage engine for the table doesn't support preload_keys DROP TABLE t1; CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>, @@ -59,11 +59,11 @@ ) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; CACHE INDEX t1 IN <CACHE_NAME>; Table Op Msg_type Msg_text -test.t1 assign_to_keycache status OK +test.t1 assign_to_keycache note The storage engine for the table doesn't support assign_to_keycache INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'); LOAD INDEX INTO CACHE t1; Table Op Msg_type Msg_text -test.t1 preload_keys status OK +test.t1 preload_keys note The storage engine for the table doesn't support preload_keys DROP TABLE t1; SET GLOBAL <CACHE_NAME>.key_buffer_size=0; SET GLOBAL new_<CACHE_NAME>.key_buffer_size=0;