On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-00701 -- GAUSS-00800/ GAUSS-00781 -- GAUSS-00790

GAUSS-00781 -- GAUSS-00790

Updated on 2024-03-15 GMT+08:00

View PDF

GAUSS-00781: "cannot alter data type of distribute column"

SQLSTATE: 0A000

Description: When ALTER COLUMN TYPE is run, the type of distribution columns of a table cannot be modified.

Solution: Modify this operation.

GAUSS-00782: "cannot refer to other columns in transform expression for column store table"

SQLSTATE: 0A000

Description: The column-store table does not allow the update of data to reference the values of other columns while you change the column type.

Solution: Do not modify column types. Instead, create a table with the required column types.

GAUSS-00783: "transform expression must not return a set"

SQLSTATE: 42804

Description: When ALTER COLUMN TYPE is run, a transform expression cannot return a set.

Solution: Modify this operation.

GAUSS-00784: "cannot use subquery in transform expression"

SQLSTATE: 0A000

Description: When ALTER COLUMN TYPE is run, a transform expression uses a subquery.

Solution: Modify this operation.

GAUSS-00785: "cannot use aggregate function in transform expression"

SQLSTATE: 42803

Description: When ALTER COLUMN TYPE is run, a transform expression uses an aggregate function.

Solution: Modify this operation.

GAUSS-00786: "cannot use window function in transform expression"

SQLSTATE: 42P20

Description: When ALTER COLUMN TYPE is run, a transform expression uses a window function.

Solution: Modify this operation.

GAUSS-00787: "column '%s' cannot be cast automatically to type %s"

SQLSTATE: 42804

Description: When ALTER COLUMN TYPE is run, a column cast type is not specified.

Solution: Specify the column cast type.

GAUSS-00788: "type of inherited column '%s' must be changed in child tables too"

SQLSTATE: 42P16

Description: When ALTER COLUMN TYPE is run, the column type of a child table does not change as the column type of its parent table changes.

Solution: In the statement, specify that the child table changes when the parent table changes.

GAUSS-00789: "cannot alter data type of partitioning column '%s'"

SQLSTATE: 0A000

Description: When ALTER COLUMN TYPE is run, the column type of a partitioned table cannot be modified.

Solution: Modify this operation.

GAUSS-00790: "cannot alter type of column '%s' twice"

SQLSTATE: 0A000

Description: When ALTER COLUMN TYPE is run, the type of a column cannot be modified twice.

Solution: Modify this operation.

Parent topic: GAUSS-00701 -- GAUSS-00800

Previous topic: GAUSS-00771 -- GAUSS-00780

Next topic: GAUSS-00791 -- GAUSS-00800

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel