I'm not sure that you have duplicates - you have - "collection Aigle-21" and "Collection Aigle21" for collTitle - "teuchos collection Aigle-21" and "Teuchos Collection Aigle-21" for collDesc
ie, different capitalisation. If you make both these the same, you should end up with four rows -- but multiplying by 2x2 for these variants gives you the 16 rows you returned. You might be expecting only two results rows - but you seem to have two different subjects for each member also, so you'll get a separate row for each subject. By the way, it's easier to spot this sort of thing if you sort, ie add an order by clause, eg order by $collTitle $collDesc $memberID $member $memberTitle $memberSubject; that will make it a lot more obvious. Steve -----Original Message----- From: arne anka [mailto:[EMAIL PROTECTED] Sent: 12 November 2008 17:05 To: fedora-commons-users Subject: [Fedora-commons-users] iTQL: duplicates in risearch hi, fedora 2.2.4, mulgara for resource index. my query: select $collTitle $collDesc $member $memberTitle $memberSubject $memberID from <#ri> where <info:fedora/teuchosx:Aigle-21> <dc:title> $collTitle and <info:fedora/teuchosx:Aigle-21> <dc:description> $collDesc and $member <fedora-rels-ext:isMemberOf> <info:fedora/teuchosx:Aigle-21> and $member <dc:title> $memberTitle and $member <dc:subject> $memberSubject and $member <dc:identifier> $memberID the result i get: "collTitle","collDesc","member","memberTitle","memberSubject","memberID" collection Aigle-21,teuchos collection Aigle-21,info:fedora/teuchosx:305,Aigle-21m1.xml,Aigle,teuchosx:305 collection Aigle-21,teuchos collection Aigle-21,info:fedora/teuchosx:305,Aigle-21m1.xml,Adler,teuchosx:305 collection Aigle-21,teuchos collection Aigle-21,info:fedora/teuchosx:308,Aigle-21m2.xml,Aigle,teuchosx:308 collection Aigle-21,teuchos collection Aigle-21,info:fedora/teuchosx:308,Aigle-21m2.xml,Adler,teuchosx:308 collection Aigle-21,Teuchos Collection Aigle-21,info:fedora/teuchosx:305,Aigle-21m1.xml,Aigle,teuchosx:305 collection Aigle-21,Teuchos Collection Aigle-21,info:fedora/teuchosx:305,Aigle-21m1.xml,Adler,teuchosx:305 collection Aigle-21,Teuchos Collection Aigle-21,info:fedora/teuchosx:308,Aigle-21m2.xml,Aigle,teuchosx:308 collection Aigle-21,Teuchos Collection Aigle-21,info:fedora/teuchosx:308,Aigle-21m2.xml,Adler,teuchosx:308 Collection Aigle-21,teuchos collection Aigle-21,info:fedora/teuchosx:305,Aigle-21m1.xml,Aigle,teuchosx:305 Collection Aigle-21,teuchos collection Aigle-21,info:fedora/teuchosx:305,Aigle-21m1.xml,Adler,teuchosx:305 Collection Aigle-21,teuchos collection Aigle-21,info:fedora/teuchosx:308,Aigle-21m2.xml,Aigle,teuchosx:308 Collection Aigle-21,teuchos collection Aigle-21,info:fedora/teuchosx:308,Aigle-21m2.xml,Adler,teuchosx:308 Collection Aigle-21,Teuchos Collection Aigle-21,info:fedora/teuchosx:305,Aigle-21m1.xml,Aigle,teuchosx:305 Collection Aigle-21,Teuchos Collection Aigle-21,info:fedora/teuchosx:305,Aigle-21m1.xml,Adler,teuchosx:305 Collection Aigle-21,Teuchos Collection Aigle-21,info:fedora/teuchosx:308,Aigle-21m2.xml,Aigle,teuchosx:308 Collection Aigle-21,Teuchos Collection Aigle-21,info:fedora/teuchosx:308,Aigle-21m2.xml,Adler,teuchosx:308 playing around with the select arguments changes the number of duplicates: select $collTitle $collDesc $member $memberTitle $memberID ... results in: "collTitle","collDesc","member","memberTitle","memberID" collection Aigle-21,teuchos collection Aigle-21,info:fedora/teuchosx:305,Aigle-21m1.xml,teuchosx:305 collection Aigle-21,teuchos collection Aigle-21,info:fedora/teuchosx:308,Aigle-21m2.xml,teuchosx:308 collection Aigle-21,Teuchos Collection Aigle-21,info:fedora/teuchosx:305,Aigle-21m1.xml,teuchosx:305 collection Aigle-21,Teuchos Collection Aigle-21,info:fedora/teuchosx:308,Aigle-21m2.xml,teuchosx:308 Collection Aigle-21,teuchos collection Aigle-21,info:fedora/teuchosx:305,Aigle-21m1.xml,teuchosx:305 Collection Aigle-21,teuchos collection Aigle-21,info:fedora/teuchosx:308,Aigle-21m2.xml,teuchosx:308 Collection Aigle-21,Teuchos Collection Aigle-21,info:fedora/teuchosx:305,Aigle-21m1.xml,teuchosx:305 Collection Aigle-21,Teuchos Collection Aigle-21,info:fedora/teuchosx:308,Aigle-21m2.xml,teuchosx:308 select $collTitle $member $memberTitle $memberID ... "collTitle","member","memberTitle","memberID" collection Aigle-21,info:fedora/teuchosx:305,Aigle-21m1.xml,teuchosx:305 collection Aigle-21,info:fedora/teuchosx:308,Aigle-21m2.xml,teuchosx:308 Collection Aigle-21,info:fedora/teuchosx:305,Aigle-21m1.xml,teuchosx:305 Collection Aigle-21,info:fedora/teuchosx:308,Aigle-21m2.xml,teuchosx:308 removing any refernce to the collection from the select finally gives the correct answer: select $member $memberTitle $memberID ... "member","memberTitle","memberID" info:fedora/teuchosx:305,Aigle-21m1.xml,teuchosx:305 info:fedora/teuchosx:308,Aigle-21m2.xml,teuchosx:308 i removed $FEDORA_HOME/data/resourceIndex/ and ran fedora-rebuild.sh several times -- but it does not help. so, did i miss something, a configuration maybe? or is this a bug? ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Fedora-commons-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/fedora-commons-users ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Fedora-commons-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
