Updated on 2025-06-07 GMT+08:00

U0100079: GaussDB supports FOR UPDATE OF followed by a table name only

Description

GaussDB does not support FOR UPDATE OF followed by a column name.

Database Type and Version

  • Source database type and version: Oracle versions supported by UGO
  • Target database type and version: GaussDB versions supported by UGO

Syntax Example

SELECT * FROM test WHERE id = 1 FOR UPDATE OF id;

Suggestion

Replace the column name with its table name.