New item with manually entered string primary key does not show "Field has to be unique" error message

[koksikus]

Describe the Bug

When I create a new collection with the primary key field and select "manually entered string", it does not show a duplication message when I enter the same number - it does not allow only to save. I can not select the uniqueness field because a database error pops up.

To Reproduce

Data-Model.mp4

Errors Shown

No response

What version of Directus are you using?

9.15.1

What version of Node.js are you using?

16.14.1

What database are you using?

MySQL

What browser are you using?

Edge

How are you deploying Directus?

locally

[licitdev]

This issue applies when a conflicting manual primary key is sent.

The RecordNotUniqueException for fields contain the field when the unique constraint is triggered.

However when it's for the primary key, the field is null.

directus/api/src/exceptions/database/record-not-unique.ts

Lines 11 to 15 in 55ec5f8

	if (field) {
	super(`Field "${field}" has to be unique.`, 400, 'RECORD_NOT_UNIQUE', extensions);
	} else {
	super(`Field has to be unique.`, 400, 'RECORD_NOT_UNIQUE', extensions);
	}

[rijkvanzanten]

Some database errors don't always return the field that was the one conflicting (very annoying). The app should show some sort of fallback warning for those (even though it's not as helpful).

[azrikahar]

Ref #15063 (comment) for additional context on a similar situation but with composite unique constraint.

[rijkvanzanten]

Linear: ENG-211