jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lukas Kahwe Smith <...@pooteeweet.org>
Subject limiting the selectors in the select list
Date Fri, 09 Dec 2011 10:54:44 GMT
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
mls@pooteeweet.org




Mime
View raw message