List:General Discussion« Previous MessageNext Message »
From:Russ Lavoie Date:December 27 2013 6:00pm
Subject:MySQL Descending ORDER issue
View as plain text  
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?
MySQL Descending ORDER issueRuss Lavoie27 Dec
  • Re: MySQL Descending ORDER issueDan Nelson27 Dec
RE: MySQL Descending ORDER issueVikas Shukla27 Dec
  • RE: MySQL Descending ORDER issueRuss Lavoie27 Dec