[
https://issues.apache.org/jira/browse/JCR-3911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Christian Kalkhoff updated JCR-3911:
------------------------------------
Summary: Precedence error with AND NOT in JCR-SQL2 (was: Precedence error
with AND NOT in JCQ-SQL2 )
> Precedence error with AND NOT in JCR-SQL2
> ------------------------------------------
>
> Key: JCR-3911
> URL: https://issues.apache.org/jira/browse/JCR-3911
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Reporter: Christian Kalkhoff
>
> Querying the repository shows an at least unexpected behaviour.
> running
> SELECT * FROM [[my:type]] WHERE ISDESCENDANTNODE('/foo/bar') AND prop1 =
> 'foo' AND prop2 = 'bar' AND NOT prop3 = '' AND prop4 = 'jazz'
> will return all nodes that match prop1, prop2, prop3 but prop4 is ignored. So
> how far i can tell the NOT in AND NOT catches somehow the rest of the
> constraint. The spec seams to be unclear about it, from RDBMS' SQL i would
> say the behaviour is non-standard.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
