[ 
https://issues.apache.org/jira/browse/TAJO-698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13948733#comment-13948733
 ] 

Keuntae Park commented on TAJO-698:
-----------------------------------

+1 
I love this patch and it works good!

Actually, I had a problem with the query like followings and it also works well 
now
{noformat}
select col1 from table1 where (case when col1 = '2014-03-21' then 1 else 0 end 
IN (1) )
{noformat}

> Error occurs when FUNCTION and IN statement are used together.
> --------------------------------------------------------------
>
>                 Key: TAJO-698
>                 URL: https://issues.apache.org/jira/browse/TAJO-698
>             Project: Tajo
>          Issue Type: Bug
>            Reporter: hyoungjunkim
>            Assignee: Hyunsik Choi
>             Fix For: 0.8-incubating, 1.0-incubating
>
>         Attachments: TAJO-698.patch
>
>
> See next tajo shell dump.
> {noformat}
> tajo> select * from lineitem_100 where substr(l_shipdate, 1,4) in ('2010', 
> '2011') limit 10;
> org.apache.tajo.algebra.FunctionExpr cannot be cast to 
> org.apache.tajo.algebra.ColumnReferenceExpr
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to