Search query not working after AEM 6.5 upgrade

[ashishkhadpe]

Hi Everyone,

We have recently upgraded from AEM 6.2 to 6.5. When we tested the search functionality, we encountered that few of our queries are not executing and throwing an error.

I am pasting one query here for reference : 

select [jcr:path], [jcr:score], [rep:excerpt] from [nt:hierarchyNode] as a where isdescendantnode(a, '/content') and [jcr:content/hideFromSearch] is null and contains([jcr:content/*], 'Media')

Error we can see in logs and on query performance tool is : 

If we change some predicate like below the query works : 

select [jcr:path], [jcr:score], [rep:excerpt] from [nt:hierarchyNode] as a where isdescendantnode(a, '/content') and [jcr:content/hideFromSearch] = 'false' and contains([jcr:content/*], 'Media')

[Singaiah_Chintalapudi]

Looks like some structural changes on AEM 6.5. We've faced similar issues (not same as below) and modifying the predicates to fix these issues.

Thanks,

Singaiah

[ashishkhadpe]

But when I execute the same query on plain vanilla AEM 6.5 instance it works fine(doesn't throw any error)

[Singaiah_Chintalapudi]

I haven't tested on plain instance but seeing this issue on > 6.5.5

[ashishkhadpe]

I tried executing the query on 6.5.6 as well and it worked fine. Can you please let me know what issue you see in predicates?