Fwd: ITQL bug?

[Will Panting]

Hello List,

I created a ITQL query that wasn't returning expected results.  I just want to bring this to everyone's attention in case anyone else has the issue or any insight.  Relevant issue: http://lists.mulgara.org/pipermail/mulgara-dev/2006-November/000225.html 

Here are three resource index queries that should all do similar things: 

BROKEN ITQL

select $object $title $content
from <#ri>
where (
  $object <fedora-model:label> $title
  and $object <fedora-model:hasModel> $content
  and (
    $content <fedora-model:hasModel> <info:fedora/islandora:collectionCModel>
    or
 $object <fedora-model:hasModel> <info:fedora/islandora:collectionCModel>
  )
)
order by $title;

WORKING ITQL

select $object $title $content
from <#ri>
where (
  (
    $object <fedora-model:label> $title
    and $object <fedora-model:hasModel> $content
    and $content <fedora-model:hasModel> <info:fedora/islandora:collectionCModel>
  )
  or
  (
    $object <fedora-model:label> $title
    and $object <fedora-model:hasModel> $content
    and $object <fedora-model:hasModel> <info:fedora/islandora:collectionCModel>
  )
)
order by $title;


WORKING SPARQL


PREFIX fedora_relations: <info:fedora/fedora-system:def/relations-external#>
PREFIX fedora_model: <info:fedora/fedora-system:def/model#>
PREFIX workflow: <info:islandora/islandora-system:def/islandora_workflow#>
SELECT $label $collection_object
FROM <#ri>
WHERE {
{
$collection_object fedora_model:hasModel $collection_content_model .
$collection_content_model fedora_model:hasModel <info:fedora/islandora:collectionCModel>
}
UNION
{
$collection_object fedora_model:hasModel <info:fedora/islandora:collectionCModel>
}
OPTIONAL
{
$collection_object fedora_model:label $label
}
}