[TAJO-1013] A complex equality condition including columns of the same table is recognized as a join condition

• Type: Bug
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: Planner/Optimizer
• Assignee: Hyunsik Choi
• Reporter: Hyunsik Choi
• Created: 19/Aug/14 16:00
• Updated: 20/Aug/14 17:14
• Resolved: 20/Aug/14 17:14

Description

See the following example:

SELECT 
  t1.str1, t1.str2, t2.abc 
FROM 
  table1 t1, table2 t2 
WHERE t1.id = t2.id and substr(t1.str1, 1, 3) = substr(t1.str2, 1,3);

Currently, the expression substr(t1.str1, 1, 3) = substr(t1.str2, 1,3); is also addressed as a join condition. Since it includes columns of the same table, we shouldn't do it.