Code Inspection: Suspicious code in triggers
Reports incorrect usages of transition table variables in triggers.
In HSQLDB, DELETE triggers may be used only with the OLD state while INSERT triggers may have only the NEW state. So, in the previous example, NEW in
SELECT * FROM NEW;will be highlighted as well as OLD in
REFERENCING OLD ROW AS newrow.
Suppress an inspection in the editor
Position the caret at the highlighted line and press Alt+Enter or click .
Click the arrow next to the inspection you want to suppress and select the necessary suppress action.