Re: Bug with "limit" clause

2002-11-05 Thread Steve Edberg
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

Bug with "limit" clause

2002-11-04 Thread Dirk Hillbrecht
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