Re: [HACKERS] It would be nice if this could be fixed... - Mailing list pgsql-hackers

Works now, thanks to Tom Lane:

test=> create table aaa(a text);CREATEtest=> create table bbb(b text);CREATEtest=> select coalesce(a,b) from
aaa,bbb;case----(0rows)test=> insert into aaa values('aaa');INSERT 19090 1test=> insert into bbb values('bbb');INSERT
190911test=> 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@tech.com.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@candle.pha.pa.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@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026