Re: [HACKERS] Backend crash in opr_sanity regression test. - Mailing list pgsql-hackers

> Hi Hackers,
> 
> With the following query from the opr_sanity regression test I'm
> getting a backend crash.
> 
> SELECT p1.oid, p1.oprcode, p2.oid, p2.oprcode
> FROM pg_operator AS p1, pg_operator AS p2
> WHERE p1.oprlsortop = p2.oid AND
>     (p1.oprname != '=' OR
>      p1.oprkind != 'b' OR p2.oprkind != 'b' OR
>      p1.oprleft != p2.oprleft OR
>      p1.oprright != p2.oprright OR
>      p1.oprresult != 16 OR
>      p2.oprresult != 16 OR
>      p1.oprrsortop = 0);

I tried the query in the current development tree, and it returned zero
rows and did not crash.

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