We've very recently updated MySQL to version 5.6 from 5.1 (and previously 5.0) and at the same time changed from MyISAM to InnoDB. Although the majority of our application is working without issue, we're seeing some very strange results. The following example query returns zero rows:
SELECT * FROM product_data WHERE product_cond='N' AND product_live='M'
Removing either part of the WHERE clause returns results as expected, however there are 1000's of rows that match the full criteria.
Has anyone seen this behaviour before or any idea why we're seeing this?