Icon View Incident Report

Serious 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 Resolution
Fixed Problem on 12/22/2011 in version 4.32 build 1


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

Image