[jira] [Closed] (DRILL-6811) Fix type inference to return correct data mode for boolean functions

["Denys Ordynskiy (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-6811?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Denys Ordynskiy closed DRILL-6811.
----------------------------------

Tested with Drill version 1.16.0-SNAPSHOT (commit 0f05f53e0e34ccc0606a561f44d82b794be32b83).
Cases verified in the SQuirreL SQL client:
- IS NULL;
- IS NOT NULL;
- NOT;
- IS TRUE;
- IS NOT TRUE.

The result of this functions is not nullable.

> Fix type inference to return correct data mode for boolean functions
> --------------------------------------------------------------------
>
>                 Key: DRILL-6811
>                 URL: https://issues.apache.org/jira/browse/DRILL-6811
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.14.0
>            Reporter: Volodymyr Vysotskyi
>            Assignee: Volodymyr Vysotskyi
>            Priority: Major
>              Labels: ready-to-commit
>             Fix For: 1.15.0
>
>
> For some functions which return a boolean result and cannot return null values {{DrillDefaultSqlReturnTypeInference.inferReturnType()}} returns type with nullable data mode.
> Examples of the functions which cannot return nulls:
> * {{IS NULL}}
> * {{IS NOT NULL}}
> * {{NOT}}
> * {{IS TRUE}}
> and other.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)