[jira] [Created] (HIVE-24538) Enforce strict type checks on all operators relying on comparisons

["Stamatis Zampetakis (Jira)" <ji...@apache.org>]

Stamatis Zampetakis created HIVE-24538:
------------------------------------------

             Summary: Enforce strict type checks on all operators relying on comparisons
                 Key: HIVE-24538
                 URL: https://issues.apache.org/jira/browse/HIVE-24538
             Project: Hive
          Issue Type: Task
          Components: HiveServer2
            Reporter: Stamatis Zampetakis
            Assignee: Stamatis Zampetakis


Strict type checks are enforced when {{hive.strict.checks.type.safety}} is enabled to prevent unexpected query results in some common cases where implicit type conversions take place.

At the moment these checks are enforced in most comparison based operators (=,<,>,<=,>=,<>,<=>) but not all. For instance the checks are not active for BETWEEN and IN operators and possibly others. 

The goal of this issue is to review {{FunctionRegistry#getCommonClassForComparison}} and make sure that operators relying on comparisons are covered (at a minimum BETWEEN, IN).



--
This message was sent by Atlassian Jira
(v8.3.4#803005)