Hi there! New to this channel so please redirect me if this should go elsewhere. I'm using prisma with a mysql planetscale backend. I'm getting an error about ROW_NUMBER() in a

prisma.$queryRaw

Something like this, which works fine on my planetscale console:

const query = `select ROW_NUMBER() over() FROM contacts`;

Results in the error:

Code: `1105`. Message: `unknown error: syntax error at position 26`

Anyone know why prisma can't seem to handle

ROW_NUMBER()

function?

Hi @Ashe Magalhaes 👋 Can you please share the exact query you wrote in

queryRaw

?

Hey there, this is the query:

select ROW_NUMBER() over() FROM contacts

Hi @Ashe Magalhaes, I'll take a look at this today and revert.

how do we specify mysql version in prisma schema? I just have

datasource db {
  provider             = "mysql"
  url                  = env("DATABASE_URL")
  referentialIntegrity = "prisma"
}

Moving conversation to #orm-help