Kbase P5220: SQL92 CASE Function Evaluates All Conditions
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/02/2009 |
|
Status: Verified
SYMPTOM(s):
SELECT statement uses the CASE function
Division by zero attempted (7509)
searched_case(ICOL0,1,1/ICOL)
-----------------------------
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20236
[JDBC Progress Driver]:Division by zero attempted (7509)
FACT(s) (Environment):
Progress 9.1D
CAUSE:
Bug# 20020724-019
CAUSE:
Bug# OE00080123
CAUSE:
The CASE function is incorrectly evaluating all parts of the CASE function when it should stop after the first successful evaluation.
FIX:
Upgrade to 9.1D02 or later