Kbase P150877: Unjustified: Subquery returns multiple rows error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2009 |
|
Status: Unverified
SYMPTOM(s):
Unjustified: Subquery returns multiple rows error
Subquery returns multiple rows (7529)
FACT(s) (Environment):
Running a select for feeding the set column
Tables are related via a primary key
select field_1 from table_2 where field_1 = (select field_1 from table_1 where table_1.field_2 = table_2.field_2 and table_1.field_3 = table_2.field_3);
Same works fine with MS-SQL.
OpenEdge 10.1B
OpenEdge 10.1C
OpenEdge 10.2A
Windows
CAUSE:
Bug# OE00167446
CAUSE:
OE sql is not using a correct execution model when the subquery used to produce the update value is a correlated subquery (i.e., has outer references to table being updated). If subquery is not correlated, should be OK but In the case here, the subquery is correlated and the OE execution is wrong.
FIX:
Upgrade to OpenEdge version 10.2A02 or later