Debian Codegraph @

mysql-test/suite/innodb/t/bug33767814.test

raw
1 CREATE TABLE t_asc (
2 pk int, a int, b int,
3 primary key (pk), key (a), key (b)
4 ) ENGINE=InnoDB;
5
6 CREATE TABLE t_desc (
7 pk int, a int, b int,
8 primary key (pk DESC), key (a), key (b)
9 ) ENGINE=InnoDB;
10
11 INSERT INTO t_asc VALUES (27,3,0), (28,39,NULL), (29,NULL,255), (30,NULL,0);
12
13 INSERT INTO t_desc SELECT * FROM t_asc;
14
15 SELECT /*+ INDEX_MERGE(t_asc b, a) */ * FROM t_asc
16 WHERE b = 255 AND a IS NULL;
17 SELECT /*+ INDEX_MERGE(t_desc b, a) */ * FROM t_desc
18 WHERE b = 255 AND a IS NULL;
19
20 DROP TABLE t_asc;
21 DROP TABLE t_desc;