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
"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
Kevin, thanks a lot for your answer! As my servers are production systems
and as I have an acceptable workaround for my needs, I will wait around with
a postgresql upgrade =)
I just tried to help with discovering of a potential bug =)) Anyway I'm very
glad to know, that in new version it's not an
"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
Jaime Casanova writes:
> On Sun, Aug 7, 2011 at 3:10 PM, John Carriel Gomez
> wrote:
>> Please help I can not replicate with Slony
>> ---
SELECT VERSION();
produces
"PostgreSQL 8.4.5 on x86_64-pc-linux-gnu, compiled by GCC
x86_64-pc-linux-gnu-gcc (Gentoo 4.4.4-r2 p1.3, pie-0.4.5) 4.4.4, 64-bit"
Best regards,
Alex
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Monday, August 08, 2011 10:02 PM
To: Kevin
Oops.. I just saw, that I send you "correct" (already with "workaround")
sql-code instead of "wrong"...
my mistake =(( don't kill me - I spend too much time with this piece of code
today...
But I'm sure that you got the point from my description of the results...
but just in case here is "wrong"
"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:
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-joins
"ai" wrot
"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
The following bug has been logged online:
Bug reference: 6155
Logged by: listar
Email address: lis...@mail.ru
PostgreSQL version: 8.4.5
Operating system: Gentoo 4.4.4-r2 p1.3, pie-0.4.5 64-bit
Description:literal definition of arrays with double qoutes leads to
error
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
"listar" writes:
> SELECT ('{string "with" double quotes}'::text[])[1] as value;
> gives:
> ERROR: malformed array literal: "{string "with" double quotes}"
> LINE 1: SELECT ('{string "with" double quotes}'::text[])[1] as value...
> ^
This is not a bug; that value does not follow
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 Grittner" w
Ok, thanks! I found out this issue a three years ago and then there isn't
such explanation... (all this time I've used some workaround) my mistake,
that I didn't look at the new manual before I reported this issue =(
My apologies for wasting your time =(
Best Regards, Alex
-Original Message
15 matches
Mail list logo
