DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a INT);

INSERT INTO t1 VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);

INSERT INTO t1 SELECT * FROM t1;

INSERT INTO t1 SELECT * FROM t1;

INSERT INTO t1 SELECT * FROM t1;

INSERT INTO t1 SELECT * FROM t1;

INSERT INTO t1 SELECT * FROM t1;

INSERT INTO t1 SELECT * FROM t1;

INSERT INTO t1 SELECT * FROM t1;

INSERT INTO t1 SELECT * FROM t1;

INSERT INTO t1 SELECT * FROM t1;

INSERT INTO t1 SELECT * FROM t1;

INSERT INTO t1 SELECT * FROM t1;

INSERT INTO t1 SELECT * FROM t1;

INSERT INTO t1 SELECT * FROM t1;

INSERT INTO t1 SELECT * FROM t1;

INSERT INTO t1 SELECT * FROM t1;

EXPLAIN SELECT * FROM t1 WHERE a IN (1,2,(SELECT MAX(a) FROM t1));

+------+-------------+-------+------+---------------+------+---------+------+--------+-------------+

| id   | select_type | table | type | possible_keys | key  | key_len | ref  | rows   | Extra       |

+------+-------------+-------+------+---------------+------+---------+------+--------+-------------+

|    1 | PRIMARY     | t1    | ALL  | NULL          | NULL | NULL    | NULL | 328184 | Using where |

|    2 | SUBQUERY    | t1    | ALL  | NULL          | NULL | NULL    | NULL | 328144 |             |

+------+-------------+-------+------+---------------+------+---------+------+--------+-------------+

2 rows in set (6.69 sec)