[jira] [Updated] (JCR-3911) Precedence error with AND NOT in JCR-SQL2

["Christian Kalkhoff (JIRA)" <ji...@apache.org>]

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