[jira] [Commented] (ASTERIXDB-2468) Projection pushdown is not performed correctly for COUNT()

["Chen Luo (JIRA)" <ji...@apache.org>]

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

Chen Luo commented on ASTERIXDB-2468:
-------------------------------------

[~dlychagin-cb] Can you confirm this is a correct behavior or a bug?

> Projection pushdown is not performed correctly for COUNT()
> ----------------------------------------------------------
>
>                 Key: ASTERIXDB-2468
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2468
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: COMP - Compiler
>            Reporter: Chen Luo
>            Priority: Major
>
> The following query performs projection pushdown correctly to project out records so that only pks are sorted:
> {code}
> select count(*) from (select * from %s.%s where sid>=%d AND sid<=%d order by id) tmp;
> {code}
> However, when a dataset variable is referenced by count(), projection pushdown is not working anymore and full records are sorted
> {code}
> select count(tmp) from (select * from %s.%s where sid>=%d AND sid<=%d order by id) tmp;
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)