On this page

Show all

Help Center/ GaussDB(DWS)/ Error Code Reference/ Data Warehouse Service Error Codes/ GAUSS-00101 -- GAUSS-00200/ GAUSS-00141 -- GAUSS-00150

GAUSS-00141 -- GAUSS-00150

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

View PDF

GAUSS-00141: "missing argument"

SQLSTATE: 42601

Description: The parameter is missing when an operator is deleted.

Solution: Use the parameter defined for an operator when deleting the operator.

GAUSS-00142: "WITH CHECK OPTION is not implemented"

SQLSTATE: 0A000

Description: This option is not supported.

Solution: Use a supported option.

GAUSS-00143: "must be system admin to use EXECUTE DIRECT"

SQLSTATE: 42501

Description: The EXECUTE DIRECT statement is not run by the system administrator.

Solution: Run the EXECUTE DIRECT statement as the system administrator.

GAUSS-00144: "CREATE TABLE AS EXECUTE not yet supported"

SQLSTATE: 0A000

Description: The syntax is not supported.

Solution: Use supported syntax. For details, see the SQL Syntax.

GAUSS-00145: "number of columns does not match number of values"

SQLSTATE: 42601

Description: The number of columns to be modified is inconsistent with the number of provided values.

Solution: Ensure that the number of columns to be modified is consistent with the number of provided values.

GAUSS-00146: "Sort method %s is not supported!"

SQLSTATE: XX000

Description: The sorting method is not supported.

Solution: Use only supported options. For details, see the SQL Syntax.

GAUSS-00147: "LIMIT #,# syntax is not supported"

SQLSTATE: 42601

Description: The LIMIT limit_value,offset value syntax is not supported.

Solution: Use the LIMIT limit_value OFFSET offset_value syntax.

GAUSS-00148: "VALUES in FROM must have an alias"

SQLSTATE: 42601

Description: The values statement does not use an alias in the from clause.

Solution: Use an alias of the values statement in the from clause.

GAUSS-00149: "precision for type float must be at least 1 bit"

SQLSTATE: 22023

Description: The precision of float is set to a value less than 1.

Solution: Set the precision of float to a value greater than or equal to 1.

GAUSS-00150: "precision for type float must be less than 54 bits"

SQLSTATE: 22023

Description: The precision of float is set to a value greater than 54.

Solution: Set the precision of float to a value less than or equal to 54.

Parent topic: GAUSS-00101 -- GAUSS-00200

Previous topic: GAUSS-00131 -- GAUSS-00140

Next topic: GAUSS-00151 -- GAUSS-00160

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