Icon View Incident Report

Serious Serious
Reported By: Walter Matte [Tactical Business Corporat
Reported On: 3/9/2013
For: Version 4.35 Build 1
# 3729 DELETE Statements that Contain Joins are Not Working Properly

The deletioin step in the following script is not deleting all the records it should be (this worked in an earlier version of DBISAM - I'm not sure when it began to fail)

// Script Starts Here

select dn.doid, sum(dn.amount) as amt, 0 as lvid, 0.0 as amt2, 0 as lvid2 
 into memory\WorkA 
 from donation dn 
 where dn.donationdate <= '2013-03-09'
  and dn.batch > 1 
  and dn.NoLevelTF = False 
  group by dn.doid, lvid, amt2, lvid2 
  order by 1;
  
create index iIndex on memory\WorkA (doid);

select dn.doid, sum(dn.amount) as amt, 0 as lvid 
 into memory\WorkB 
 from donation dn 
 where dn.donationdate <= '2012-08-31'
 and dn.batch > 1 
 and dn.NoLevelTF = False 
 group by dn.doid, lvid 
 order by 1;
 
create index iIndex on memory\WorkB (doid);
 
// This Step does not delete all records

Delete from memory\WorkA A
  Inner Join memory\WorkB B on (A.DOid = B.DOid)
  where A.amt = B.amt;
  
// There shouldn't be any records with amt1 and amt2 equal.

Select a.doid, a.amt, b.amt from memory\WorkA A
  Inner Join memory\WorkB B on (A.DOid = B.DOid); 



Comments Comments
There was a problem with


Resolution Resolution
Fixed Problem on 3/9/2013 in version 4.35 build 2


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