Icon View Incident Report

Minor Minor
Reported By: Oliver Bock
Reported On: 10/14/2005
For: Version 4.21 Build 10
# 2114 SQL COALESCE Function Not Clearing Out Previous NULL Values from Other Rows

The SQL below should select 'asdasdasd' and null, but outputs 'asdasdasd' twice.

create table "\Memory\A"(s varchar(13));
insert into "\Memory\A" values('asdasdasd');
insert into "\Memory\A" values(null);
select coalesce(s, s) + '' from "\Memory\A";



Resolution Resolution
Fixed Problem on 10/24/2005 in version 4.21 build 11


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