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"
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
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