apache / apache/pinot

Query With Empty String Literal Fails with IN_SUBQUERY

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

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.