Icon View Incident Report

Minor Minor
Reported By: Rob Grundy
Reported On: 10/17/2005
For: Version 4.21 Build 10
# 2119 Using a Function with No Parameters in an SQL Join Causes Error

I'm converting our application from v3.24 to v4.21 build 10 and have found some unusual behaviour with left outer join clauses
In our 3.24 app the following sql works fine. However in 4.21 the current date comparisson seems to cause an error:

#11949 SQL Parsing Error - table correlation name j in JOIN clause experssion is invalid.

select
j.jb_JobNo,
MIN(b.CB_Date) as first_ccar, 
MAX(b.CB_Date) as last_ccar, 
b.CB_Reg as first_ccreg, 
a.CB_Reg as current_ccreg
from jobs j 
left outer join bookings b on (j.JB_JobNo=b.CB_JobNo) 
left outer join bookings a on (j.JB_JobNo=a.CB_JobNo) and (a.CB_Date =  Current_date) 
group by
j.JB_JobNo 



Resolution Resolution
Fixed Problem on 10/18/2005 in version 4.21 build 11


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

Image