6243 2008-11-19 23:38:59 +0000 [XQuery11UC] windowing use case Q8: wrong expected result 2009-02-17 15:41:07 +0000 1 1 1 Unclassified XPath / XQuery / XSLT XQuery 3.0 Use Cases Working drafts PC Linux RESOLVED FIXED P2 normal --- 1 xfranc tim jim.melton public-qt-comments oldest_to_newest 22483 0 xfranc 2008-11-19 23:38:59 +0000 Too many items. Should be: <result> <working-time> <person>Anton</person> <time>PT4H30M</time> </working-time> <working-time> <person>Barbara</person> <time>PT3H</time> </working-time> <working-time> <person>Clara</person> <time>PT1H</time> </working-time> <working-time> <person>Anton</person> <time>PT5H</time> </working-time> <working-time> <person>Clara</person> <time>PT4H15M</time> </working-time> </result> 23796 1 tim 2009-02-17 15:41:07 +0000 I changed the input data to address query Q13 to <?xml version="1.0" encoding="UTF-8"?> <stream xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="person_events.xsd"> <event time="2006-01-01T01:00:00-00:00"/> <event time="2006-01-01T10:30:00-00:00"> <person>Anton</person> <direction>in</direction> </event> <event time="2006-01-01T11:00:00-00:00"> <person>Barbara</person> <direction>in</direction> </event> <event time="2006-01-01T11:15:00-00:00"> <person>Clara</person> <direction>in</direction> </event> <event time="2006-01-01T12:15:00-00:00"> <person>Clara</person> <direction>out</direction> </event> <event time="2006-01-01T14:00:00-00:00"> <person>Barbara</person> <direction>out</direction> </event> <event time="2006-01-01T15:00:00-00:00"> <person>Anton</person> <direction>out</direction> </event> <event time="2006-01-01T23:00:00-00:00"/> <event time="2006-01-02T01:00:00-00:00"/> <event time="2006-01-02T11:00:00-00:00"> <person>Anton</person> <direction>in</direction> </event> <event time="2006-01-02T12:00:00-00:00"> <person>Clara</person> <direction>in</direction> </event> <event time="2006-01-02T12:10:00-00:00"> <person>Clara</person> <direction>out</direction> </event> <event time="2006-01-02T12:15:00-00:00"> <person>Clara</person> <direction>in</direction> </event> <event time="2006-01-02T12:20:00-00:00"> <person>Clara</person> <direction>out</direction> </event> <event time="2006-01-02T12:25:00-00:00"> <person>Clara</person> <direction>in</direction> </event> <event time="2006-01-02T12:40:00-00:00"> <person>Clara</person> <direction>out</direction> </event> <event time="2006-01-02T14:00:00-00:00"> <person>Clara</person> <direction>in</direction> </event> <event time="2006-01-02T16:00:00-00:00"> <person>Anton</person> <direction>out</direction> </event> <event time="2006-01-02T16:15:00-00:00"> <person>Clara</person> <direction>out</direction> </event> <event time="2006-01-02T23:00:00-00:00"/> </stream> Hence, the result is now: <result> <working-time> <person>Anton</person> <time>PT4H30M</time> </working-time> <working-time> <person>Barbara</person> <time>PT3H</time> </working-time> <working-time> <person>Clara</person> <time>PT1H</time> </working-time> <working-time> <person>Anton</person> <time>PT5H</time> </working-time> <working-time> <person>Clara</person> <time>PT10M</time> </working-time> <working-time> <person>Clara</person> <time>PT5M</time> </working-time> <working-time> <person>Clara</person> <time>PT15M</time> </working-time> <working-time> <person>Clara</person> <time>PT4H15M</time> </working-time> </result> I'm marking this bug FIXED. Xaviar, if you agree with the solution, please mark it CLOSED.