Skip to main content

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.