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:
1 Reply
I noticed that in source code drizzle itself is defining some tables named 'user' and 'session'. Why is that happening?