[
https://issues.apache.org/jira/browse/DRILL-8157?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Turton updated DRILL-8157:
--------------------------------
Summary: Replace quirky functions.cast_empty_string_to_null config option
(was: Replace buggy functions.cast_empty_string_to_null config option)
> Replace quirky functions.cast_empty_string_to_null config option
> ----------------------------------------------------------------
>
> Key: DRILL-8157
> URL: https://issues.apache.org/jira/browse/DRILL-8157
> Project: Apache Drill
> Issue Type: Bug
> Reporter: James Turton
> Assignee: James Turton
> Priority: Major
>
> Setting the config option {{drill.exec.functions.cast_empty_string_to_null}}
> causes errors when string literals containing dates and timestamps appear in
> a query because of its implementation as function over the entire query
> syntax tree. Reproduce as follows.
>
> {code:java}
> set `drill.exec.functions.cast_empty_string_to_null` = true;
> select * from cp.`tpch/lineitem.parquet` where l_shipdate = '1970-01-01';
> Error: SYSTEM ERROR: ClassCastException: class
> org.apache.drill.exec.expr.holders.NullableDateHolder cannot be cast to class
> org.apache.drill.exec.expr.holders.DateHolder
> (org.apache.drill.exec.expr.holders.NullableDateHolder and
> org.apache.drill.exec.expr.holders.DateHolder are in unnamed module of loader
> 'app'){code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
