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

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)