Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-00701 -- GAUSS-00800/ GAUSS-00781 -- GAUSS-00790
Updated on 2023-12-22 GMT+08:00
View PDF
Share

GAUSS-00781 -- GAUSS-00790

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.