BUG: NOT boolfield kills backend

Поиск
Список
Период
Сортировка
От Zsolt Varga
Тема BUG: NOT boolfield kills backend
Дата
Msg-id Pine.LNX.3.96.980918123446.29674B-100000@lupus.agria.hu
обсуждение исходный текст
Ответы Re: [HACKERS] BUG: NOT boolfield kills backend  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
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/  |
`----------------------------------------------------------'


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

Предыдущее
От: Michael Meskes
Дата:
Сообщение: ecpg docs
Следующее
От: Sferacarta Software
Дата:
Сообщение: Re: [HACKERS] BUG: NOT boolfield kills backend