On this page

Show all

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

GAUSS-02851 -- GAUSS-02860

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

View PDF

GAUSS-02851: "invalid input syntax for integer: '%s'"

SQLSTATE: 22P02

Description: The source string is incorrect.

Solution: Check the data source.

GAUSS-02852: "value '%s' is out of range for type bigint"

SQLSTATE: 22003

Description: Data is out of range.

Solution: Check the metadata.

GAUSS-02853: "OID out of range"

SQLSTATE: 22003

Description: Data is out of range.

Solution: Check the metadata.

GAUSS-02854: "step size cannot equal zero"

SQLSTATE: 22023

Description: The SQL statement is incorrect.

Solution: Modify the SQL statement. The interval cannot be zero.

GAUSS-02855: "argument of ntile must be greater than zero"

SQLSTATE: 22014

Description: Internal system error. The value of the parameter expression in the obtained frame must be greater than zero.

Solution: Internal system error. Contact technical support.

GAUSS-02856: "argument of nth_value must be greater than zero"

SQLSTATE: 22016

Description: Internal system error. For a frame, its values, excluding its first value, should be greater than zero.

Solution: Internal system error. Contact technical support.

GAUSS-02858: "range constructor flags argument must not be NULL"

SQLSTATE: 22000

Description: The SQL statement is incorrect.

Solution: Modify the SQL statement.

GAUSS-02859: "range types do not match"

SQLSTATE: 42804

Description: The SQL statement is incorrect.

Solution: Modify the SQL statement.

GAUSS-02860: "result of range difference would not be contiguous"

SQLSTATE: 22000

Description: The SQL statement is incorrect.

Solution: Modify the statement.

Parent topic: GAUSS-02801 -- GAUSS-02900

Previous topic: GAUSS-02841 -- GAUSS-02850

Next topic: GAUSS-02861 -- GAUSS-02870

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