Bugs item #2142522, was opened at 2008-10-02 16:28
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2142522&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: XML
Group: MonetDB4 4.24
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Floris Ouwendijk (floris233)
Assigned to: Nobody/Anonymous (nobody)
Summary: Duplicates when not using intermediary result
Initial Comment:
We've found a bug that causes results to be returned multiple times.
I've been able to reduce the data and query to manageable proportions, see
files below.
When you run the xquery script, it will return 8, while 4 is expected.
If the lines in the result that are commented are included, the correct result
is given, while all they do is count the number of items produced in
intermediary stages.
<testd>
<test a="1"><sub1/><sub2/></test>
<test a="1"><sub1/><sub2/></test>
<test a="1" b="1"><sub1/><sub2/></test>
<test a="1" b="1"><sub1/><sub2/></test>
<test b="1"><sub1/><sub2/></test>
<test b="1"><sub1/><sub2/></test>
<test><sub1/><sub2/></test>
<test><sub1/><sub2/></test>
</testd>
let $input1 := (doc("file:///path_to_test_xml")//test)
let $hits1 := (doc("file:///path_to_test_xml")//[EMAIL PROTECTED])
let $input2 := ($input1 intersect $hits1)
let $input3 := for $raw in $input2 where not(empty(for $t in $raw//* return
$t)) return $raw
let $hits3 := (doc("file:///path_to_test_xml")//[EMAIL PROTECTED])
let $result := ($input3 intersect $hits3)
return element result {
(:element input1 {count($input1)} ,
element hits1 {count($hits1)} ,
element input2 {count($input2)} ,
element input3 {count($input3)} ,
element hits3 {count($hits3)} ,:)
element result {count($result)}
}
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2142522&group_id=56967
-------------------------------------------------------------------------
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=/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
