Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.3.34
-
None
-
Debian 10
Description
Keylookup with Bitmask is slower than it could be
Create a big Table with normal key on tinyint column status
select * from table where status &7 = 2
takes much much longer than
select * from table where status IN (2, 18, 34, 50, 66, 82, ....etc )