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)