Reported By: Ole Willy Tuv Reported On: 3/21/2007 For: Version 1.01 Build 1
# 2275Sub-Query Assignments Where Sub-Query Only Contains Constants Result in NULL Values When you run the following SQL, t1.col1 has been updated with null, instead of the correct value 'B'.
create table t1 (col1 varchar(10));
create table t2 (col1 integer);
insert into t1 values ('A');
insert into t2 values (1);
insert into t2 values (2);
update t1 set col1 = (select 'B' from t2 where col1 = 1);
select * from t1
ResolutionFixed Problem on 3/22/2007 in version 1.02 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