GAUSS-02281 -- GAUSS-02290

GAUSS-02281: “unrecognized mergejoin state: %d”

SQLSTATE: XX000

Description: An execution error occurs. The execution policy chosen by MergeJoin is incorrect.

Solution: Internal system error. Contact technical support.

GAUSS-02282: “RIGHT JOIN is only supported with merge-joinable join conditions”

SQLSTATE: 0A000

Description: A plan error occurs. The merge right join is not supported.

Solution: Internal system error. Contact technical support.

GAUSS-02283: “FULL JOIN is only supported with merge-joinable join conditions”

SQLSTATE: 0A000

Description: For MergeJoin, FULL JOIN cannot process non-constant expressions (JOIN clauses).

Solution: Check whether the JOIN clauses are constants during FULL JOIN invocation in the SQL statement.

GAUSS-02284: “non-MVCC snapshots are not supported in index-only scans”

SQLSTATE: 0A000

Description: The index-only scan does not support MVCC snapshots.

Solution:Contact technical support.

GAUSS-02285: “EvalPlanQual recheck is not supported in index-only scans”

SQLSTATE: 0A000

Description: The index-only scan does not support recheck during concurrent update.

Solution:Contact technical support.

GAUSS-02288: “could not find hash function for hash operator %u”

SQLSTATE: 42883

Description: The corresponding hash function cannot be found.

Solution: Check whether the data type supports the hash function.

GAUSS-02289: “cursor '%s' is not a SELECT query”

SQLSTATE: 24000

Description:Internal system error.

Solution:Contact technical support.

GAUSS-02290: “cursor '%s' is held from a previous transaction”

SQLSTATE: 24000

Description: The cursor is held by the previous transaction.

Solution: Check the cursor status.