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
