Thank you! =)
Best Regards, Alex
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tuesday, August 09, 2011 11:53 AM
To: ai
Cc: Kevin Grittner; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #6154: wrong result with nested left-joins
I wrote:
> "Kevin
I wrote:
> "Kevin Grittner" writes:
>> "ai" wrote:
>>> Oops.. I just saw, that I send you "correct" (already with "workaround")
>>> sql-code instead of "wrong"...
>>> here is "wrong" (difference is in "SELECT sub3.key3, sub4.value2
>>> FROM" ):
>> OK, that is still happening, and looks wrong t
"Kevin Grittner" writes:
> "ai" wrote:
>> Oops.. I just saw, that I send you "correct" (already with
> "workaround")
>> sql-code instead of "wrong"...
>> here is "wrong" (difference is in "SELECT sub3.key3, sub4.value2
> FROM" ):
> OK, that is still happening, and looks wrong to me.
Yeah, I
Kevin and all others, thanks for your work!
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Tuesday, August 09, 2011 12:32 AM
To: ai; 'Tom Lane'
Cc: pgsql-bugs@postgresql.org
Subject: RE: [BUGS] BUG #6154: wrong result with nested left-
"ai" wrote:
> Oops.. I just saw, that I send you "correct" (already with
"workaround")
> sql-code instead of "wrong"...
> here is "wrong" (difference is in "SELECT sub3.key3, sub4.value2
FROM" ):
OK, that is still happening, and looks wrong to me. The outermost LEFT
JOIN is between this:
sub2 ON sub1.key1 = sub2.key3
А.И.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Monday, August 08, 2011 10:02 PM
To: Kevin Grittner
Cc: listar; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #6154: wrong result with nested left-joins
"Kevin Grittner" w
To: Kevin Grittner
Cc: listar; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #6154: wrong result with nested left-joins
"Kevin Grittner" writes:
> "listar" wrote:
>> PostgreSQL version: 8.4.5
>> Description:wrong result with nested left-joins
"Kevin Grittner" writes:
> "listar" wrote:
>> PostgreSQL version: 8.4.5
>> Description:wrong result with nested left-joins
>> And this is the problem - value2 can't be NULL because of COALESCE
>> in sub4 (at least I think that it can't be =))
> This works correctly in release 9.0.4 a
nt: Monday, August 08, 2011 8:52 PM
To: listar; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #6154: wrong result with nested left-joins
"listar" wrote:
> PostgreSQL version: 8.4.5
> Description:wrong result with nested left-joins
> And this is the problem - va
"listar" wrote:
> PostgreSQL version: 8.4.5
> Description:wrong result with nested left-joins
> And this is the problem - value2 can't be NULL because of COALESCE
> in sub4 (at least I think that it can't be =))
This works correctly in release 9.0.4 and development HEAD. I
don't st
The following bug has been logged online:
Bug reference: 6154
Logged by: listar
Email address: lis...@mail.ru
PostgreSQL version: 8.4.5
Operating system: Linux 2.6.36-gentoo-r5
Description:wrong result with nested left-joins
Details:
It's hard to explain, but easy t
11 matches
Mail list logo
