[jira] [Created] (DRILL-2558) For different errors are returned when running COALESCE with incompatible data types

["Victoria Markman (JIRA)" <ji...@apache.org>]

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)