Prisma.join throwing error when using edge client

prisma : 5.22.0
@prisma/client : 5.22.0
Node.js : v23.1.0
Next.JS : v15.0.3

Temporary solution (bad):
change
import { PrismaClient } from "@prisma/client/edge";
to
import { PrismaClient } from "@prisma/client";

When i tried to use Prisma.join() on raw query using edge client i got an error: TypeError: The "payload" argument must be of type object. Received null
Example query:

await prisma.$queryRaw`
        SELECT "id" FROM "table"
        WHERE "x" = ${String(query)}
        AND "y" = ${String(query1)}
        AND "z" IN (${Prisma.join(stringsArray)})
        AND "i" IN (${Prisma.join(stringsArray)})
        AND "j" IN (${Prisma.join(stringsArray)})
        LIMIT ${number}`

await prisma.$queryRaw`
        SELECT "id" FROM "table"
        WHERE "x" = ${String(query)}
        AND "y" = ${String(query1)}
        AND "z" IN (${Prisma.join(stringsArray)})
        AND "i" IN (${Prisma.join(stringsArray)})
        AND "j" IN (${Prisma.join(stringsArray)})
        LIMIT ${number}`

Any idea how to make it work on edge?

Solution

Hi @Papa Smerf

The edge client is a stripped down version and may not support the Prisma.join() api. Rewriting the raw query without using Prisma.join() should resolve this issue.

await prisma.$queryRaw`
  SELECT "id" FROM "table"
  WHERE "x" = ${String(query)}
  AND "y" = ${String(query1)}
  AND "z" = ANY(${stringsArray}::text[])
  AND "i" = ANY(${stringsArray}::text[])
  AND "j" = ANY(${stringsArray}::text[])
  LIMIT ${number}

await prisma.$queryRaw`
  SELECT "id" FROM "table"
  WHERE "x" = ${String(query)}
  AND "y" = ${String(query1)}
  AND "z" = ANY(${stringsArray}::text[])
  AND "i" = ANY(${stringsArray}::text[])
  AND "j" = ANY(${stringsArray}::text[])
  LIMIT ${number}

The raw query example assumes you are using Postgres. Let me know if this helps.

Jump to solution

Prisma•16mo ago•

5 replies

Papa Smerf

Prisma.join throwing error when using edge client

await prisma.$queryRaw`
        SELECT "id" FROM "table"
        WHERE "x" = ${String(query)}
        AND "y" = ${String(query1)}
        AND "z" IN (${Prisma.join(stringsArray)})
        AND "i" IN (${Prisma.join(stringsArray)})
        AND "j" IN (${Prisma.join(stringsArray)})
        LIMIT ${number}`

await prisma.$queryRaw`
        SELECT "id" FROM "table"
        WHERE "x" = ${String(query)}
        AND "y" = ${String(query1)}
        AND "z" IN (${Prisma.join(stringsArray)})
        AND "i" IN (${Prisma.join(stringsArray)})
        AND "j" IN (${Prisma.join(stringsArray)})
        LIMIT ${number}`

Any idea how to make it work on edge?

Solution

Hi @Papa Smerf

The edge client is a stripped down version and may not support the Prisma.join() api. Rewriting the raw query without using Prisma.join() should resolve this issue.

await prisma.$queryRaw`
  SELECT "id" FROM "table"
  WHERE "x" = ${String(query)}
  AND "y" = ${String(query1)}
  AND "z" = ANY(${stringsArray}::text[])
  AND "i" = ANY(${stringsArray}::text[])
  AND "j" = ANY(${stringsArray}::text[])
  LIMIT ${number}

await prisma.$queryRaw`
  SELECT "id" FROM "table"
  WHERE "x" = ${String(query)}
  AND "y" = ${String(query1)}
  AND "z" = ANY(${stringsArray}::text[])
  AND "i" = ANY(${stringsArray}::text[])
  AND "j" = ANY(${stringsArray}::text[])
  LIMIT ${number}

The raw query example assumes you are using Postgres. Let me know if this helps.

Jump to solution

Prisma.join throwing error when using edge client

Similar Threads

Prisma.join throwing error when using edge client

Similar Threads

Similar Threads

Similar Threads