On this page

Show all

Help Center/ GaussDB(DWS)/ 8.2.0 and earlier versions/ Data Warehouse Service Error Codes/ GAUSS-00301 -- GAUSS-00400/ GAUSS-00301 -- GAUSS-00310

GAUSS-00301 -- GAUSS-00310

Updated on 2023-12-22 GMT+08:00

View PDF

GAUSS-00301: "EXECUTE DIRECT cannot execute this utility query"

SQLSTATE: 0A000

Description: In the EXECUTE DIRECT ON ( nodename [, ... ] ) query syntax, a DDL statement is run on a DN.

Solution: In the EXECUTE DIRECT ON ( nodename [, ... ] ) query syntax, ensure that the DDL statement cannot be executed and only the SELECT statement is supported.

GAUSS-00302: "EXECUTE DIRECT cannot execute locally this utility query"

SQLSTATE: 0A000

Description: In the EXECUTE DIRECT ON ( nodename [, ... ] ) query syntax, the SET variable statement is run on a DN.

Solution: In the EXECUTE DIRECT ON ( nodename [, ... ] ) query syntax, ensure that the variable setting statement cannot be executed and only the SELECT statement is supported.

GAUSS-00303: "SELECT FOR UPDATE/SHARE is not allowed with DISTINCT clause"

SQLSTATE: 0A000

Description: The DISTINCT clause cannot be used for SELECT FOR UPDATE/SHARE.

Solution: Modify the SQL statement.

GAUSS-00304: "SELECT FOR UPDATE/SHARE is not allowed with GROUP BY clause"

SQLSTATE: 0A000

Description: The GROUP BY clause cannot be used for the SELECT ... FOR UPDATE/SHARE syntax.

Solution: Modify the SELECT ... FOR UPDATE/SHARE statement.

GAUSS-00305: "SELECT FOR UPDATE/SHARE is not allowed with HAVING clause"

SQLSTATE: 0A000

Description: The SELECT FOR UPDATE/SHARE syntax does not support the HAVING clause.

Solution: Modify the SELECT ... FOR UPDATE/SHARE statement.

GAUSS-00306: "SELECT FOR UPDATE/SHARE is not allowed with aggregate functions"

SQLSTATE: 0A000

Description: Aggregate functions cannot be used with SELECT ... FOR UPDATE/SHARE.

Solution: Modify the SELECT ... FOR UPDATE/SHARE statement.

GAUSS-00307: "SELECT FOR UPDATE/SHARE is not allowed with window functions"

SQLSTATE: 0A000

Description: Window functions cannot be used with SELECT ... FOR UPDATE/SHARE.

Solution: Modify the SELECT ... FOR UPDATE/SHARE statement.

GAUSS-00308: "SELECT FOR UPDATE/SHARE is not allowed with set-returning functions in the target list"

SQLSTATE: 0A000

Description: In the target list of the SELECT ... FOR UPDATE/SHARE syntax, the function with the return value defined is not supported.

Solution: Modify the SELECT ... FOR UPDATE/SHARE statement.

GAUSS-00309: "SELECT FOR UPDATE/SHARE must specify unqualified relation names"

SQLSTATE: 42601

Description: In the SELECT ... FOR UPDATE/SHARE...OF table_name syntax, the specified table name contains a database or schema reference.

Solution: Ensure that the specified table name in the SELECT ... FOR UPDATE/SHARE...OF table_name syntax is a specific one rather than table references, such as database.table and schema.table.

GAUSS-00310: "SELECT FOR UPDATE/SHARE cannot be used with column table '%s'"

SQLSTATE: 0A000

Description: The table specified in the SELECT ... FOR UPDATE/SHARE...OF table_name syntax is a column storage table.

Solution: Ensure that the table specified in the SELECT ... FOR UPDATE/SHARE...OF table_name syntax cannot be a column storage table. Modify the syntax structure.

Parent topic: GAUSS-00301 -- GAUSS-00400

Previous topic: GAUSS-00301 -- GAUSS-00400

Next topic: GAUSS-00311 -- GAUSS-00320

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.See the reply and handling status in My Cloud VOC.

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

For any further questions, feel free to contact us through the chatbot.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback

Log In and Submit Submit Cancel