GAUSS-00301 -- GAUSS-00310

GAUSS-00301: “EXECUTE DIRECT cannot execute this utility query”

SQLSTATE: 0A000

Description: In the EXECUTE DIRECT ON ( nodename [, … ] ) query syntax, a DML statement is executed on a DN, which is not supported.

Solution: Do not execute a DDL statement in the EXECUTE DIRECT ON ( nodename [, … ] ) query syntax.

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

SQLSTATE: 0A000

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

Solution: Do not execute a Set variable statement in the EXECUTE DIRECT ON ( nodename [, … ] ) query syntax.

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

SQLSTATE: 0A000

Description: The DISTINCT clause cannot be used in the SELECT FOR UPDATE/SHARE syntax.

Solution: Modify the statement.

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

SQLSTATE: 0A000

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

Solution: Modify the statement.

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

SQLSTATE: 0A000

Description: The HAVING clause cannot be used in the SELECT … FOR UPDATE/SHARE syntax.

Solution: Modify the statement.

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

SQLSTATE: 0A000

Description: Aggregate functions cannot be used in the SELECT … FOR UPDATE/SHARE syntax.

Solution: Modify the statement.

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

SQLSTATE: 0A000

Description: Window functions cannot be used in the SELECT … FOR UPDATE/SHARE syntax.

Solution: Modify the statement.

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

SQLSTATE: 0A000

Description: Functions with defined return values cannot be used in the SELECT … FOR UPDATE/SHARE syntax.

Solution: Modify the 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 database or schema references.

Solution: Ensure that the specified table name does not contain database or schema references.

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-store table.

Solution: Modify the syntax to ensure that the specified table cannot be a column-store table.

Feedback
编组 3备份
    openGauss 2024-05-26 00:44:47
    cancel