Reported By: Oliver Bock Reported On: 10/14/2005 For: Version 4.21 Build 10
# 2114SQL 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";
ResolutionFixed Problem on 10/24/2005 in version 4.21 build 11
Products AffectedDBISAM 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