On Tue, Sep 9, 2008 at 3:28 PM, David Jaquay <djaquay@gmail.com> wrote:
>
> Description: LEFT JOIN not working as expected
> Details:
>
> I'm seeing a problem with a LEFT JOIN. 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 doesn't match, and should yield no output.
>
> What happens is that the planner appears to apply the WHERE clause early,
> the left table doesn't yield any rows, and the row from the right table is
> output by itself. This only appears to happen when both sides of the OR =
are
> present, and the idx_beta_datereceived index is present. Remove any one,
> and it works like I expect.
>
This has been reported and fixed already:
http://archives.postgresql.org/pgsql-bugs/2008-06/msg00175.php
if you can compile postgres from sources you can apply the fix Tom
shows. If not you have to wait for 8.3.4.
Is not time for a new minor release?
--=20
regards,
Jaime Casanova
Soporte y capacitaci=F3n de PostgreSQL
Asesor=EDa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. (593) 87171157
