> 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