Skip to content

Nested createMany with skipDuplicates option is not handled correctly #1162

@ymc9

Description

@ymc9

ZModel

model User {
  id String @id @default(cuid())
  companies CompanyUser[]
  @@allow('all', true)
}
            
model Company {
  id String @id @default(cuid())
  users CompanyUser[]
  @@allow('all', true)
}
            
model CompanyUser {
  company Company @relation(fields: [companyId], references: [id], onDelete: Cascade)
  companyId String
  user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  userId String
  @@id([companyId, userId])
  @@allow('all', true)
}

Code

const db = enhance(prisma);
await db.user.create({ data: { id: 'abc' } });
await db.user.create({ data: { id: 'def' } });
await db.company.create({ data: { id: '1', users: { create: { userId: 'abc' } } } });
await db.company.update({
     where: { id: '1' },
     data: {
       users: {
         createMany: {
           data: [{ userId: 'abc' }, { userId: 'def' }],
           skipDuplicates: true,
         },
       },
     },
     include: { users: true },
})

The code should succeed but it results in unique constraint violation error.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions