Re: [GENERAL] LEFT JOIN issue

2008-09-09 Thread David Jaquay
Just got an email saying that this has been fixed in 8.3.4, so I suppose I'll watch and wait for that. Thanks for looking, Alan (and anyone else who was watching this...) Dave On Tue, Sep 9, 2008 at 4:57 PM, Alan Hodgson <[EMAIL PROTECTED]> wrote: > On Tuesday 09 September 2008, "David Jaquay"

Re: [GENERAL] LEFT JOIN issue

2008-09-09 Thread Alan Hodgson
On Tuesday 09 September 2008, "David Jaquay" <[EMAIL PROTECTED]> wrote: > I'm seeing a problem with a LEFT JOIN in 8.3.3, running on what I > believe to be an Ubuntu Heron server. The sql below demonstrates the > issue. explain doesn't execute the query. Show the output of the actual select - it

[GENERAL] LEFT JOIN issue

2008-09-09 Thread David Jaquay
I'm seeing a problem with a LEFT JOIN in 8.3.3, running on what I believe to be an Ubuntu Heron server. The sql below demonstrates the issue. What I expect to see is no rows in the output, i.e. the LEFT JOIN should pair the two rows together, and the WHERE clause should decide that the joined row