[jira] [Commented] (CALCITE-1056) Simplify predicate of JOIN, and optimize away LIMIT 0

["Julian Hyde (JIRA)" <ji...@apache.org>]

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

Julian Hyde commented on CALCITE-1056:
--------------------------------------

Work in progress: https://github.com/julianhyde/calcite/tree/1056-simplify.

CALCITE-1054 is similar, lower ambition level, and should make it into release 1.6. This case will have to wait until 1.7.

> Simplify predicate of JOIN, and optimize away LIMIT 0
> -----------------------------------------------------
>
>                 Key: CALCITE-1056
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1056
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Julian Hyde
>            Assignee: Julian Hyde
>
> Following CALCITE-996, RelBuilder should simplify predicates in other situations, such as the {{and}} method and the {{join}} method.
> {{RelBuilder.filter(false)}} and {{RelBuilder.limit(0, 0)}} should simplify to {{RelBuilder.empty()}}, a new method that returns an empty relation. The default implementation returns a {{Values}} with no rows, but schema-on-query systems such as Drill might override the {{empty}} method.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)