I'm running into a strange issue with MySQL regarding the "Limit" clause. I have a table with 25 records. In my select statement I grab 5 at a time. I am ordering my results by a decimal field, desc. I have had this working for a week now without a problem - until today.
Here is the problem. When I display the records in the table (5 at a time) one record displays the field values incorrectly. In fact, it isn't even the right record. It is a duplicate of one of the other 24 records. I still get 25 results returned over 5 pages, but one record of good data is missing, and it is replaced with another record from the table.
I did a little testing and here is what I found. The missing record was one of 5 records having the same value that I sorted on. If I changed the value of that record to something else, the record appears correctly. If I sort on another column the record appears corrrectly. Of course, I checked and the right data is in the source table.
This query is very basic. SELECT * FROM ... ORDER BY ... DESC LIMIT param1, param2.
Is this a confirmed bug? Anyone know?
Thanks
