Icon View Incident Report

Minor Minor
Reported By: Arnd Baranowski
Reported On: 3/2/2008
For: Version 1.08 Build 1
# 2561 Using LIKE in a Correlated Sub-Query On Correlated Columns Can Cause Incorrect Results

The following syntax does not work. "POS" also does not work in an Update statement. The first found value is set to all rows.

Update Code_Map Set
  MappedRate = (SELECT Rate from ebc_rates_cw WHERE
                  Code_Map.Dialcode like (ebc_rates_cw.Dialcode + '%'));

Workaround:

Update Code_Map Set
  MappedRate = (SELECT Rate from ebc_rates_cw WHERE
                  ebc_rates_cw.Dialcode = left(Code_Map.Dialcode,4));



Comments Comments and Workarounds
The workaround is as noted.


Resolution Resolution
Fixed Problem on 3/4/2008 in version 1.09 build 1
Image