Elevate Software

Login Login

ProductsBulletSalesBulletSupportBulletDownloadsBulletAbout



Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 4.22 » View Incident Report

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 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

More Support Options More Support Options

Option Search Incident Reports
Option Support Forums
Option Frequently Asked Questions
Option Technical Bulletins
Option Technical Articles
Option Product Manuals
Option Roadmap


This web page was last updated on
Wednesday, March 20, 2024 at 07:22 AM

Privacy PolicyBulletSite Map

© 2024 Elevate Software, Inc. All Rights Reserved
Questions or comments ? E-mail E-mail us at info@elevatesoft.com

Image