Can't delete using "Foreign key constraints" (beta)

[zbeyens]

Using prisma without relationMode = "prisma" and enrolled beta, I could not delete an entity with the following schema:

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["fullTextSearch", "fullTextIndex"]
}

datasource db {
  provider     = "mysql"
  url          = env("DATABASE_URL")
}

model User {
  // ...
  mainCharacterId String?    @unique
  mainCharacter   Character? @relation("mainCharacter", fields: [mainCharacterId], references: [id])
}

model Character {
  id     String @id @default(cuid())
  userId String

  mainCharacterOfUser User?  @relation("mainCharacter")

  createdAt DateTime @default(now())
  updatedAt DateTime @default(now())

  @@index([userId])
  @@map(name: "characters")
}

Invalid prisma.character.delete() invocation:
[0]
[0]
[0] Error in connector: Error querying the database: Server error: `ERROR HY000 (1105): unavailable: vtgate connection error: no endpoints, after 1 attempts'
[0] ❌ tRPC failed on character.deleteCharacter:

Adding back relationMode = "prisma" fixed it.

[zbeyens]

I had this error

Error validating: Reference causes a cycle. One of the @relation attributes in this cycle must have onDelete and onUpdate referential actions set to NoAction. Cycle path: User.mainCharacter → Character.user. (Implicit default onDelete: SetNull, and onUpdate: Cascade) Read more at https://pris.ly/d/cyclic-referential-actions

which was not logged without relationMode = "prisma". I can now remove relationMode = "prisma" after fixing the cycle issue.