Icon View Incident Report

Serious Serious
Reported By: Paul Lopez
Reported On: 7/6/2005
For: Version 4.21 Build 5
# 2084 SQL CASE Operator Causing Stack Overflow and Access Violations

When using a case with Min(), this crashes the server.

Error #11279 An Unknown Error ('Stack Overflow') occurred.

select field1, min(field2), case min(field2) when 1 then 
"This String" else "Other String" end
from aTable



Resolution Resolution
Fixed Problem on 7/25/2005 in version 4.21 build 7


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source

Image