You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@jackrabbit.apache.org by "Thomas Mueller (JIRA)" <ji...@apache.org> on 2010/03/11 15:55:27 UTC
[jira] Created: (JCR-2564) SQL2 query: QOMFormatter create
incorrect NOT conditions
SQL2 query: QOMFormatter create incorrect NOT conditions
--------------------------------------------------------
Key: JCR-2564
URL: https://issues.apache.org/jira/browse/JCR-2564
Project: Jackrabbit Content Repository
Issue Type: Bug
Components: jackrabbit-jcr-commons
Reporter: Thomas Mueller
Assignee: Thomas Mueller
Then the following query is parsed:
SELECT test.* FROM test WHERE (NOT test.name = 'Hello') AND test.id = 3
then the SQL statement generated, it becomes:
SELECT test.* FROM test WHERE NOT test.name = 'Hello' AND test.id = 3
which is parsed differently and becomes:
SELECT test.* FROM test WHERE NOT (test.name = 'Hello' AND test.id = 3)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (JCR-2564) SQL2 query: QOMFormatter create
incorrect NOT conditions
Posted by "Jukka Zitting (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jukka Zitting updated JCR-2564:
-------------------------------
Fix Version/s: 2.1.0
(was: 2.0.1)
> SQL2 query: QOMFormatter create incorrect NOT conditions
> --------------------------------------------------------
>
> Key: JCR-2564
> URL: https://issues.apache.org/jira/browse/JCR-2564
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Components: jackrabbit-jcr-commons
> Reporter: Thomas Mueller
> Assignee: Thomas Mueller
> Fix For: 2.1.0
>
>
> Then the following query is parsed:
> SELECT test.* FROM test WHERE (NOT test.name = 'Hello') AND test.id = 3
> then the SQL statement generated, it becomes:
> SELECT test.* FROM test WHERE NOT test.name = 'Hello' AND test.id = 3
> which is parsed differently and becomes:
> SELECT test.* FROM test WHERE NOT (test.name = 'Hello' AND test.id = 3)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Resolved: (JCR-2564) SQL2 query: QOMFormatter create
incorrect NOT conditions
Posted by "Thomas Mueller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/JCR-2564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Mueller resolved JCR-2564.
---------------------------------
Resolution: Fixed
Fix Version/s: 2.0.1
> SQL2 query: QOMFormatter create incorrect NOT conditions
> --------------------------------------------------------
>
> Key: JCR-2564
> URL: https://issues.apache.org/jira/browse/JCR-2564
> Project: Jackrabbit Content Repository
> Issue Type: Bug
> Components: jackrabbit-jcr-commons
> Reporter: Thomas Mueller
> Assignee: Thomas Mueller
> Fix For: 2.0.1
>
>
> Then the following query is parsed:
> SELECT test.* FROM test WHERE (NOT test.name = 'Hello') AND test.id = 3
> then the SQL statement generated, it becomes:
> SELECT test.* FROM test WHERE NOT test.name = 'Hello' AND test.id = 3
> which is parsed differently and becomes:
> SELECT test.* FROM test WHERE NOT (test.name = 'Hello' AND test.id = 3)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.