Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We鈥檒l occasionally send you account related emails.

Already on GitHub? Sign in to your account

[MongoDB] Alphanumeric insensitive filters don't work #14663

Closed
Weakky opened this issue Aug 4, 2022 · 0 comments 路 Fixed by prisma/prisma-engines#3088
Closed

[MongoDB] Alphanumeric insensitive filters don't work #14663

Weakky opened this issue Aug 4, 2022 · 0 comments 路 Fixed by prisma/prisma-engines#3088
Assignees
Labels
bug/2-confirmed Bug has been reproduced and confirmed. kind/bug A reported bug. team/client Issue for team Client. tech/engines Issue for tech Engines. topic: mongodb
Milestone

Comments

@Weakky
Copy link
Member

Weakky commented Aug 4, 2022

Overview

Consider the following datamode 馃憞l,

model User {
  id Int @id @map("_id")
  name String
}

the following dataset 馃憞,

[
  { id: 1, name: "Z" },
]

And the following query 馃憞:

await prisma.user.findMany({ where: { name: { gt: "a", mode: insensitive } } })

It should return:

[
  { id: 1, name: "Z" },
]

But it returns:

[]
@Weakky Weakky added bug/2-confirmed Bug has been reproduced and confirmed. tech/engines Issue for tech Engines. team/client Issue for team Client. topic: mongodb labels Aug 4, 2022
@janpio janpio transferred this issue from prisma/prisma-engines Aug 4, 2022
@do4gr do4gr added the kind/bug A reported bug. label Aug 5, 2022
Weakky added a commit to prisma/prisma-engines that referenced this issue Aug 18, 2022
@Weakky Weakky self-assigned this Aug 23, 2022
@janpio janpio added this to the 4.3.0 milestone Aug 27, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug/2-confirmed Bug has been reproduced and confirmed. kind/bug A reported bug. team/client Issue for team Client. tech/engines Issue for tech Engines. topic: mongodb
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants