View Incident Report

Serious

Reported By: Oliver Bock
Reported On: 3/29/2004
For: Version 4.04 Build 1

# 1626 Using a Constant Expression in an SQL JOIN Condition Causes an AV

The 'true' (or any other constant expression) in the supplied join causes an Access Violation.

drop table if exists "\Memory\A";
drop table if exists "\Memory\B";
create table "\Memory\A" (AID Integer, BID Integer);
create table "\Memory\B" (BID Integer);
insert into "\Memory\A" Values(1, 1);
insert into "\Memory\A" Values(2, 1);

select * from "\Memory\A"
join "\Memory\B" on B.BID = A.AID and true;

Resolution

Fixed Problem on 3/29/2004 in version 4.06 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap