On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-02801 -- GAUSS-02900/ GAUSS-02831 -- GAUSS-02840

GAUSS-02831 -- GAUSS-02840

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

View PDF

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.

Parent topic: GAUSS-02801 -- GAUSS-02900

Previous topic: GAUSS-02821 -- GAUSS-02830

Next topic: GAUSS-02841 -- GAUSS-02850

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