GAUSS-00311 -- GAUSS-00320

GAUSS-00311: "SELECT FOR UPDATE/SHARE cannot be applied to a join"

SQLSTATE: 0A000

Description: The range table in the SELECT ... FOR UPDATE/SHARE...OF table_name syntax is a connection table of the JOIN type.

Solution: Ensure that the specified range table in the SELECT ... FOR UPDATE/SHARE...OF table_name syntax cannot be a connection table of the JOIN type. Modify the syntax structure.

GAUSS-00312: "SELECT FOR UPDATE/SHARE cannot be applied to a function"

SQLSTATE: 0A000

Description: The range table in the SELECT ... FOR UPDATE/SHARE...OF table_name syntax is a function.

Solution: Ensure that the specified table in the SELECT ... FOR UPDATE/SHARE...OF table_name syntax cannot be a function. Modify the syntax structure.

GAUSS-00313: "SELECT FOR UPDATE/SHARE cannot be applied to a WITH query"

SQLSTATE: 0A000

Description: The range table in the SELECT ... FOR UPDATE/SHARE...OF table_name syntax is a list with the WITH clause identifier.

Solution: The specified range table in the SELECT ... FOR UPDATE/SHARE...OF table_name syntax cannot be a list with the WITH clause identifier. Modify the syntax structure.

GAUSS-00314: "unrecognized RTE type: %d"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-00315: "relation '%s' in FOR UPDATE/SHARE clause not found in FROM clause"

SQLSTATE: 42P01

Description: table_name in the SELECT ... FROM table1_name FOR UPDATE/SHARE...OF table_name syntax does not exist in the FROM clause.

Solution: Ensure that table_name in the SELECT ... FROM table1_name FOR UPDATE/SHARE...OF table_name syntax exists in the FROM clause.

GAUSS-00316: "unsupport 'like clause including partition' for partitioned table"

SQLSTATE: 42P16

Description: The CREATE TABLE ... LIKE source_table syntax where the source table in the LIKE clause is a partitioned table is incorrect.

Solution: If the specified source table in the LIKE clause is a partitioned table in the CREATE TABLE ... LIKE source_table syntax, the partition by clause is required. In such a case, modify the syntax structure.

GAUSS-00317: "unsupport 'like clause including reloptions' together with 'with'"

SQLSTATE: 42P16

Description: In the CREATE TABLE ... LIKE source_table syntax, the INCLUDING RELOPTIONS option contained in the LIKE clause is used with the WITH clause of the source table, resulting in a grammatical conflict.

Solution: In the CREATE TABLE ... LIKE source_table syntax, the INCLUDING RELOPTIONS option in the LIKE clause cannot be used with the WITH clause of the source table. The INCLUDING RELOPTIONS option and the WITH clause of the source table both indicate that the storage parameters of the source table are copied to a new table. Therefore, use only the INCLUDING RELOPTIONS option or the WITH clause of the source table.

GAUSS-00318: "array of serial is not implemented"

SQLSTATE: 0A000

Description: The field type in the CREATE TABLE or ALTER TABLE syntax is a serial array, causing an error.

Solution: Ensure that the field type in the CREATE TABLE or ALTER TABLE syntax is not a serial array.

GAUSS-00319: "conflicting NULL/NOT NULL declarations for column '%s' of table '%s'"

SQLSTATE: 42601

Description: The non-null column names specified in the CREATE TABLE or ALTER TABLE syntax are in conflict with the null column names specified in the constraint clause.

Solution: Ensure that the null column names specified in the constraint clause in the CREATE TABLE or ALTER TABLE syntax are consistent with the column names specified in the field name list.

GAUSS-00320: "multiple default values specified for column '%s' of table '%s'"

SQLSTATE: 42601

Description: Multiple names are specified for columns in the constraint clause of the CREATE TABLE or ALTER TABLE syntax.

Solution: Ensure that only one name is specified for columns in the constraint clause of the CREATE TABLE or ALTER TABLE syntax.