Re: [HACKERS] latest snapshot crashes backend

> > 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.
>

Care to give us a table:

select * from pg_shadow where (usesysid is null and oid is null)\g

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