Compiler Warning on Update

[zakko]

The following update statement in PL/SQL code produces a compiler warning in PL/SQL Developer:

UPDATE employees
   SET commission_pct = NULL
   WHERE job_id = 'SH_CLERK';

It says Hint: Comparison with NULL in [procedure name], but it is obviously not a comparison.

Version 15.0.4.2064 (64 bit)
Windows 11 Build 22631

 

[Marco Kalter]

I cannot immediately reproduce this. Can you send me a complete example?

 

[zakko]

No, unfortunately I can't share the original code, but I made a few changes to have it as close to the original as possible. I recognized, I missed a detail. The update is part of a forall, like so:

forall idx in 1..textArray.count save exceptions
  update books set startText = null
    where startText = textArray(idx).text
      and textArray(idx).name is null;

If I klick the warning, it marks the line "update books...". It might be possible, that the warning covers the whole update command and actually refers to the "is null" comparison - just a guess. But even in the latter case, I don't get the reason behind the warning.

 

[Marco Kalter]

This does indeed reproduce the issue for me. We'll fix it!