[CALCITE-448] FilterIntoJoinRule creates filters containing invalid RexInputRef

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.2-incubating
• Fix Version/s: 1.0.0-incubating
• Assignee: Julian Hyde
• Reporter: Ashutosh Chauhan
• Created: 30/Oct/14 00:37
• Updated: 08/Feb/15 08:56
• Resolved: 27/Dec/14 08:06

Description

Filter should be allowed to be constructed even when types are INTEGER && INTEGER NOT NULL respectively. Currently, it fails with :

 java.lang.AssertionError: type mismatch:
type1:
INTEGER NOT NULL
type2:
INTEGER
	at org.eigenbase.relopt.RelOptUtil.eq(RelOptUtil.java:1566)
	at org.eigenbase.rex.RexProgramBuilder$RegisterInputShuttle.visitInputRef(RexProgramBuilder.java:899)
	at org.eigenbase.rex.RexProgramBuilder$RegisterInputShuttle.visitInputRef(RexProgramBuilder.java:878)
	at org.eigenbase.rex.RexInputRef.accept(RexInputRef.java:102)
	at org.eigenbase.rex.RexShuttle.visitList(RexShuttle.java:129)
	at org.eigenbase.rex.RexShuttle.visitCall(RexShuttle.java:78)
	at org.eigenbase.rex.RexProgramBuilder$RegisterShuttle.visitCall(RexProgramBuilder.java:843)
	at org.eigenbase.rex.RexProgramBuilder$RegisterShuttle.visitCall(RexProgramBuilder.java:841)
	at org.eigenbase.rex.RexCall.accept(RexCall.java:105)
	at org.eigenbase.rex.RexProgramBuilder.registerInput(RexProgramBuilder.java:272)
	at org.eigenbase.rex.RexProgramBuilder.addCondition(RexProgramBuilder.java:247)
	at org.eigenbase.relopt.RelOptUtil.pushFilterPastProject(RelOptUtil.java:2367)
	at org.eigenbase.rel.rules.PushFilterPastProjectRule.onMatch(PushFilterPastProjectRule.java:80)
	at org.eigenbase.relopt.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:321)
	at org.eigenbase.relopt.hep.HepPlanner.applyRule(HepPlanner.java:488)
	at org.eigenbase.relopt.hep.HepPlanner.applyRules(HepPlanner.java:365)
	at org.eigenbase.relopt.hep.HepPlanner.executeInstruction(HepPlanner.java:258)
	at org.eigenbase.relopt.hep.HepInstruction$RuleCollection.execute(HepInstruction.java:68)
	at org.eigenbase.relopt.hep.HepPlanner.executeProgram(HepPlanner.java:179)
	at org.eigenbase.relopt.hep.HepPlanner.findBestExp(HepPlanner.java:166)

Issue Links

• blocks: HIVE-8656 CBO: auto_join_filters fails