Icon View Incident Report

Serious 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 Resolution
Fixed Problem on 3/29/2004 in version 4.06 build 1