1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1 (c1 VARCHAR(255), c2 VARCHAR(255), c3 INT);
3
INSERT INTO t1 VALUES (REPEAT('x', 255), REPEAT('y', 255), 1);
4
INSERT INTO t1 VALUES (REPEAT('x', 255), REPEAT('y', 255), 2);
5
INSERT INTO t1 VALUES (REPEAT('x', 255), REPEAT('y', 255), 3);
6
SELECT COUNT(*) FROM t1;
9
drop table if exists t1;
10
create table t1 (a int, unique index indexa (a));
11
insert into t1 values (-1), (-4), (-2), (NULL);
12
select -10 IN (select a from t1 FORCE INDEX (indexa));
13
-10 IN (select a from t1 FORCE INDEX (indexa))