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

GAUSS-00851 -- GAUSS-00860

GAUSS-00851: "cannot %s '%s' because it is in use"

SQLSTATE: 55006

Description: When an SQL statement is executed, the data partition to be queried is being accessed.

Solution: Run this SQL statement after the data partition access is complete.

GAUSS-00852: "there is no column for a partitioned table!"

SQLSTATE: 42601

Description: When the partition key sequence is obtained from a partitioned table, the column of the partitioned table is empty.

Solution: Ensure that the partitioned table has no empty column.

GAUSS-00853: "there is no partition key!"

SQLSTATE: 42601

Description: When the partition key sequence is obtained from a partitioned table, the value of all partition keys is null.

Solution: Set the values of partition keys to valid ones.

GAUSS-00854: "duplicate partition key: %s"

SQLSTATE: 42701

Description: When the partition key sequence is obtained from a partitioned table, the partitioned table contains duplicate partition keys.

Solution: Delete the duplicate partition keys from this partitioned table.

GAUSS-00855: "undefined column'%s' is used as a partitioning column"

SQLSTATE: 42703

Description: When the partition key sequence is obtained from a partitioned table, an undefined column is detected in the partitioned table.

Solution: Modify this partitioned table to define the column.

GAUSS-00856: "must be one partition key for interval partition"

SQLSTATE: 42601

Description: An interval partition does not have one partition key.

Solution: Set merely one partition key for one interval partition.

GAUSS-00857: "column %s cannot serve as an interval partitioning column because of its datatype"

SQLSTATE: 42804

Description: The data type of a column does not meet the requirements on interval partition columns.

Solution: Modify the data type of the column to meet the requirements.