Hi!
Over the past 2 years several users have complained about optimization of
queries of type
... WHERE col < x;
... WHERE col <= x;
... WHERE col > x;
... WHERE col >= x;
and, indeed, there was a major bug in the InnoDB query estimator. The fix
appears in 4.0.10 and 3.23.56.
"
MySQL/InnoDB-3.23.56, February xx, 2003
Fixed a major bug in InnoDB query optimization: queries of type SELECT ...
WHERE indexcolumn < x and SELECT ... WHERE indexcolumn > x could cause a
table scan even if the selectivity would have been very good.
"
Best regards,
Heikki
Innobase Oy
For mail filters:
How-to-Repeat:
sql query
1 message in com.mysql.lists.bugsMajor bug fixed in InnoDB optimizer i...