Not a bug or feature...
As you note, you aren't using an ORDER BY clause in these queries.
Thus, MySQL is free to return the rows in any order it sees fit.
Usually, they'll appear in the order they have been inserted, but
there's no guarantee, especially if there have been
insertions/deletions
Hello MySQL AB,
I want to inform you about a strange behaviour I just had with the MySQL
server. Probably it's a bug, probably I've not read the docs good
enough. Here it goes:
Situation: My application splits huge queries into a bunch of smaller
ones using the "limit" clause. One can doubt wh