[EMAIL PROTECTED] writes:
> select
> *
> from
> test1 left join test2 on (test1.test1_id = test2.test1_id)
> where
> test1.test1_id = test2.test1_id;
> test1_id | test2_id | test1_id
> --+--+--
> 1 |1 |1
> 2 | |
This is fixed fo
[EMAIL PROTECTED] writes:
> select
> *
> from
> test1 left join test2 on (test1.test1_id = test2.test1_id)
> where
> test1.test1_id = test2.test1_id;
Hm. I think what is happening is that the planner is (mistakenly)
deciding that the where-clause and on-clause are equivalent, and
so dropping
karsten merkle ([EMAIL PROTECTED]) reports a bug with a severity of 1
The lower the number the more severe it is.
Short Description
null resulting from left join corrupts select
Long Description
Version:
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
Error:
equal in where clause fa
