Invalid query executing without any error message.
Open
- Dominant language
- Java
- Stars
- 6.1k
- Forks
- 1.5k
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 189
Description
Invalid queries seems to run successfully in the Pinot sql console without producing any error. This gives the impression that the query ran, but returned an empty result.
**select playerId as a, yearid as a from baseballStats limit 100
select xyz from baseballStats limit 100**
Contributor guide
Research direction
Start by reproducing the two invalid queries in the Pinot SQL console and verify that they appear to succeed with empty results. Trace how the console reports query errors, then confirm that duplicate aliases and unknown columns produce visible errors when the issue is fixed.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100