Re: [HACKERS] It would be nice if this could be fixed...

Works now, thanks to Tom Lane:

test=> create table aaa(a text);
CREATE
test=> create table bbb(b text);
CREATE
test=> select coalesce(a,b) from aaa,bbb;
case
----
(0 rows)

test=> insert into aaa values('aaa');
INSERT 19090 1
test=> insert into bbb values('bbb');
INSERT 19091 1
test=> select coalesce(a,b) from aaa,bbb;
case
----
aaa
(1 row)

> Bruce Momjian wrote:
> >
> > Chris, any chance you can send a small reproducable test case for this,
> > with INSERT's and CREATE table. Thanks.
>
> Sure. Here it is....
>
>
> httpd=> create table aaa(a text);
> CREATE
> httpd=> create table bbb(b text);
> CREATE
> httpd=> select coalesce(a,b) from aaa,bbb;
> case
> ----
> (0 rows)
>
> httpd=> insert into aaa values('aaa');
> INSERT 84818 1
> httpd=> insert into bbb values('bbb');
> INSERT 84819 1
> httpd=> select coalesce(a,b) from aaa,bbb;
> pqReadData() -- backend closed the channel unexpectedly.
> This probably means the backend terminated abnormally
> before or while processing the request.
> We have lost the connection to the backend, so further processing is
> impossible. Terminating.
>
>
>
>
>
> > > =================================================================
> > > POSTGRESQL BUG REPORT TEMPLATE
> > > =================================================================
> > >
> > >
> > > Your name : Chris Bitmead
> > > Your email address : chris(at)tech(dot)com(dot)au
> > >
> > >
> > > System Configuration
> > > ---------------------
> > > Architecture : Intel x86
> > >
> > > Operating System : Linux 2.0.36
> > >
> > > PostgreSQL version : Latest Snapshot as at May 2, 1999
> > >
> > > Compiler used : gcc 2.7.2.3
> > >
> > >
> > > Please enter a FULL description of your problem:
> > > ------------------------------------------------
> > >
> > > COALESCE sql function causes postgres to CRASH!
> > >
> > > e.g.
> > >
> > > SELECT story.title,story.image, mfr.image FROM story, mfr where
> > > story.category= mfr.oid;
> > > title |image |image
> > > --------------+------------------+--------------------
> > > Canon |/icon/critique.jpg|/icon/canon.gif
> > > Nikon | |/icon/nikon.gif
> > > Olympus | |/icon/olympus.gif
> > > New Arca | |/icon/arca-swiss.gif
> > > New Hasselblad| |/icon/hasselblad.gif
> > > (5 rows)
> > >
> > > httpd=> SELECT story.title, COALESCE(story.image, mfr.image) FROM story,
> > > mfr where story.category= mfr.oid;
> > > pqReadData() -- backend closed the channel unexpectedly.
> > > This probably means the backend terminated abnormally
> > > before or while processing the request.
> > > We have lost the connection to the backend, so further processing is
> > > impossible. Terminating.
> > >
> > >
> >
> > --
> > Bruce Momjian | http://www.op.net/~candle
> > maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> > + If your life is a hard drive, | 830 Blythe Avenue
> > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026