Reported By: Ole Willy Tuv Reported On: 5/27/2007 For: Version 1.03 Build 1
# 2358Truncation 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 ');
ResolutionFixed Problem on 5/28/2007 in version 1.04 build 1
Products AffectedElevateDB 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