You are viewing a plain text version of this content. The canonical link for it is here.
Posted to oak-issues@jackrabbit.apache.org by "Calvin Wong (JIRA)" <ji...@apache.org> on 2015/02/20 00:34:12 UTC
[jira] [Created] (OAK-2539) SQL2 query not working with filter
(s.[stringa] = 'a' OR CONTAINS(s.[stringb], 'b'))
Calvin Wong created OAK-2539:
--------------------------------
Summary: 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: mongomk
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)