Icon View Incident Report

Serious Serious
Reported By: Ole Willy Tuv
Reported On: 3/21/2007
For: Version 1.01 Build 1
# 2275 Sub-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

Resolution Resolution
Fixed Problem on 3/22/2007 in version 1.02 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