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)