[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Mueller updated OAK-2539: Fix Version/s: (was: 1.4) 1.3.11 > 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, query >Reporter: Calvin Wong >Assignee: Thomas Mueller > Fix For: 1.3.11 > > > 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)
[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Davide Giannella updated OAK-2539: -- Fix Version/s: (was: 1.3.9) 1.4 > 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, query >Reporter: Calvin Wong >Assignee: Davide Giannella > Fix For: 1.4 > > > 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)
[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Davide Giannella updated OAK-2539: -- Fix Version/s: (was: 1.3.7) 1.3.8 > 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, query >Reporter: Calvin Wong >Assignee: Davide Giannella > Fix For: 1.3.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)
[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Amit Jain updated OAK-2539: --- Fix Version/s: (was: 1.3.5) 1.3.6 > 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, query >Reporter: Calvin Wong >Assignee: Davide Giannella > Fix For: 1.3.6 > > > 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)
[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Davide Giannella updated OAK-2539: -- Fix Version/s: (was: 1.3.4) 1.3.5 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, query Reporter: Calvin Wong Assignee: Davide Giannella Fix For: 1.3.5 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)
[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Davide Giannella updated OAK-2539: -- Fix Version/s: (was: 1.3.3) 1.3.4 Bulk move to 1.3.4 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, query Reporter: Calvin Wong Assignee: Davide Giannella Fix For: 1.3.4 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)
[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Davide Giannella updated OAK-2539: -- Fix Version/s: (was: 1.3.2) 1.3.3 Bulk move to 1.3.3. 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, query Reporter: Calvin Wong Assignee: Davide Giannella Fix For: 1.3.3 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)
[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Davide Giannella updated OAK-2539: -- Fix Version/s: (was: 1.3.1) 1.3.2 Bulk move to 1.3.2 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, query Reporter: Calvin Wong Assignee: Davide Giannella Fix For: 1.3.2 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)
[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Davide Giannella updated OAK-2539: -- Fix Version/s: (was: 1.3.0) 1.3.1 Bulk move to 1.3.1 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, query Reporter: Calvin Wong Assignee: Davide Giannella Fix For: 1.3.1 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)
[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Davide Giannella updated OAK-2539: -- Fix Version/s: (was: 1.1.8) 1.3.0 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.3.0 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)
[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ 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)
[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ 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. 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')) 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 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. 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')) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] angela updated OAK-2539: Assignee: Davide Giannella 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 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 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)
[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michael Marth updated OAK-2539: --- Fix Version/s: 1.1.8 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. 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 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)
[jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
[ https://issues.apache.org/jira/browse/OAK-2539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marcel Reutegger updated OAK-2539: -- Component/s: (was: mongomk) core 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 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 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)