GAUSS-00261 -- GAUSS-00270

GAUSS-00261: "subfield '%s' is of type %s but expression is of type %s"

SQLSTATE: 42804

Description: Data types at both sides of the expression are inconsistent.

Solution: Switch the data type at either side to make them consistent.

GAUSS-00262: "column '%s' specified more than once"

SQLSTATE: 42701

Description: A column of data is specified multiple times when data is inserted to a table object.

Solution: Ensure that you inset data in each column only once.

GAUSS-00263: "SELECT * with no tables specified is not valid"

SQLSTATE: 42601

Description: The syntax is not supported.

Solution: Modify the SQL statement.

GAUSS-00265: "Un-support feature"

SQLSTATE: XX000

Description: The feature is not supported.

Solution: Do not use this feature.

GAUSS-00266: "internal relation doesn't allow INSERT"

SQLSTATE: XX000

Description: Data is inserted into an internal object.

Solution: Do not insert data into internal objects.

GAUSS-00267: "unexpected non-SELECT command in INSERT ... SELECT"

SQLSTATE: XX000

Description: The syntax is not supported.

Solution: Modify the SQL statement.

GAUSS-00268: "VALUES lists must all be the same length"

SQLSTATE: 42601

Description: In the INSERT ... VALUES statement, the number of VALUES does not match that of the table columns.

Solution: 1. Run the \d tblname command to check the column information about the table. 2. Ensure that the number of VALUES in the INSERT ... VALUES statement matches the number of table columns. 3. Modify the syntax of the INSERT ... VALUES statement.

GAUSS-00269: "VALUES must not contain table references"

SQLSTATE: 0A000

Description: The SELECT clause of the INSERT ... VALUES statement contains a JOIN list.

Solution: Ensure that the SELECT clause of the INSERT ... VALUES statement does not contain a JOIN list. Modify the INSERT statement based on its syntax.

GAUSS-00270: "VALUES must not contain OLD or NEW references"

SQLSTATE: 0A000

Description: The syntax is not supported.

Solution: Modify the SQL statement.