You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Hyoungjun Kim (JIRA)" <ji...@apache.org> on 2014/05/14 14:39:14 UTC

[jira] [Created] (TAJO-830) Some filter conditions with a SUBQUERY are removed by optimizer.

Hyoungjun Kim created TAJO-830:
----------------------------------

             Summary: Some filter conditions with a SUBQUERY are removed by optimizer.
                 Key: TAJO-830
                 URL: https://issues.apache.org/jira/browse/TAJO-830
             Project: Tajo
          Issue Type: Bug
            Reporter: Hyoungjun Kim
            Priority: Minor


In the case of a next query, "col3 like '1993-11-24%';" condition removed by optimized. 
{code:sql}
select a.*
from (
    select 
    	L_RETURNFLAG as col1, 
    	L_EXTENDEDPRICE as col2, 
    	concat(L_RECEIPTDATE, L_LINESTATUS) as col3 
    from lineitem
) a
where col2 > 0 && col3 like '1993-11-24%';
{code}



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