Debian Codegraph @

mysql-test/suite/innodb/r/bug33767814.result

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