Icon View Incident Report

Serious Serious
Reported By: Suat Demirkiran
Reported On: 1/11/2006
For: Version 4.22 Build 3
# 2155 SQL MIN() and MAX() Aggregate Functions Not Handling NULLs Properly with Single-Row Results

NULL values are considered in MAX/MIN function in all SQL (also DBISAM).

You can try the following - it returns NULL when there are values that are not NULL in the table.

select min(LAST_BROADCAST_DT) from SONGS_LBDTS



Resolution Resolution
Fixed Problem on 1/13/2006 in version 4.22 build 4


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