TEXT_CONTAINS does not match results where argument is in upper case
Open
bug
- Dominant language
- Java
- Stars
- 6.1k
- Forks
- 1.5k
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 189
Description
Let's say you have the following data, and you've added a native index on `col1`.
```
col1
'A V1'
'A'
```
TEXT_CONTAINS("col1", 'A') will return FALSE for both rows, which is unexpected.. TEXT_CONTAINS("col1", 'a') returns TRUE for both rows.
Contributor guide
Research direction
Reproduce TEXT_CONTAINS("col1", 'A') against a native index using the two rows described in the issue, then trace the TEXT_CONTAINS implementation and its related tests. Done means uppercase and lowercase arguments produce the expected matches for both rows, with a regression test covering the case.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100