Details
-
Bug
-
Resolution: Done
-
Major
-
None
-
None
-
None
Description
1) Create a 2-level hierarchy of nodes with 2 int properties - foo & bar.
The following query should work:
"SELECT a.foo AS aVal, b.bar AS bVal FROM [nt:unstructured] AS a INNER JOIN [nt:unstructured] AS b ON a.foo = b.bar WHERE a.foo = " + fooValue;
but results in the following error:
javax.jcr.RepositoryException: Column 'foo' does not exist on the table '__ALLNODES__'
2) Create a 3-level hierarchy of nodes with 3 int properties - foo , bar & baz
The following query should work:
"SELECT a.foo AS aVal, b.bar AS bVal, c.baz AS cVal FROM [nt:unstructured] AS a INNER JOIN [nt:unstructured] AS b ON a.foo = b.bar INNER JOIN [nt:unstructured] AS c ON b.bar = c.baz WHERE a.foo = " + randFooValue;
but results in the following error:
javax.jcr.RepositoryException: Column 'foo' does not exist on the table '__ALLNODES__'