[PHOENIX-3310] where clause optimization in join queries work not well

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.8.0
• Assignee: Unassigned
• Reporter: wangweiyi
• Created: 22/Sep/16 02:55
• Updated: 22/Sep/16 02:57

Description

select * from xxx x join yyy y on x.col1=y.col1 where x.col1='1'
select * from xxx x join yyy y on x.col1=y.col1 where y.col1='1'

the column "col1" is the primary key for table "xxx" and table "yyy"

the above SQL do full scan over either table "xxx" or "yyy". if the join compiler take where clause into account, this can be optimized.