GAUSS-02821 -- GAUSS-02830

GAUSS-02821: “invalid length in external 'numeric' value”

SQLSTATE: 22P03

Description: The numeric input is invalid.

Solution: Check whether the data contains invalid numeric input. For the valid format of the numeric type, see section “Data Type.”

GAUSS-02822: “invalid sign in external 'numeric' value”

SQLSTATE: 22P03

Description: The numeric input is invalid.

Solution: Check whether the data contains invalid numeric input. For the valid format of the numeric type, see section “Data Type.”

GAUSS-02823: “invalid digit in external 'numeric' value”

SQLSTATE: 22P03

Description: The numeric input is invalid.

Solution: Check whether the data contains invalid numeric input. For the valid format of the numeric type, see section “Data Type.”

GAUSS-02824: “NUMERIC precision %d must be between 1 and %d”

SQLSTATE: 22023

Description: The numeric precision is beyond the range.

Solution: Modify the input value according to the precision range defined in the error message.

GAUSS-02825: “NUMERIC scale %d must be between 0 and precision %d”

SQLSTATE: 22023

Description: The numeric scale is beyond the range.

Solution: Modify the input value according to the precision range defined in the error message.

GAUSS-02826: “invalid NUMERIC type modifier”

SQLSTATE: 22023

Description: The numeric input is invalid.

Solution: Check whether the data contains invalid numeric input. For the valid format of the numeric type, see section “Data Type.”

GAUSS-02827: “count must be greater than zero”

SQLSTATE: 2201G

Description: The value of parameter count of the width_bucket function must be greater than zero.

Solution: Ensure that the value of parameter count of the width_bucket function is greater than zero.

GAUSS-02828: “operand, lower bound, and upper bound cannot be NaN”

SQLSTATE: 2201G

Description: The operand and upper and lower limits for the width_bucket function cannot be NaN.

Solution: Ensure that operand and upper and lower limits for the width_bucket function are not NaN.

GAUSS-02829: “lower bound cannot equal upper bound”

SQLSTATE: 2201G

Description: The upper and lower limits of the width_bucket function must be different.

Solution: Ensure that the upper and lower limits for the width_bucket function are different.

GAUSS-02830: “value overflows numeric format”

SQLSTATE: 22003

Description: The numeric factorial overflows.

Solution: Check whether the data input for the program is too large. If not, take measures to solve the problem at the application layer.

Feedback
编组 3备份
    openGauss 2024-07-15 01:01:34
    cancel