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

GAUSS-01131 -- GAUSS-01140

GAUSS-01131: "prepared statement is not a SELECT"

SQLSTATE: 42809

Description: The prepared statement in CREATE TABLE AS EXECUTE is not a SELECT statement.

Solution: Change the prepared statement to a SELECT statement.

GAUSS-01132: "wrong number of parameters for prepared statement '%s'"

SQLSTATE: 42601

Description: The number of parameters required for the prepared statement does not match the number of parameters obtained.

Solution: Ensure that the number of parameters in EXECUTE is the same as that in PREPARE. Then, run PREPARE and EXECUTE again.

GAUSS-01133: "cannot use subquery in EXECUTE parameter"

SQLSTATE: 0A000

Description: Subqueries cannot be used for prepared statements.

Solution: Do not use subqueries in prepared statements.

GAUSS-01134: "cannot use aggregate function in EXECUTE parameter"

SQLSTATE: 42803

Description: Aggregate functions cannot be used for prepared statements.

Solution: Do not use aggregate functions in prepared statements.

GAUSS-01135: "cannot use window function in EXECUTE parameter"

SQLSTATE: 42P20

Description: Window functions cannot be used in prepared statements.

Solution: Do not use window functions in prepared statements.

GAUSS-01136: "parameter $%d of type %s cannot be coerced to the expected type %s"

SQLSTATE: 42804

Description: The parameter type in the prepared statement cannot be converted to the expected parameter type.

Solution: Add required type conversions and ensure that the parameter type in the prepared statement can be converted.

GAUSS-01137: "Passing parameters in PREPARE statement is not supported"

SQLSTATE: 0A000

Description: Parameters cannot be remotely passed in prepared statements.

Solution: Do not perform distributed parameter passing in prepared statements.

GAUSS-01138: "prepared statement '%s' already exists"

SQLSTATE: 42P05

Description: The prepared statement already exists.

Solution: Check existing prepared statement records in pg_prepared_statements and do not create duplicate prepared statements.

GAUSS-01139: "prepared statement '%s' does not exist"

SQLSTATE: 26000

Description: The prepared statement to be executed does not exist.

Solution: Check whether the executed prepared statement exists in pg_prepared_statements.

GAUSS-01140: "EXPLAIN EXECUTE does not support variable-result cached plans"

SQLSTATE: XX000

Description: Internal system error.

Solution: Contact technical support.