hi, Below is the SQL details in derby ij:
1, list the column salary is null record. ij(CONNECTION1)> select empno, salary from emp where salary is null; EMPNO |SALARY ----------------- 001188|NULL 000010|NULL 2 rows selected 2?? when run select with function avg lonely, can get the warning. ij(CONNECTION1)> SELECT AVG ( T2 . SALARY ) FROM APP.EMP T2; 1 ---------------- 28363.2926 WARNING 01003: Null values were eliminated from the argument of a column functio n. 1 row selected 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 ij(CONNECTION1)> And I also tried JDBC call derby, also the pure select can get the warning, the update one also can't get the warning message, do you think this is a defect? Thanks for your help :).
