View Incident Report

Serious

Reported By: Ralph Cromarty
Reported On: 8/7/2019
For: Version 4.48 Build 5

# 4757 SELECT COUNT(*) Queries that Contain Sub-Queries in WHERE Clause Return Incorrect Result

Here is another unexpected result, from a select statement, that may interest you. Result is null instead of a zero.

select count(*) as company_cnt from asycouserm where username = 'vb'
    and companyname in (select companyname from asycouserm where username = 'qcuser')

Comments

The issue was due to an incorrect code path when the WHERE clause contained a sub-query.

Resolution

Fixed Problem on 8/8/2019 in version 4.48 build 6

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 ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap