Icon View Incident Report

Serious Serious
Reported By: Roy Lambert
Reported On: 12/3/2009
For: Version 2.03 Build 6
# 3113 CAST Function Not Truncating VARCHAR Columns Properly

Using the following SELECT expression, I would expect 1000A1000 as the result, but in fact I get 1000023A1.

CAST(1000023 AS VARCHAR(4)) +'A'+  CAST(1000023 AS VARCHAR(4))

Comments Comments
The problem was that CAST() was not respecting the length specified for VARCHAR/CHAR columns, and truncating the column as necessary.

Resolution Resolution
Fixed Problem on 12/4/2009 in version 2.03 build 7

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 VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial