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!
Dec 27
Vikas Shukla RE: MySQL Descending ORDER issue
Dec 27, 2013; 10:27
Vikas Shukla
RE: MySQL Descending ORDER issue
Dec 27
Russ Lavoie RE: MySQL Descending ORDER issue
Dec 27, 2013; 10:47
Russ Lavoie
RE: MySQL Descending ORDER issue
Dec 27
Dan Nelson Re: MySQL Descending ORDER issue
Dec 27, 2013; 13:38
Dan Nelson
Re: MySQL Descending ORDER issue
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!