Re: BUG #7612: Wrong result with join between two values () set

On 10/19/12, Vik Reykja <vikreykja(at)gmail(dot)com> wrote:
> On Thu, Oct 18, 2012 at 5:40 PM, <maxim(dot)boguk(at)gmail(dot)com> wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 7612
>> Logged by: Maxim Boguk
>> Email address: maxim(dot)boguk(at)gmail(dot)com
>> PostgreSQL version: 9.2.1
>> Operating system: Linux
>> Description:
>>
>> Join between two values() set could produce wrong results:
>>
>
> This is not a bug; your test case produces correct results.
>
> Your VALUES clauses are producing one row with two columns each called
> "val" and "column2". You are joining on val and so when you switch the
> values to put 2 in different columns, no results are found.
>
> Is it possible you didn't intend to put the parentheses immediately
> following the VALUES keyword? I think that is the case because your
> parentheses around the numbers are superfluous.

Oops sorry for noise.
I should be more careful.