Re: [HACKERS] Backend crash in opr_sanity regression test.

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