Re: [HACKERS] BUG: NOT boolfield kills backend

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] BUG: NOT boolfield kills backend
Дата
Msg-id 199809222122.RAA03134@candle.pha.pa.us
обсуждение исходный текст
Ответ на BUG: NOT boolfield kills backend  (Zsolt Varga <redax@agria.hu>)
Список 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.        |

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] select not b from t1 -- electric fence
Следующее
От: Bruce Momjian
Дата:
Сообщение: funny comment