View Incident Report

Serious

Reported By: Christian Sanggaard
Reported On: 12/21/2011
For: Version 4.31 Build 3

# 3529 Using Constant Value for Left Side of BETWEEN Expression in JOIN Clause Can Cause AV

The flowing SQL statement causes a AV error, while using DBISAM. I can solve the problem if I change the JOIN statement as indicated.

select * from JIT_WS_CampaignItems ci
left outer join  JIT_WS_Campaigns c on c.id = ci.campaignId
and current_date between c.startdate and c.enddate

JOIN Workaround:

and c.StartDate>=current_date and c.EndDate<=current_date

Resolution

Fixed Problem on 12/22/2011 in version 4.32 build 1

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