Debian Codegraph @

mysql-test/suite/vcol/r/mrr.result

raw
1 CREATE TABLE t1 (
2 pk INT AUTO_INCREMENT PRIMARY KEY,
3 col_int_nokey INT NULL,
4 col_int_key INT AS (col_int_nokey) VIRTUAL,
5 KEY (col_int_key)
6 );
7 INSERT INTO t1 (col_int_nokey)
8 VALUES (0), (5), (4), (3), (7), (42), (5), (0), (3);
9 SELECT * FROM t1 WHERE col_int_key IN (3, 4) AND col_int_key <= 83 ORDER BY 1;
10 pk col_int_nokey col_int_key
11 3 4 4
12 4 3 3
13 9 3 3
14 set optimizer_switch='index_condition_pushdown=off';
15 SELECT * FROM t1 WHERE col_int_key IN (3, 4) ORDER BY 1;
16 pk col_int_nokey col_int_key
17 3 4 4
18 4 3 3
19 9 3 3
20 SELECT * FROM t1 WHERE col_int_key IN (3, 4) AND col_int_key <= 83 ORDER BY 1;
21 pk col_int_nokey col_int_key
22 3 4 4
23 4 3 3
24 9 3 3
25 DROP TABLE t1;