[ https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Calvin Wong updated OAK-2539: ----------------------------- Description: Create node /content/usergenerated/qtest with jcr:primaryType nt:unstrucuted. Add 2 String properties: stringa = "a", stringb = "b". Use query tool in CRX/DE to do SQL2 search: This search will find qtest: SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/usergenerated/]) AND (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b')) This search will find qtest: SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/usergenerated/]) AND (CONTAINS(s.[stringb], 'b')) This search will not find qtest: SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/usergenerated/]) AND (s.[stringa] = 'x' OR CONTAINS(s.[stringb], 'b')) was: Create node /content/usergenerated/qtest with jcr:primaryType nt:unstrucuted. Add 2 String properties: stringa = "a", stringb = "b". User query tool in CRX/DE to do SQL2 search: This search will find qtest: SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/usergenerated/]) AND (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b')) This search will find qtest: SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/usergenerated/]) AND (CONTAINS(s.[stringb], 'b')) This search will not find qtest: SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/usergenerated/]) AND (s.[stringa] = 'x' OR CONTAINS(s.[stringb], 'b')) > SQL2 query not working with filter (s.[stringa] = 'a' OR > CONTAINS(s.[stringb], 'b')) > ------------------------------------------------------------------------------------ > > Key: OAK-2539 > URL: https://issues.apache.org/jira/browse/OAK-2539 > Project: Jackrabbit Oak > Issue Type: Bug > Components: core > Reporter: Calvin Wong > Assignee: Davide Giannella > Fix For: 1.1.8 > > > Create node /content/usergenerated/qtest with jcr:primaryType nt:unstrucuted. > Add 2 String properties: stringa = "a", stringb = "b". > Use query tool in CRX/DE to do SQL2 search: > This search will find qtest: > SELECT * FROM [nt:base] AS s WHERE > ISDESCENDANTNODE([/content/usergenerated/]) AND (s.[stringa] = 'a' OR > CONTAINS(s.[stringb], 'b')) > This search will find qtest: > SELECT * FROM [nt:base] AS s WHERE > ISDESCENDANTNODE([/content/usergenerated/]) AND (CONTAINS(s.[stringb], 'b')) > This search will not find qtest: > SELECT * FROM [nt:base] AS s WHERE > ISDESCENDANTNODE([/content/usergenerated/]) AND (s.[stringa] = 'x' OR > CONTAINS(s.[stringb], 'b')) -- This message was sent by Atlassian JIRA (v6.3.4#6332)