Aller au contenu principal

AS_OF_JOIN error condition

SQLSTATE: 42604

Invalid as-of join.

TOLERANCE_IS_NON_NEGATIVE​

The input argument tolerance must be non-negative.

TOLERANCE_IS_UNFOLDABLE​

The input argument tolerance must be a constant.

UNSUPPORTED_DIRECTION​

Unsupported as-of join direction '<direction>'. Supported as-of join direction include: <supported>.

UNSUPPORTED_MATCH_CONDITION_OPERAND​

The MATCH_CONDITION operands (<type1> and <type2>) use types that require multi-column sort-merge ASOF join execution. Only scalar numeric and datetime operands are currently supported.

UNSUPPORTED_WITH_NESTED_CORRELATED_SUBQUERY​

As-of join is not supported inside a nested correlated subquery.