Prisma

hi everyone, i had a question about prisma’s handling of CITEXT. it appears that there might be a recent regression that changes CITEXT default treatment from case-insensitive to case-sensitive. i’m happy to submit a pr to attempt to fix this, though i’d greatly appreciate a few pointers in terms of where i should be looking at

has anyone else experienced anything like this?

if not, does anyone know where in the prisma codebase i should be looking at to attempt to fix this?

Hi Kerem :wave:
I can see that you have already created a PR: <https://github.com/prisma/prisma/pull/14889|#14889>
Thanks for doing that. Our engineering team is monitoring the PRs so they should be able to get back to you on that.
I would also suggest creating a <https://github.com/prisma/prisma/issues/new?assignees=&amp;labels=kind%2Fbug&amp;template=bug_report.yml|Bug Report> for this regression

thanks for getting back to me <@U024DS62DRC>. i’ll look into the bug report today. in the meantime, will you be able to point me in the right direction for where the relational queries get translated to `where in` queries? i have a pretty strong hunch that that’s where the bug is at, and i’ll be more than happy to add an actual solution to my PR, on top of the failing test

I am not entirely sure where the conversion happens, but it must be in the <https://github.com/prisma/prisma-engines/tree/main/query-engine|Query Engine> in our Prisma Engines repository.