[PHOENIX-816] 'Like' and comparisons don't work with Joins

• Type: Task
• Status: Open
• Resolution: Unresolved
• old issue number: 685
• Assignee: Unassigned
• Reporter: alex kamil
• Created: 10/Mar/14 23:48
• Updated: 10/Mar/14 23:48

Description

looks like only equality clauses are supported (ON a.column=b.column), but not something like this:

SELECT *
FROM TABLE a
JOIN TABLE b ON b.column LIKE '%'+ a.column +'%'

or

SELECT *
FROM TABLE a
JOIN TABLE b ON b.column >a.column