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

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