Bug 780268 (SOA-2666)

Summary: NOT isn't handled properly
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Steven Hawkins <shawkins>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0.ER5CC: shawkins, vhalbert
Target Milestone: ---   
Target Release: 5.1.0.CR1   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2666
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-02-08 16:53:38 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Steven Hawkins 2010-12-09 22:05:30 UTC 
project_key: SOA

A ModeShape JCR SQL Query such as: SELECT g_0."jcr:name", g_0."jcr:path", g_0."jcr:primaryType", g_0."jcr:score", g_0."mode:depth", g_0."mode:localName" FROM "nt:base" AS g_0 WHERE ISCHILDNODE(g_0, 'foo')
that returns a subset of the rows, will return no rows when the condition is negated with a NOT.
Comment 1 Van Halbert 2010-12-09 22:57:10 UTC 
Steve, can I get the actual query that you submitted with the NOT condition?
Comment 2 Steven Hawkins 2010-12-10 01:33:01 UTC 
The translated query with not is:

SELECT g_0."jcr:name", g_0."jcr:path", g_0."jcr:primaryType", g_0."jcr:score", g_0."mode:depth", g_0."mode:localName" FROM "nt:base" AS g_0 WHERE NOT ISCHILDNODE(g_0, 'foo') 

submitted through Teiid as:

SELECT * from nt_base WHERE NOT JCR_ISCHILDNODE(nt_base.jcr_path, 'foo')
Comment 3 Van Halbert 2010-12-13 14:16:10 UTC 
Link: Added: This issue Cloned to SOA-2675
Comment 4 Anne-Louise Tangring 2010-12-14 19:02:16 UTC 
This will be investigated for SOA 5.1.0. Depending on severity of issue, we may or may not decide to fix it in SOA 5.1.0
Comment 7 Paul Nittel 2011-02-08 16:53:38 UTC 
Tested with ER9 and closed.