Support for case-sensitive like in Pinot
- Dominant language
- Java
- Stars
- 6.1k
- Forks
- 1.5k
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 189
Description
At present, the `LIKE` command is case-insensitive while returning results. Are we planning to support case-sensitivity search in future with `LIKE`? Will this change the behaviour of `LIKE` that exists at present?
Other engines have 2 functions - `LIKE` and `ILIKE` where `ILIKE` is for case-insensitivity - https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-like/
Are we planning something similar?
Contributor guide
Research direction
No implementation file or test is named in the issue. Start by locating Pinot's current LIKE query handling and its case-sensitivity tests, then establish whether the intended result is a new case-sensitive operation, changed LIKE behavior, or a separate ILIKE-style operation; done requires an agreed semantic and corresponding coverage.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100