View Incident Report

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

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

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

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap