`Error: Unique constraint failed on the (not available)`

This issue here is about the error message, which can not provide the actual column name as it is not provided by PlanetScale/Vitess

Digging more into this seems like when a raw query is executed via PlanetScale, it does return some data about the column on which the unique constraint first fails on.

Here’s an example with a users table with unique email and uuid (where the uuid is generated application side)

Failing with email when both email and uuid are duplicates:

target: {REDACTED}.-.primary: vttablet: rpc error: 
code = AlreadyExists desc = Duplicate entry 'testing@gmail.com' 
for key 'users.users_email_key' (errno 1062) (sqlstate 23000) 
(CallerID: planetscale-admin): Sql: "insert into 
users(email, first_name, `name`, slug, uuid, updated_at, meta) 
values (:vtg1, :vtg2, :vtg3, :vtg4, :vtg5, :vtg6, :vtg7)", BindVars: {REDACTED}

Failing with uuid when only uuid is a duplicate:

target: {REDACTED}.-.primary: vttablet: rpc error: 
code = AlreadyExists desc = Duplicate entry 'abc123' 
for key 'users.users_uuid_key' (errno 1062) (sqlstate 23000) 
(CallerID: planetscale-admin): Sql: "insert into users(email, first_name, 
`name`, slug, uuid, updated_at, meta)
values (:vtg1, :vtg2, :vtg3, :vtg4, :vtg5, :vtg6, :vtg7)", BindVars: {REDACTED}

Overall new to the Prisma codebase, but going to start looking into where in Prisma are these errors handled. Any directions would be super helpful.

This issue here is about the error message, which can not provide the actual column name as it is not provided by PlanetScale/Vitess, as described in the original issue. There is no real solution than to fix Vitess or implement some workaround that gets the column name from the original query.

If you have any code that causes the Unique constraint failed ... error message although it is unexpected, this issue here is not the correct one. Please open a new issue and describe your problem. (E.g. your problem @dyeoman2 would be a good new bug report so we can look into how this can happen)