[OAK-3416] Query: join on different property types fails

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.3.7, 1.4
• Component/s: query
• Assignee: Thomas Mueller
• Reporter: Thomas Mueller
• Created: 17/Sep/15 14:11
• Updated: 02/Mar/16 14:27
• Resolved: 18/Sep/15 11:54

Description

A join on properties with different node types, for example reference and string, does not work as expected. Example:

select [a].* from [nt:unstructured] as [a] 
inner join [nt:unstructured] as [b]
on [a].[jcr:uuid] = [b].[join] where issamenode([a], '/a')

The query works as expected if the property "join" is of type string, but not it is of type reference.