Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
5.3.12, 5.5.34, 10.0.7
-
None
-
None
-
Centos 6 X64
Description
A SELECT statement with multiple WHERE clauses and ASC LIMIT returns all rows up to the limit, the WHERE clauses are ignored. Commenting out one or more of the WHERE clauses causes the query to return the correct results.
Query:
SELECT applications.id
FROM `applications`
WHERE (`applications`.`configuration_scope_id` = 2)
AND
(`applications`.`id` > 2023)
AND
('2013-10-26 23:00:00' <= applications.submitted_at) AND (applications.submitted_at <= '2013-11-23 23:59:59')
ORDER BY `applications`.`id`
ASC LIMIT 1000
See attached .zip which contains a .sql that can be used to create the table.
The problem only occurs when using the Percona-XtraDB, it does not occure when using INNODB.
Attachments
Issue Links
- relates to
-
MDEV-5337 Wrong result in mariadb 5.5.32 with ORDER BY + LIMIT when index_condition_pushdown=on
- Closed