Additional collation support for the NULLIF conditional expression has been added. The NULLIF conditional expression is now affected by collation and can be used in collation-supported comparisons with the STRUCT data type. This feature is generally available (GA).
Feature
Additional collation support for the
NULLIFconditional expression has been added. TheNULLIFconditional expression is now affected by collation and can be used in collation-supported comparisons with theSTRUCTdata type. This feature is generally available (GA).https://cloud.google.com/bigquery/docs/release-notes#June_18_2024