On 5/16/15 7:25 AM, Bryan Pendleton wrote:
3, when the select in an update statement, can't get the warning 01003.
ij(CONNECTION1)> UPDATE APP.EMP T1 SET SALARY = ( SELECT AVG ( T2 .
SALARY ) FRO
M APP.EMP T2 ) WHERE WORKDEPT = 'D21' AND SALARY < ( SELECT AVG ( T3
. SALARY )
FROM APP.EMP T3 );
7 rows inserted/updated/deleted
The lack of the warning seems incorrect to me. But I'm not sure if this
behavior is governed by the SQL Standards or not.
thanks,
bryan
Nulls are ignored when computing aggregates, but they should cause the
statement to raise a warning, as specified in the 2011 SQL Standard,
part 2, section 10.9 (aggregate function), General Rule 6a. I don't see
anything in the Standard which absolves the UPDATE statement of its
responsibility to report a warning encountered during the processing of
an aggregate. So, I agree. This looks like a bug to me.
Please feel free to log a bug.
Thanks,
-Rick
