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

GAUSS-02831 -- GAUSS-02840

GAUSS-02831: "zero raised to a negative power is undefined"

SQLSTATE: 2201F

Description: The negative power of zero cannot be calculated.

Solution: Check whether the negative power of zero is calculated.

GAUSS-02832: "a negative number raised to a non-integer power yields a complex result"

SQLSTATE: 2201F

Description: Internal system error.

Solution: Contact technical support. Alternatively, check the statement or data.

GAUSS-02833: "cannot convert NaN to integer"

SQLSTATE: 0A000

Description: The Numeric NaN cannot be converted to an integer.

Solution: Do not convert NaN to an integer.

GAUSS-02834: "integer out of range"

SQLSTATE: 22003

Description: Integers overflow.

Solution: Analyze statements to determine whether integers exceed the range. Alternatively, convert the integers to the numeric type.

GAUSS-02835: "cannot convert NaN to bigint"

SQLSTATE: 0A000

Description: The Numeric NaN cannot be converted to the bigint type.

Solution: Do not convert NaN to the bigint type.

GAUSS-02836: "bigint out of range"

SQLSTATE: 22003

Description: The BIGINT overflows.

Solution: Analyze statements to determine whether BIGINT exceeds the range. Alternatively, convert the BIGINT type to the numeric type.

GAUSS-02837: "cannot convert NaN to smallint"

SQLSTATE: 0A000

Description: Failed to convert NaN to SMALLINT.

Solution: Check the original data.

GAUSS-02838: "smallint out of range"

SQLSTATE: 22003

Description: Data overflowed.

Solution: Contact technical support. Alternatively, check the statement or data.

GAUSS-02839: "cannot convert NaN to tinyint"

SQLSTATE: 0A000

Description: Failed to convert NaN to SMALLINT.

Solution: Check the original data.

GAUSS-02840: "tinyint out of range"

SQLSTATE: 22003

Description: Data is out of range.

Solution: Check the original data volume.