Updated on 2023-12-22 GMT+08:00

GAUSS-01701 -- GAUSS-01710

GAUSS-01701: "invalid system attribute number %d"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.

GAUSS-01702: "permission denied to create '%s.%s'"

SQLSTATE: 42501

Description: Creating the heap table fails probably because the creating mode or the database namespace is not allowed by the system.

Solution: Ensure that the creating mode or the database namespace is correct.

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

SQLSTATE: 42701

Description: Duplicate attribute names exist in the table.

Solution: Ensure that a specific attribute name is used more than once while defining the table.

GAUSS-01704: "column '%s' has pseudo-type %s"

SQLSTATE: 42P16

Description: Unknown attribute types exist in the table, causing attribute check failures.

Solution: Ensure that the current attribute type is supported by the system.

GAUSS-01705: "composite type %s cannot be made a member of itself"

SQLSTATE: 42P16

Description: The name of the composite type is the same as that of the current type, which is not allowed.

Solution: Ensure that the name of the composite type is the same as that of the current type.

GAUSS-01706: "no collation was derived for column '%s' with collatable type %s"

SQLSTATE: 42P16

Description: The attribute column supports attcollation but the attcollation is invalid, and the heap table cannot be created.

Solution: Ensure that the collation definition in the attribute column is valid when the table is created.

GAUSS-01707: "Invalid distribution column specified"

SQLSTATE: 42P16

Description: The attribute names used to mark distribution status is not contained in the attribute column. As a result, the number of the attribute column is equal to or less than zero.

Solution: Ensure that the attribute name in the DISTRIBUTE BY statement exists in the attribute column defined by the table.

GAUSS-01708: "Column %s is not a hash distributable data type"

SQLSTATE: 42809

Description: The data type cannot be distributed in the hash mode.

Solution: Ensure that the data used in the current column can be distributed in hash mode.

GAUSS-01709: "Column %s is not modulo distributable data type"

SQLSTATE: 42809

Description: The data type cannot be distributed in modulo mode.

Solution: Ensure that the data used in the current column can be distributed in modulo mode.

GAUSS-01710: "Invalid distribution type"

SQLSTATE: 42P16

Description: The system does not support the specified distribution type.

Solution: Ensure that the distribution type in use is supported by the system.