[CALCITE-1056] Simplify predicate of JOIN, and optimize away LIMIT 0

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.7.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 14/Jan/16 00:55
• Updated: 22/Mar/16 01:18
• Resolved: 22/Jan/16 07:40

Description

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.