Icon View Incident Report

Serious Serious
Reported By: Ricardo Oliveira
Reported On: 12/16/2005
For: Version 4.22 Build 3
# 2150 Using NOT Around Join Conditions in WHERE Clause Causes AV

I'm having some problems with the following query. When I try to run this SQL I get this error,

DBISAM Engine Error # 11950 SQL execution error - Internal error: table correlation name a;b referenced in WHERE clause is not defined in the FROM clause

and then some access violation.

Select * into "\memory\MemTable" from "C:\...\Table";
select a.*
from Table a, "\memory\MemTable" b
where not (a.Field1=b.Field1 and a.Field2=b.Field2);



Resolution Resolution
Fixed Problem on 1/6/2006 in version 4.22 build 4


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

Image