drizzle-team / drizzle-team/drizzle-orm-docs

Clarify that pattern matching with `LIKE` operator is case insensitive for `SQLite` and `MySQL`

Open
#239 0 comments 12 reactions 0 assignees View on GitHub
Dominant language
MDX
Stars
241
Forks
401
Avg merge
5h 44m
Merged PRs (30d)
1

Description

The Drizzle ORM docs specify that `LIKE` operator is "case sensitive" for `SQLite`, `MySQL` and `PostgreSQL` databases at https://orm.drizzle.team/docs/operators#like

But actually the `LIKE` operator is only case sensitive for `PostgreSQL`[1] and is case insensitive for `SQLite`[2] and `MySQL`[3] databases.

I have tested `SQLite` with `bun-sqlite` driver and can confirm that the `LIKE` filter returns case insensitive results for me.

File to be edited: https://github.com/drizzle-team/drizzle-orm-docs/blob/b4fb88dccf468e3fad7de8b7769bca92c73280ca/src/content/documentation/docs/operators.mdx#L348

[1] https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-LIKE
[2] https://www.sqlite.org/lang_expr.html
[3] https://dev.mysql.com/doc/refman/8.0/en/pattern-matching.html

Screenshots:

PostgresQL:
![Screenshot from 2024-03-03 22-28-34](https://github.com/drizzle-team/drizzle-orm-docs/assets/26682202/9f600fc3-f6d5-469c-a043-859532f8021c)

SQLite:
![Screenshot from 2024-03-03 22-28-04](https://github.com/drizzle-team/drizzle-orm-docs/assets/26682202/18b5a085-c650-4761-a906-0da7b34e8237)

MySQL:
![Screenshot from 2024-03-03 22-27-18](https://github.com/drizzle-team/drizzle-orm-docs/assets/26682202/162d8a81-d951-4353-84aa-17e21bce0ca8)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.