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 en-us_topic_0237121926.md.
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 en-us_topic_0237121926.md.
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 en-us_topic_0237121926.md.
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 en-us_topic_0237121926.md.
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.