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/16 13:23:51 UTC
[jira] [Assigned] (TAJO-830) Some filter conditions with a SUBQUERY
are removed by optimizer.
[ https://issues.apache.org/jira/browse/TAJO-830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyoungjun Kim reassigned TAJO-830:
----------------------------------
Assignee: Hyoungjun Kim
> 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
> Assignee: 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)