jackrabbit-oak-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Calvin Wong (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (OAK-2539) SQL2 query not working with filter (s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
Date Wed, 11 Mar 2015 18:09:38 GMT

     [ 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)

Mime
View raw message