apache / apache/pinot

TEXT_CONTAINS does not match results where argument is in upper case

Open
#11,436 1 comment 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.