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.
WHERE (`applications`.`configuration_scope_id` = 2)
(`applications`.`id` > 2023)
('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.