|
Problem IT28480
|
Status: Closed |
SELECT FROM TABLE EXPRESSION WITH CORRELATED SUBQ IN SELECT LISTRETURRN 9600 INSTEAD OF 284
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
When a correlated subquery in a select list of a table
expression returns more than one
row and the master select may have filter conditions on this
column expression result the
query returns an error -9600 but should return -284.
Query looks like this:
select * from (
select
(select it0016_vertr_ende from basis2_s where basis2_s.persnr =
lin_pers.persnr) it0016_vertr_ende,
( select austritt from basis_s where pernr = persnr) austritt
from lin_pers
)
where not (austritt is null AND it0016_vertr_ende = '31.12.1699'
) ;
The correlation of the second select returned in some cases more
than one row. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of IDS prior to 12.10.xC13. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Select from table expression with correlated subquerie in *
* select list return 9600 instead of 284. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.03.2019
26.09.2019
26.09.2019 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC13
|
| Problem solved according to the fixlist(s) of the following version(s) |
