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

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

Chen Luo created ASTERIXDB-2468:
-----------------------------------

             Summary: 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


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)