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)
