Reported By: Heiko Knuettel Reported On: 9/2/2008 For: Version 2.01 Build 4
# 2770Using a LIST Aggregate Function in Another Expression Causes Error The following SQL causes a compilation error.
select '(' + list( ... ) + ')' from table
Comments and WorkaroundsThe workaround is to CAST the LIST() to a VARCHAR, and that will be allowed.
ResolutionFixed Problem on 9/2/2008 in version 2.01 build 5
Products AffectedElevateDB 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 VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial