Entering content frame

Background documentation Restrictions for UPDATE Statements Locate the document in the library 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

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 inversion lists were processed step-by-step with the values 100, 103, 106, 109, and 112.

See also:

SQL Reference Manual, UPDATE Statement (update_statement), UPDATE Clause (update_clause)

 

Leaving content frame