Rahul Challapalli created DRILL-1125:
----------------------------------------
Summary: Implicit cast not working in the join condition
Key: DRILL-1125
URL: https://issues.apache.org/jira/browse/DRILL-1125
Project: Apache Drill
Issue Type: Bug
Components: Execution - Data Types, Query Planning & Optimization
Reporter: Rahul Challapalli
Attachments: donuts.json, prices.json
git.commit.id.abbrev=810a204
Build # 26322
In the below query there is no type attached to 'donuts.id' but we expect
implicit cast to work in this case. Data files referenced are also attached
create view v1 as select cast(id as int) a, cast(price as double) b from prices;
select v1.a from v1 inner join donuts on v1.a = donuts.id;
Error From Sqlline : UnsupportedOperationException:[ Failure finding function
that runtime code generation expected. Signature: compare_to(
INT:OPTIONALVARCHAR:OPTIONAL, ) returns INT:REQUIRED ]
With slight modification the below query works
select v1.a from v1 inner join donuts on v1.a = donuts.id + 1 -1;
--
This message was sent by Atlassian JIRA
(v6.2#6252)
