Icon View Incident Report

Serious Serious
Reported By: Ole Willy Tuv
Reported On: 5/27/2007
For: Version 1.03 Build 1
# 2358 Truncation Errors Raised When Trailing Spaces Cause Overflow

The following SQL causes the error:

ElevateDB Error #1011 An error occurred with the column col1 (The value was truncated)

The general assignment rule is that if the length of the source value is greater than the maximum length of the target, and the extra characters are all spaces, then the source value is truncated to the length of the target.

create table test (col1 char varying(3));
insert into test values ('abc ');

Resolution Resolution
Fixed Problem on 5/28/2007 in version 1.04 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