Bug #633: CASE statement evaluation does not short-circut

James Cole (colejatmsu.edu) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
CASE statement evaluation does not short-circut

Long Description
In 7.2.1, Both the WHEN and THEN clauses of a CASE statement are evaluated, even if the WHEN clause evaluates to
FALSE.

(I'm not sure if this behavior is allowed by the '92 spec, but  it's different than under 7.1.x)

Platform info:
joel2=# select version();
                             version                              
------------------------------------------------------------------
 PostgreSQL 7.2.1 on sparc-sun-solaris2.6, compiled by GCC 2.95.2
(1 row)


Sample Code
joel2=# 
SELECT
    CASE
        WHEN 1 = 2 THEN 1 / 0
        WHEN 1 = 1 THEN 1.0
    END;
ERROR:  floating point exception! The last floating point operation either exceeded legal ranges or was a divide by
zero


No file was uploaded with this report