`where` clause with `*_none` not working (INLINE relation)

[baptistemarchand]

I have the following Prisma schema :

type InvoiceTripBlock {
  ...
  passengerBlocks: [InvoicePassengerBlock!]! @relation(name: "PassengerBlocksByInvoiceTripBlock", onDelete: CASCADE)
}

type InvoicePassengerBlock {
  ...
  tripBlock: InvoiceTripBlock @relation(name: "PassengerBlocksByInvoiceTripBlock")
}

In the Prisma playground, when I run this command

query {
  invoiceTripBlocks{
    id
    passengerBlocks{id}
  }
}

I get the following result :

"data": {
    "invoiceTripBlocks": [
      {
        "id": "ckmup7kdp0y0r08866bca4ck4",
        "passengerBlocks": []
      }
    ]
}

So I have one "invoiceTripBlock", which isn't connected to any "passengerBlock" (so far so good).

But when I run this query :

query {
  invoiceTripBlocks(where: {
    passengerBlocks_none: {}
  }){id}
}

I get this result :

"data": {
    "invoiceTripBlocks": []
}

which looks like a bug.
I expected to get the same result as the query above.
I have one "passengerBlock" in my db that used to be connected to the "invoiceTripBlock". If I remove it, the query works as expected.

Versions:

• Connector: MySQL
• Prisma Server: 1.34.10

Is there something I didn't understand or is it a bug?

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed in 10 days if no further activity occurs. Thank you for your contributions.