Nurul
09/26/2022, 3:25 PMHi 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 aprisma.$queryRaw
Something like this, which works fine on my planetscale console:
Copy codeconst query = `select ROW_NUMBER() over() FROM contacts`;
Results in the error:
Copy codeCode: `1105`. Message: `unknown error: syntax error at position 26`
Anyone know why prisma can’t seem to handlefunction?ROW_NUMBER()
Raphael Etim
09/27/2022, 9:05 AMROW_NUMBER()
functionAshe Magalhaes
09/27/2022, 6:03 PMRaphael Etim
09/27/2022, 6:28 PM