[CALCITE-993] Predicate Pull up above Project enhancement

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.0
• Fix Version/s: 1.6.0
• Component/s: core
• Assignee: Laljo John Pullokkaran
• Reporter: Laljo John Pullokkaran
• Created: 25/Nov/15 23:32
• Updated: 21/Jan/16 22:20
• Resolved: 05/Dec/15 03:52

Description

Predicate Pull up on Project can also pull up deterministic functions whose arguments are all literals.

Ex: select r1.x from (select cast('10' as int) as x, y from r1 where y<10)r1 join r2 on r1.x=r2.x;

Currently deterministic functions involving constants are ignored which results in missed transitive inference.

Issue Links

• links to: PR 170