test: add a test case

jacek-prisma · jacek-prisma · commit 9efd8c645e3f · 2026-01-06T12:01:41.000Z
diff --git a/packages/client/tests/functional/issues/28968-sqlite-exists-duplicate/_matrix.ts b/packages/client/tests/functional/issues/28968-sqlite-exists-duplicate/_matrix.ts
@@ -0,0 +1,4 @@
+import { defineMatrix } from '../../_utils/defineMatrix'
+import { Providers } from '../../_utils/providers'
+
+export default defineMatrix(() => [[{ provider: Providers.SQLITE }]])
diff --git a/packages/client/tests/functional/issues/28968-sqlite-exists-duplicate/prisma/_schema.ts b/packages/client/tests/functional/issues/28968-sqlite-exists-duplicate/prisma/_schema.ts
@@ -0,0 +1,26 @@
+import { idForProvider } from '../../../_utils/idForProvider'
+import testMatrix from '../_matrix'
+
+export default testMatrix.setupSchema(({ provider }) => {
+  return /* Prisma */ `
+  generator client {
+    provider = "prisma-client-js"
+  }
+
+  datasource db {
+    provider = "${provider}"
+  }
+
+  model Organization {
+    id    ${idForProvider(provider, { includeDefault: true })}
+    types OrganizationType[]
+  }
+
+  model OrganizationType {
+    organizationId String
+    type           Int
+    organization   Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)
+    @@id([organizationId, type])
+  }
+  `
+})
diff --git a/packages/client/tests/functional/issues/28968-sqlite-exists-duplicate/tests.ts b/packages/client/tests/functional/issues/28968-sqlite-exists-duplicate/tests.ts
@@ -0,0 +1,41 @@
+import testMatrix from './_matrix'
+// @ts-ignore
+import type { PrismaClient } from './generated/prisma/client'
+
+declare let prisma: PrismaClient
+
+testMatrix.setupTestSuite(
+  () => {
+    test('should not duplicate rows for a nested "some ... in" query', async () => {
+      await prisma.organization.create({
+        data: {
+          types: {
+            createMany: {
+              data: [{ type: 1 }, { type: 10 }],
+            },
+          },
+        },
+      })
+
+      expect(
+        await prisma.organization.count({
+          where: {
+            types: {
+              some: {
+                type: {
+                  in: [1, 10],
+                },
+              },
+            },
+          },
+        }),
+      ).toBe(1)
+    })
+  },
+  {
+    optOut: {
+      from: ['mongodb', 'sqlite', 'sqlserver', 'postgresql', 'mysql', 'cockroachdb'],
+      reason: 'this test is for a SQlite implementation bug',
+    },
+  },
+)
