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)
