1CREATE TABLE t1 ( 2pk INT AUTO_INCREMENT PRIMARY KEY, 3col_int_nokey INT NULL, 4col_int_key INT AS (col_int_nokey) VIRTUAL, 5KEY (col_int_key) 6); 7INSERT INTO t1 (col_int_nokey) 8VALUES (0), (5), (4), (3), (7), (42), (5), (0), (3); 9SELECT * FROM t1 WHERE col_int_key IN (3, 4) AND col_int_key <= 83 ORDER BY 1; 10pk col_int_nokey col_int_key 113 4 4 124 3 3 139 3 3 14set optimizer_switch='index_condition_pushdown=off'; 15SELECT * FROM t1 WHERE col_int_key IN (3, 4) ORDER BY 1; 16pk col_int_nokey col_int_key 173 4 4 184 3 3 199 3 3 20SELECT * FROM t1 WHERE col_int_key IN (3, 4) AND col_int_key <= 83 ORDER BY 1; 21pk col_int_nokey col_int_key 223 4 4 234 3 3 249 3 3 25DROP TABLE t1; 26