drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ravan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5186) IS NOT NULL Working for where condition on INTEGER Column where it has no rows to return
Date Tue, 10 Jan 2017 07:47:58 GMT
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)

Mime
View raw message