pgsql: Improve the tests to see if ScalarArrayOpExpr is strict.

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve the tests to see if ScalarArrayOpExpr is strict.
Date: 2006-02-06 22:21:12
Message-ID: 20060206222112.497809DC97A@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Improve the tests to see if ScalarArrayOpExpr is strict. Original coding
would basically punt in all cases for 'foo <> ALL (array)', which resulted
in a performance regression for NOT IN compared to what we were doing in
8.1 and before. Per report from Pavel Stehule.

Modified Files:
--------------
pgsql/src/backend/optimizer/util:
clauses.c (r1.207 -> r1.208)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/clauses.c.diff?r1=1.207&r2=1.208)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2006-02-07 00:26:15 pgsql: Fix HTML alignment in PQprint.
Previous Message Teodor Sigaev 2006-02-06 15:45:34 pgsql: Check number of affixes to prevent core dump with zero number of