re: RE: LEFT JOIN selects with ORDER BY and WHERE and LIMIT missing results

Kevin, Tuesday, November 05, 2002, 12:55:41 PM, you wrote: KD> I've shrunk the dataset down as far as I can to continue to reproduce this KD> issue, but the .gz file is still 1.3MB KD> Running this on 4.0.3 produces the correct results. 4.0.4 doesn't. KD> fetch http://www.dragondata.com/ditsy.gz

RE: LEFT JOIN selects with ORDER BY and WHERE and LIMIT missing results

I've shrunk the dataset down as far as I can to continue to reproduce this issue, but the .gz file is still 1.3MB Running this on 4.0.3 produces the correct results. 4.0.4 doesn't. fetch http://www.dragondata.com/ditsy.gz bash-2.05b# mysql test < ditsy bash-2.05b# mysql test mysql> SELECT COUN

re: LEFT JOIN selects with ORDER BY and WHERE and LIMIT missing results

toasty, Sunday, October 27, 2002, 11:17:53 PM, you wrote: taddc> Under some pretty specific conditions, adding a "LIMIT" clause to a query taddc> will cause incorrect results. taddc> How-To-Repeat: taddc> This bug is NOT present in 4.0.3. taddc> CREATE TABLE `history` ( taddc> `id_pic` int(11