OPAL v2026_09_30

Version v2026_09_30 changes how not-equals (!=) comparisons treat null values, which enables the new filter input experience:

Previously, in OPAL v2021_01_01, the following expressions return null when <expr> is SQL null, or evaluates as "expected" when the <expr> is a JSON null:

<expr> != <constant>
<constant> != <expr>

In OPAL v2026_09_30, those expressions are rewritten to include a null check in the following scenarios:

  • The expression has a non-variant type: <expr> != <constant> or is_null(<expr>)

  • The expression has a variant type: <expr> != <constant> or is_null(<expr>) or is_json_null(<expr>)


Did this page help you?