List:General Discussion« Previous MessageNext Message »
From:Vikas Shukla Date:December 27 2013 6:27pm
Subject:RE: MySQL Descending ORDER issue
View as plain text  
Hi Russ,

Please share with us the exact details of the table data as well as the



Vikas Shukla
Mail Sent from my Windows Phone From: Russ Lavoie
Sent: 27-12-2013 23:32
To: mysql@stripped
Subject: MySQL Descending ORDER issue
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