Query With Empty String Literal Fails with IN_SUBQUERY
Open
- Dominant language
- Java
- Stars
- 6.1k
- Forks
- 1.5k
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 189
Description
Repro:
```
select count(*) from baseballStats where
IN_SUBQUERY(playerID, 'SELECT ID_SET(playerID) FROM baseballStats WHERE teamID != ''''') limit 10
```
Is this a known issue? I tried find a ticket here for this but couldn't find any.
Contributor guide
Research direction
Start by reproducing the provided baseballStats query in Apache Pinot and capture the failure details. Trace the IN_SUBQUERY handling for the nested SELECT and empty string literal, then verify that the query executes successfully without changing its intended result.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100