Re: [HACKERS] latest snapshot crashes backend - Mailing list pgsql-hackers

> The attached commands crash the backend, which exits with status 11.

tgl=> select * from x where not (i is null or c is null);
i|c
-+-
1|T
2|A
0|T
(3 rows)

tgl=> select * from x where not (i is null and c is null);
pqReadData() -- backend closed the channel unexpectedly.

So, let's try rewriting it as a workaround:

tgl=> select * from x where (not i is null) or (not c is null);
pqReadData() -- backend closed the channel unexpectedly.

Oops. For some reason the NOT/AND is fatal, while NOT/OR is OK. That's
not so good. The good news is that it will certainly be repairable with
patches.
                   - Tom