Case sensitivity issue with planetscale

Hey all, apologies if this is already addressed. I am migrating from prisma+planetscale to drizzle+planetscale and I use nextauth for authentication. The issue I am facing is my database has table named in pascal case for ex - 'Session' and 'User'. However, after the nextauth CredentialProvider callback, drizzle is running the query wherein the queries are using lowercase table names e.g. 'session' and 'user'. This is throwing an error from the database. Additional info:- 1. Using planetscale adapter for drizzle. 2. Schema is generated by introspecting database. Initially I thought by manually changing table names from 'session' to 'Session' in schema file, the issue would be solved but that is not the case. Attaching relevant screenshots:
No description
No description
1 Reply
Se7enVision
Se7enVisionOP8mo ago
I noticed that in source code drizzle itself is defining some tables named 'user' and 'session'. Why is that happening?
No description
Want results from more Discord servers?
Add your server