Hi,
I am wondering if this is a bug or a feature.
I have a query with a join. notice the SELECT data.*
SELECT
data.*
FROM
[nzz:unstructured] AS data
LEFT OUTER JOIN [nzz:unstructured] AS referring ON referring.reference =
data.[jcr:uuid]
WHERE
(referring.reference IS NOT NULL AND ISDESCENDANTNODE(referring,
'/article/2011/12/08'))
OR
ISDESCENDANTNODE(data, '/article/2011/12/08')
But I actually end up with rows like the following, aka 'referring' is still
listed.
0 =>
array (size=2)
'dcr:name' => string 'data.jcr:primaryType' (length=20)
'dcr:value' => string 'nzz:unstructured' (length=16)
1 =>
array (size=3)
'dcr:name' => string 'jcr:path' (length=8)
'dcr:value' => string '/article/2011/12/07/N_IYFNM' (length=27)
'dcr:selectorName' => string 'data' (length=4)
2 =>
array (size=3)
'dcr:name' => string 'jcr:score' (length=9)
'dcr:value' => string '5.163787364959717' (length=17)
'dcr:selectorName' => string 'data' (length=4)
3 =>
array (size=3)
'dcr:name' => string 'jcr:path' (length=8)
'dcr:value' => string '/article/2011/12/08/N_IYFNM' (length=27)
'dcr:selectorName' => string 'referring' (length=9)
4 =>
array (size=3)
'dcr:name' => string 'jcr:score' (length=9)
'dcr:value' => string '2.3243303298950195' (length=18)
'dcr:selectorName' => string 'referring' (length=9)
I guess I need to debug this some more a level lower (aka check what
specifically I get returned via Davex) to see if there is a sensible way to
determine when to ignore these columns. But either way its a bit annoying from
my perspective that this data is being returned even though I specifically
ignored it in the select list.
regards,
Lukas Kahwe Smith
[email protected]
