[jira] [Created] (DRILL-8157) Replace buggy functions.cast_empty_string_to_null BOOT option

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

James Turton created DRILL-8157:
-----------------------------------

             Summary: Replace buggy functions.cast_empty_string_to_null BOOT 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


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.  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.1#820001)