Re: [HACKERS] BUG: NOT boolfield kills backend

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

From: Bruce Momjian <maillist@candle.pha.pa.us>
To: redax@agria.hu (Zsolt Varga)
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-09-22T21:21:11Z
Lists: pgsql-hackers
Fixed.

> 
> Hi, 
> I just found an error in every postgres versions, 
> (I tried 6.2.1, 6.3.2, and 6.4beta1 )
> 
> if I have a table with boolean field, and I want to negate that field,
> it's kills the backend process... meanwhile 'select not ( 'T'::bool )'
> works well...
> 
> create table t1 ( b bool );
> insert into t1 values ( 'T' );
> 
> select not b from t1;
> PQexec() -- Request was sent to backend, but backend closed the channel
> before responding.
>         This probably means the backend terminated abnormally before or
> while processing the request.
> 
> 	don't you have some idea what to do,?
> 	
> 	thanks, 
> 		Redax
> .----------------------------------------------------------.
> |Zsolt Varga            | tel/fax:   +36 36 422811         |
> | AgriaComputer LTD     | email:     redax@agria.hu        |
> | System Administrator  | URL:       http://www.agria.hu/  |
> `----------------------------------------------------------'
> 
> 
> 


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