Reported By: Suat Demirkiran Reported On: 1/11/2006 For: Version 4.22 Build 3
# 2155SQL 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
ResolutionFixed Problem on 1/13/2006 in version 4.22 build 4
Products AffectedDBISAM 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