View Incident Report

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

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap