[jira] [Created] (DRILL-5186) IS NOT NULL Working for where condition on INTEGER Column where it has no rows to return

[Ravan (JIRA)]

Ravan created DRILL-5186:
----------------------------

             Summary: IS NOT NULL Working for where condition on INTEGER Column 
where it has no rows to return
                 Key: DRILL-5186
                 URL: https://issues.apache.org/jira/browse/DRILL-5186
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
    Affects Versions: 1.8.0
            Reporter: Ravan


Query1: (Working)

select * from orcl.SOLIX_DEV.emp where ename is null

O/P: No Results Found

Query2: (Working)

select * from orcl.SOLIX_DEV.emp where comm is null

Query3: (Getting below Exception)

select * from orcl.DEV.emp where empno is null

Getting below exception:-

Query Failed: An Error Occurred
org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: 
NullPointerException

No use even after altering as
alter session set `drill.exec.functions.cast_empty_string_to_null` = true;



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)