[jira] [Updated] (DRILL-8157) Replace buggy functions.cast_empty_string_to_null config option

["James Turton (Jira)" <ji...@apache.org>]

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

James Turton updated DRILL-8157:
--------------------------------
    Fix Version/s:     (was: 1.21.0)

> Replace buggy 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)