Bug: D1 One-to-Many Relation INSERTs fail with The required connected records were not found. when using indices #23902
Description
Bug description
When creating rows with a one-to-many relation and using manually added @@indexs, the query fails with:
The required connected records were not found. Expected 1 records to be connected after connect operation on one-to-many relation 'OrderToTicket', found 2.
I believe this happens due to D1 returning the number of rows written, including writes to index tables... not actual written data rows.
How to reproduce
See the reproduction here: https://github.com/hrueger/prisma-23902. Basically, you need
- a schema with a one-to-many relation
- a manual index on the relation's id column
- a query connecting an item
Expected behavior
It should connect the record.
I think I found two possible ways:
- count the indices and substract that number from the
rows_writtenor - Skip that check for D1
Prisma information
// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema
generator client {
provider = "prisma-client-js"
previewFeatures = ["driverAdapters"]
}
datasource db {
provider = "sqlite"
url = env("DATABASE_URL")
}
model User {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
email String @unique
name String?
posts Post[]
}
model Post {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
title String
author User? @relation(fields: [authorId], references: [id])
authorId Int?
@@index([authorId])
}
const post = await prisma.post.create({
data: {
title: "Hello World" + Math.random(),
}
});
const user = await prisma.user.create({
data: {
email: Math.random() + "test@test.de",
name: "Test",
posts: {
connect: {
id: post.id
}
}
}
});Environment & setup
- OS: macOS
- Database: Cloudflare D1
- Node.js version: v21.6.1
Prisma Version
prisma : 5.12.1
@prisma/client : 5.12.1
Computed binaryTarget : darwin-arm64
Operating System : darwin
Architecture : arm64
Node.js : v21.6.1
Query Engine (Node-API) : libquery-engine 473ed3124229e22d881cb7addf559799debae1ab (at node_modules/@prisma/engines/libquery_engine-darwin-arm64.dylib.node)
Schema Engine : schema-engine-cli 473ed3124229e22d881cb7addf559799debae1ab (at node_modules/@prisma/engines/schema-engine-darwin-arm64)
Schema Wasm : @prisma/prisma-schema-wasm 5.12.0-21.473ed3124229e22d881cb7addf559799debae1ab
Default Engines Hash : 473ed3124229e22d881cb7addf559799debae1ab
Studio : 0.499.0
Preview Features : driverAdapters