Victoria Markman created DRILL-2558:
---------------------------------------
Summary: For different errors are returned when running COALESCE
with incompatible data types
Key: DRILL-2558
URL: https://issues.apache.org/jira/browse/DRILL-2558
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Affects Versions: 0.8.0
Reporter: Victoria Markman
Assignee: Daniel Barclay (Drill)
Drill tries to do implicit cast during runtime, and we agreed that if
particular cast is not implemented run time exception is fine for now.
However, it feels weird to get four of them at the same time.
I think we should throw exception on the first incompatibility and stop
processing rest of the arguments.
{code}
0: jdbc:drill:schema=dfs> select coalesce(c_varchar, c_integer, c_bigint,
c_float, c_double, c_date, c_time, c_timestamp, c_boolean) from j2;
Query failed: Query stopped., Failure while trying to materialize incoming
schema. Errors:
Error in expression at index -1. Error: Missing function implementation:
[castBIT(TIMESTAMP-OPTIONAL)]. Full expression: --UNKNOWN EXPRESSION--.
Error in expression at index -1. Error: Missing function implementation:
[castBIT(TIME-OPTIONAL)]. Full expression: --UNKNOWN EXPRESSION--.
Error in expression at index -1. Error: Missing function implementation:
[castBIT(DATE-OPTIONAL)]. Full expression: --UNKNOWN EXPRESSION--.
Error in expression at index -1. Error: Missing function implementation:
[castFLOAT8(BIT-OPTIONAL)]. Full expression: --UNKNOWN EXPRESSION--.. [
e2effaf7-6fcc-4d7d-b408-2031aab2a344 on atsqa4-133.qa.lab:31010 ]
Error: exception while executing query: Failure while executing query.
(state=,code=0)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
