[
https://issues.apache.org/jira/browse/DRILL-8136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Turton updated DRILL-8136:
--------------------------------
Description: The existing implicit casting system is built on simplistic
total ordering of data types that yields oddities such as TINYINT being
regarded as the closest numeric type to VARCHAR. This, in turn, hurts the range
of data types with which SQL functions can be used. E.g. `select
sqrt('3.1415926')` works in many RDBMSes, and will in Drill too if we improve
the implcit casting system. (was: Additional UDFs to overload existing Math
functions in Drill so that Math UDFs accept input in type VARCHAR.)
> Overhaul implict type cast system
> ---------------------------------
>
> Key: DRILL-8136
> URL: https://issues.apache.org/jira/browse/DRILL-8136
> Project: Apache Drill
> Issue Type: Improvement
> Reporter: Esther Buchwalter
> Priority: Minor
>
> The existing implicit casting system is built on simplistic total ordering of
> data types that yields oddities such as TINYINT being regarded as the closest
> numeric type to VARCHAR. This, in turn, hurts the range of data types with
> which SQL functions can be used. E.g. `select sqrt('3.1415926')` works in
> many RDBMSes, and will in Drill too if we improve the implcit casting system.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
