Hi Russ, Please share with us the exact details of the table data as well as the o/p.
Regards, ViXiD Vikas Shukla Mail Sent from my Windows Phone From: Russ Lavoie Sent: 27-12-2013 23:32 To: mysql@lists.mysql.com Subject: MySQL Descending ORDER issue Hello, I am currently upgrading from mysql 5.1.72 -> mysql 5.6 and the migration and upgrade is sound (In a QA ENV). Queries work etc. However, when I run a query similar to "SELECT `table`.* FROM `table` WHERE (some_id IN (13528, 14906, 38845)) ORDER BY `date` DESC LIMIT 1;" on 5.1.72 and on 5.6.15 I get back different data. The date for all of the data are exactly the same to the second. However, if I run "SELECT `table`.* FROM `table` WHERE (some_id IN (13528, 14906, 38845)) ORDER BY `date` LIMIT 1;" it comes back with the exact same data that is expected. Is this a bug? Or am I missing here? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
