[ https://issues.apache.org/jira/browse/DRILL-2558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Parth Chandra updated DRILL-2558: --------------------------------- Fix Version/s: 1.1.0 > Four different errors are returned when running one COALESCE with multiple > arguments of 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) > Fix For: 1.1.0 > > > 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)