Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Improve the tests to see if ScalarArrayOpExpr is strict. - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Improve the tests to see if ScalarArrayOpExpr is strict.
Date
Msg-id 20060206222112.497809DC97A@postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
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)

pgsql-committers by date:

Previous
From: teodor@postgresql.org (Teodor Sigaev)
Date:
Subject: pgsql: Check number of affixes to prevent core dump with zero number of
Next
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Fix HTML alignment in PQprint.