Closed GoogleCodeExporter closed 9 years ago
Thanks a lot! This is a bug, it will be fixed in the next release.
I found a simpler test case:
drop table test;
create table test(id int, name varchar);
create index idx_name on test(id, name);
insert into test values(1, 'Hello'), (2, 'World');
select * from test where id between 1 and 3 and name in ('World');
select * from test where id between 1 and 3 and name in (select 'World');
explain select * from test where id between 1 and 3 and name in ('World');
explain select * from test where id between 1 and 3 and name in (select
'World');
Original comment by thomas.t...@gmail.com
on 17 Dec 2009 at 10:56
This problem should be fixed in version 1.2.126.
Original comment by thomas.t...@gmail.com
on 18 Dec 2009 at 9:19
Original issue reported on code.google.com by
youn...@gmail.com
on 17 Dec 2009 at 6:46Attachments: