Background documentationRestrictions for UPDATE Statements Locate this document in the navigation structure

 

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 .

Example Example

UPDATE <table_name>

  SET columnx = columnx + 3

    WHERE columnx IN (100,103,106,109,112)

This SQL statement could lead to errors in the results if the database system were to process inversion lists step-by-step with the values 100, 103, 106, 109, and 112.

End of the example.

More Information