Restrictions for UPDATE Statements

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 (the corresponding index) cannot be evaluated by the SQL optimizer to determine the search strategy.

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.

More Information

Search Conditions
Search Strategies
SQL Reference Manual, UPDATE Statement (update_statement), UPDATE Clause (update_clause)