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>oris_null(<expr>) -
The expression has a variant type:
<expr> != <constant>oris_null(<expr>)oris_json_null(<expr>)
Updated about 1 hour ago
Did this page help you?