For UPDATE statements and SELECT statements that contain an UPDATE clause, the following restriction applies to the use of search conditions:
If the new value of a column is calculated in an arithmetical expression, an inversion of this column, that is, the corresponding index, cannot be evaluated by the SQL Optimizer to determine the search strategy .
SET columnx = columnx + 3
WHERE columnx IN (100, 103, 106, 109, 112)
This SQL statement could lead to errors in the results if the inversion lists were processed step-by-step with the values 100, 103, 106, 109, and 112.