issues on where clause 1=1
- Dominant language
- Java
- Stars
- 6.1k
- Forks
- 1.5k
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 189
Description
Hi ,
I am exploring Apache Pinot query console and found that some queries like -select * from transcript where 1=1 does not working.It gives error like - it gives error like - org.apache.pinot.pql.parsers.Pql2CompilationException: Comparison between two constants is not supported.
where 1 = 1 means no where clause.It will always be true, so all records will be returned.This is basically used for testing the query to return all rows.

while this query is working under presto.

Contributor guide
Research direction
Start by reproducing `select * from transcript where 1=1` in the Apache Pinot query console and trace the reported Pql2CompilationException through the PQL parser. Compare the behavior with the working Presto query; done means the constant predicate is accepted and the query returns all records as described.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100