View Incident Report

Serious

Reported By: Robert Kaplan
Reported On: 2/28/2001
For: Version 2.06 Build 1

# 728 Using a Column Name in SQL HAVING Clause When Column Is Aliased Causes AV

The following SQL generates an AV. If the column alias is used instead of the column name it works.

SELECT U_ID, SUM(DL_AMT) DOLLAMT, U_CURRBAL CURRBAL
FROM DOLLS, UNITS
WHERE (U_ID=DL_UNIT) 
GROUP BY U_ID
HAVING DOLLAMT < > U_CURRBAL

Resolution

Fixed Problem on 2/28/2001 in version 2.07 build 1

More Support Options