TT-01110
FOR UPDATE with aggregate function is deprecated
Cause
You specified a FOR UPDATE clause while selecting an aggregate function. The FOR UPDATE clause maintains a lock on an element (usually a row) until the end of the current transaction. Aggregate functions perform a specific operation over all rows in a group, causing the FOR UPDATE clause to not know which row to lock. Therefore, this operation is not recommended.
Action
Consider rewriting your SQL query.
For more information on the FOR UPDATE clause and aggregate functions, see SELECT and Aggregate functions respectively in the Oracle TimesTen In-Memory Database SQL Reference.
Additional Information
TT-01110
FOR UPDATE with aggregate function is deprecated
Cause
You specified a FOR UPDATE clause while selecting an aggregate function. The FOR UPDATE clause maintains a lock on an element (usually a row) until the end of the current transaction. Aggregate functions perform a specific operation over all rows in a group, causing the FOR UPDATE clause to not know which row to lock. Therefore, this operation is not recommended.
Action
Consider rewriting your SQL query.
For more information on the FOR UPDATE clause and aggregate functions, see SELECT and Aggregate functions respectively in the Oracle TimesTen In-Memory Database SQL Reference.
Additional Information
TT-01110
FOR UPDATE with aggregate function is deprecated
Cause
You specified a FOR UPDATE clause while selecting an aggregate function. The FOR UPDATE clause maintains a lock on an element (usually a row) until the end of the current transaction. Aggregate functions perform a specific operation over all rows in a group, causing the FOR UPDATE clause to not know which row to lock. Therefore, this operation is not recommended.
Action
Consider rewriting your SQL query.
For more information on the FOR UPDATE clause and aggregate functions, see SELECT and Aggregate functions respectively in the Oracle TimesTen In-Memory Database SQL Reference.
Additional Information
