Rules for Updating a Table with a Row-Partitioned Join Index
a The system checks the WHERE clause condition for its truth value after the update to the row.
IF the condition evaluates to … |
THEN … |
FALSE |
the system deletes the row from the sparse join index. |
TRUE |
the system retains the row in the sparse join index and proceeds to stage b. |
b The system evaluates the new result of the partitioning expression for the updated row.
IF the partitioning expression … |
THEN … |
|
its result is not between 1 and 65535 for the row. The system aborts the request. It does not update the base table or the sparse join index, and returns an error. |
|
its result is between 1 and 65535 for the row. The system stores the row in the appropriate partition, which might be different from the partition in which it was previously, and continues processing requests. |