GAUSS-00311 -- GAUSS-00320

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

SQLSTATE: 0A000

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

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

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

SQLSTATE: 0A000

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

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

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

SQLSTATE: 0A000

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

Solution:SELECT ... Ensure that the table name specified in the FOR UPDATE/SHARE...OF table_name syntax is not a list in the WITH clause. 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:SELECT ... table_name in the FROM table1_name FOR UPDATE/SHARE...OF table_name syntax is not in the FROM clause.

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

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

SQLSTATE: 42P16

Description:CREATE TABLE ... The CREATE TABLE ... LIKE source_table syntax is wrong when the table specified in the LIKE clause a partitioned table.

Solution:CREATE TABLE ... If the source table in the LIKE clause in the CREATE TABLE ... LIKE source_table syntax is a partitioned table, PARTITION BY must be used. Modify the syntax structure.

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

SQLSTATE: 42P16

Description:CREATE TABLE ... The LIKE clause in the CREATE TABLE ... LIKE source_table syntax contains the INCLUDING RELOPTIONS option, which conflicts with the WITH clause containing the source table.

Solution:"CREATE TABLE ... The LIKE clause in the CREATE TABLE ... LIKE source_table syntax contains the INCLUDING RELOPTIONS option, which cannot be used with the WITH clause containing 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.