← Back to branch summary

~thomir-deactivatedaccount/drizzle/drizzle-fix-bug653747 

1
2
3
4
5

create table t1 (a int primary key, b int unique);
insert into t1 values (1,100),(2,99),(3,98),(4,97),(5,96);
EXPLAIN SELECT * FROM t1 FORCE INDEX (b) ORDER BY b;
SELECT * FROM t1 FORCE INDEX (b) ORDER BY b;
DROP TABLE t1;