> 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