Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.0.14, 10.0(EOL), 10.1(EOL)
-
None
-
Linux 64-bit
Description
Server hangs after select count(distinct name) from t2 where a=8366 and b>=5 and b<=5;
How to repeat:
create table t2 (a smallint(6) not null, b int(10) not null, name varchar(20), primary key(a,b), key(name)) engine=InnoDB; |
insert into t2 values (8355,3,"sanja"),(8355,4,"wlad"),(8366,5, "lawrin"),(8366,6,"markusjm"); |
select count(distinct name) from t2 where a=8366 and b>=5 and b<=5; |
I was able to reproduce it also on 10.1 and 10.2 (debug)