Could you file a JIRA for this? It seems trivial enough to fix. 

-----Original Message-----
From: Amit Garg [mailto:[email protected]] 
Sent: Monday, October 23, 2017 11:21 PM
To: [email protected]
Subject: Regarding where 1=0 clause

I am using  Apache Drill JDBC storage plugin. When I use 'where 1=0' clause I 
got  NullPointerException.


0: jdbc:drill:schema=dfs> select * from mysql.northwind.employees where 1 = 0;
Error: SYSTEM ERROR: NullPointerException



0: jdbc:drill:schema=dfs> select * from mysql.northwind.employees where 1 = 1;

This works fine.



I also posted this request to


https://community.mapr.com/message/63087-re-mapr-drill-problem-with-where-10?commentID=63087&et=watches.email.outcome#comment-63087

Reply via email to