Icon View Incident Report

Minor Minor
Reported By: Ole Willy Tuv
Reported On: 3/29/2007
For: Version 1.01 Build 1
# 2290 A SELECT with Duplicate Column Correlation Name that Returns a Sensitive Result Set Causes Error

The following SQL causes the error:

Error:
ElevateDB Error #400 The column col1 already exists

select
 cast(col1 as clob) col1,
 cast(col2 as varchar(3)) col2,
 col3,
 col4
from t2



Comments Comments and Workarounds
The issue was with the fact that the SELECT expression correlation name was the same as an existing column in the underlying table. The workaround is to use a different column correlation name that isn't the same as a column in the underlying table for the SELECT expression.


Resolution Resolution
Fixed Problem on 3/31/2007 in version 1.02 build 1


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

Image