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.