Icon View Incident Report

Serious Serious
Reported By: Abdulaziz Jasser
Reported On: 9/25/2007
For: Version 1.05 Build 2
# 2459 Non-Join Expressions in JOIN Clause of SELECT Statement Can Cause Access Violation

When running the below query I got an error "Invalid Pointer Operation".

SELECT 
R.BranchSysNo, 
0,        
R.InvoiceSysNo,        
R.StoreSysNo,        
R.ItemSysNo,        
R.UnitSysNo,        
R.ReturnPrice,        
R.ReturnQuantity,        
CAST(R.ExpirationDate AS CHAR(8)),        
R.ReturnReasonType,        
R.ReturnReason,        
R.PurchasePrice,        
R.ItemCost,        
I.ItemNo,        
I.ItemName_A,        
I.ItemName_E,        
I.HasExpirationDate,        
S.StoreName,        
U.UnitName,        
U.UnitFactor 

FROM TB_Return R

INNER JOIN TB_Items I 
ON   I.YearSysNo    = 0 
AND  I.BranchSysNo  = R.BranchSysNo 
AND  I.StoreSysNo   = R.StoreSysNo 
AND  I.ItemSysNo    = R.ItemSysNo 

INNER JOIN TB_Stores S 
ON   S.BranchSysNo  = R.BranchSysNo 
AND  S.StoreSysNo   = R.StoreSysNo 

INNER JOIN TB_Units U 
ON   U.BranchSysNo  = R.BranchSysNo 
AND  U.UnitSysNo    = R.UnitSysNo 

WHERE R.BranchSysNo  = 1 
AND   R.InvoiceSysNo = 173 

GROUP BY I.ItemNo,R.UnitSysNo,R.ReturnQuantity,R.ReturnPrice



Comments Comments and Workarounds
The workaround is to move the:

I.YearSysNo = 0

expression from the JOIN clause into the WHERE clause.


Resolution Resolution
Cannot Fix Problem


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image