[ahmed_ds]

When something that fundamental changes what is the cascading effect? Do other functions refer UNIQUE/NULL or do they have their own versions of UNIQUE/NULL like code?

[masklinn]

There is no fundamental change, this is an opt-in on a per-index basis.

It does not change null’s identity, it only allows indexes to treat nulls as identical.