Re: [HACKERS] left join bug?

[Tom Lane]

Max Khon <[EMAIL PROTECTED]> writes:
> test=# select a.id, b.id from a left join b using(id);
>  id | id 
> ----+----
>  43 |   
>  45 |   
> (2 rows)

> test=# select * from a;
>  id 
> ----
>  45
>  43
>  34
> (3 rows)

Ugh.  It looks like mergejoin must be mishandling the first left-side
item when the right side is empty.  Will take a look...

                        regards, tom lane