Ambiguous self relation detected

[prisma]

Ambiguous self relation detected

[jasonkuhrt]

I just hit this issue tonight and Google'd my way here.

model User {
  id       String @id @default(cuid())
  mother   User?
  father   User?
  children User[]
}

I expected this to just work. Naively maybe :)

I can make the error go away by:

model User {
  id       String @id @default(cuid())
  mother   User?  @relation("mother")
  father   User?  
  children User[] @relation("mother")
}

or

model User {
  id       String @id @default(cuid())
  mother   User?  
  father   User?  @relation("father")
  children User[] @relation("father")
}

But this doesn't make sense to me.

[mavilein]

Hey @yovanoc ,

thanks for reaching out! 🙏 Can you please answer the following questions:

1. What's your full Datamodel?
2. What version of the VS Code Plugin are you using?

[yovanoc]

No problem @mavilein !

Here's the datamodel: https://gist.github.com/yovanoc/ca47e5fb738bfeb52cb37ef2cb07b1c3

And I don't know how to see the plugin version but It's surely the latest, even if I remove and install again. But I want to say thats not only in vscode:

[yovanoc]

PS: It only appear when I uncomment the two last self references

[mavilein]

Ah thanks for the file. So the problem is that it is reported at the wrong location. You have to write your datamodel like this to fix that:

model CelestisInstance {
  id          CUID
  ...
  boundDaemonInstance    CelestisInstance? @relation(name: "MyRelation")
  boundTerminalInstances CelestisInstance[] @relation(name: "MyRelation")
}

You need to specify this like that because we need to know if those fields belong to the same relation or two different relations. I will make myself a note to make this clearer with a suggestion.

[yovanoc]

Oh that was my fault, so the "MyRelation" mean that is a self model relation??

[janpio]

(This spawned an issue by @schickling in specs: prisma/specs#213)

[yoshuawuyts]

Talked about this in triage today, this should be fixed.