Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-00101 -- GAUSS-00200/ GAUSS-00141 -- GAUSS-00150
Updated on 2023-12-22 GMT+08:00
View PDF
Share

GAUSS-00141 -- GAUSS-00150

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.