Hide Forgot
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.
Steve, can I get the actual query that you submitted with the NOT condition?
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')
Link: Added: This issue Cloned to SOA-2675
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
Tested with ER9 and closed.