Re: [HACKERS] Backend crashes on select ... union

Bruce Momjian <maillist@candle.pha.pa.us>

From: Bruce Momjian <maillist@candle.pha.pa.us>
To: bus@fgan.de (Michael Bussmann)
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-03-07T21:16:29Z
Lists: pgsql-hackers
> 
> Hi there!
> 
> I played around with subselects and union and noticed that issuing strange
> statements can make the backend crash.  The problem is that other clients
> connected to the same db get disconnected as well.
> 
> I issued the following statement by mistake. (x1 is a table consisting only
> of one int4 value):
> select * from x1 union select * from pg_user;
> 

My fault.  I never went back to make sure all union columns have the same
types.  I will work on that.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)