Icon View Incident Report

Serious Serious
Reported By: Richard Harding
Reported On: 11/29/2017
For: Version 2.26 Build 7
# 4604 Cannot Use Outer Query Table Correlation Names in UNIONed Query

An error occurs in the second SELECT statement. The same SELECT statement used as the first SELECT works fine. An example is listed below.

Line 11: Expected column name express but instead found "T1"."ID"

SELECT ID, Status
 FROM Tasks AS T1
 WHERE 
   EXISTS
    (SELECT * 
       FROM Tasks AS T2
       WHERE (T1.ID = T2.ID) AND (T2.Status = 'Recorded') -- OK
     UNION
     SELECT *
       FROM Tasks AS T3
       WHERE (T1.ID = T3.ID) AND (T3.Status = 'Assigned'))



Resolution Resolution
Fixed Problem on 12/26/2017 in version 2.27 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image