[
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)