Bug #57453 Index error when order by key
Submitted: 14 Oct 2010 13:01 Modified: 14 Nov 2010 13:18
Reporter: fernando diaz toledano Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:6.0.5-alpha-community OS:Windows
Assigned to: CPU Architecture:Any
Tags: INDEX ERROR QUERY PRIMARY

[14 Oct 2010 13:01] fernando diaz toledano
Description:
'version', '6.0.5-alpha-community'

When a query searching for something indexed and sorted by index key, the index filter does not do

 SELECT COD_ARTICULO,DESC_ARTICULO,COD_BARRAS,LENGTH(COD_BARRAS)
 FROM  GEM_999_2010.ARTICULOS  WHERE
    COD_BARRAS <> ''  ORDER BY COD_ARTICULO  ASC

IF INDEX IN COD_BARRAS -> QUERY FAIL (2200 reg. is shown)
IF NO INDEX O NO ORDER IN QUERY -> QUERY OK (60 reg. is shown)

Video (how do it):
http://62.43.206.251:8080/mysql_error/index.htm

How to repeat:
http://62.43.206.251:8080/mysql_error/index.htm
[14 Oct 2010 13:18] MySQL Verification Team
Thank you for the bug report. 6.0.5-alpha-community isn't more supported, please try current server i.e: 5.1.XX. Thanks in advance.
[15 Nov 2010 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".