Dialect#supportsNotNullUnique is used by 2 areas:

1.) Table. Prevents "not null unique" if unsupported by the dialect.
2.) UniqueKey. The logic is reversed from #1. Appears to prevent unique constraints from being created if supportsNotNullUnique is false and one of the constraint's columns is nullable.

The uses seem inconsistent and incorrect.