[GitHub] [pinot] deepakcse2k5 opened a new issue #7203: issues on where clause 1=1

[GitBox]

deepakcse2k5 opened a new issue #7203:
URL: https://github.com/apache/pinot/issues/7203


   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.
   <img width="1653" alt="Screenshot 2021-07-25 at 9 12 13 AM" 
src="https://user-images.githubusercontent.com/8656387/126887592-526acf64-4406-4c45-96c6-71158586c3ef.png";>
   <img width="1653" alt="Screenshot 2021-07-25 at 9 14 22 AM" 
src="https://user-images.githubusercontent.com/8656387/126887594-a8007b2c-e1b7-41c3-b50d-cbd5099c3119.png";>
   <img width="1653" alt="Screenshot 2021-07-25 at 9 16 04 AM" 
src="https://user-images.githubusercontent.com/8656387/126887596-cce27a28-5680-4c3c-88c5-577a4ae81d00.png";>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org