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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
