SQL2 queries using OUTER JOIN and NAME or LOCALNAME throw NullPointerException | AEM6.2, Oak 1.4

Environment

AEM 6.2 + Oak 1.4.6 or earlier version

Issue

SQL2 queries that use OUTER JOIN and NAME or LOCALNAME result in a NullPointerException.

For example,

SELECT * FROM [cq:PageContent] AS page LEFT OUTER JOIN [nt:unstructured] AS component ON ISCHILDNODE(component,page) WHERE ISDESCENDANTNODE(page,[/content/geometrixx/en]) AND (NAME(component) = 'par')

Cause

Due to a bug in Oak (OAK-4658), outer join queries with the condition "name(joinSelector) = 'x'" or "localname(joinSelector) = 'x'" result in a NullPointerException.

Resolution

 Adobe

Krijg sneller en gemakkelijker hulp

Nieuwe gebruiker?

Adobe MAX 2024

Adobe MAX
De creativiteitsconferentie

14–16 oktober Miami Beach en online

Adobe MAX

De creativiteitsconferentie

14–16 oktober Miami Beach en online

Adobe MAX 2024

Adobe MAX
De creativiteitsconferentie

14–16 oktober Miami Beach en online

Adobe MAX

De creativiteitsconferentie

14–16 oktober Miami Beach en online