ASSERT_EQUALS scalar function

Signals ASSERT_FAILED_STATE if A does not equal B.

Prototypes

ASSERT_EQUALS(A INTEGER, B INTEGER)
ASSERT_EQUALS(A DOUBLE, B DOUBLE)
ASSERT_EQUALS(A TIMESTAMP, B TIMESTAMP)
ASSERT_EQUALS(A TIME, B TIME)
ASSERT_EQUALS(A VARCHAR(4000), B VARCHAR(4000))

RETURNS INTEGER

Description

Raises the ASSERT_FAILED_STATE state if A does not equal B. The function is overloaded for most common types and generally should not need CASTs for usage. The return value in the case that the values are equal is arbitrary.

Parameters

A
The first value to compare
B
The value to compare to A

Examples

Test that TIMESTAMP is constant within an expression:

VALUES ASSERT_EQUALS(CURRENT TIMESTAMP, CURRENT TIMESTAMP);

1
-----------
          0

Test an obvious failure:

VALUES ASSERT_EQUALS(1, 2);

1
-----------
SQL0438N  Application raised error or warning with diagnostic text: "1 does
not equal 2".  SQLSTATE=90001