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@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026