List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:May 20 2000 3:44pm
Subject:Re: "Limit" missing records under MySQL 3.22.32?
View as plain text  
In the last episode (May 20), Axel Rauschmayer said:
> If I do a follow-up query
> 
>      SELECT item_id FROM book_catalog WHERE changed > 315529200000 limit \
>      4000,4000
> 
> the missing records still do not appear (this table has a total of 5377
> records). Even worse, the first LIMIT query ends with:
> 
> 4001
> 4002
> 4003
> 4004
> 
> The second LIMIT query starts with:
> 
> 4001
> 4002
> 4003
> 4004

Again, what are the reults of an EXPLAIN on the two queries, and what
happens if you put an ORDER BY clause on them both?  Mysql is free to
optimize both queries differently, and happens to return the records in
different order for your two queries.

-- 
	Dan Nelson
	dnelson@stripped
Thread
"Limit" missing records under MySQL 3.22.32?Axel Rauschmayer20 May
  • Re: "Limit" missing records under MySQL 3.22.32?Dan Nelson20 May
    • Re: "Limit" missing records under MySQL 3.22.32?Axel Rauschmayer20 May
      • Re: "Limit" missing records under MySQL 3.22.32?Dan Nelson20 May