We're updating the issue view to help you get more done.Learn more

NULLABLE Unique indexes + auto validation: validation blocks valid null input

When any fields in a unique index are NULLABLE, the UX is ignored if any of the field values are NULL in a given row (ANSI standard, only MS SQL does not respect this).

However, the preside validation logic for unique indexes does not respect this and will show a 'must be unique' error when this valid data situation occurs.

Status

Assignee

Unassigned

Reporter

Dominic Watson

Accepted

Yes

Fix versions

Priority

Medium