You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Benchao Li (Jira)" <ji...@apache.org> on 2023/05/20 13:39:00 UTC

[jira] [Created] (CALCITE-5717) Prune Project's input if project has no InputRef and the input has 1 row

Benchao Li created CALCITE-5717:
-----------------------------------

             Summary: Prune Project's input if project has no InputRef and the input has 1 row
                 Key: CALCITE-5717
                 URL: https://issues.apache.org/jira/browse/CALCITE-5717
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: Benchao Li
            Assignee: Benchao Li


The idea is to improve SQL
{code:sql}
select 1 from emps group ()
{code}
 
In this case, we can safely prune the Aggregate.

This idea is brought up in the discussion of CALCITE-5506



--
This message was sent by Atlassian Jira
(v8.20.10#820010)