Bugs item #3540329, was opened at 2012-07-04 15:44 Message generated for change (Comment added) made by shcheklein You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=713730&aid=3540329&group_id=129076
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: Query Execution Group: Sedna (current) Status: Open Resolution: None Priority: 5 Private: No Submitted By: https://www.google.com/accounts () Assigned to: Nobody/Anonymous (nobody) Summary: Error in XQuery fn:max Initial Comment: Please remove Bug ID 3540327 (this is the complete report) The query running against document (cf attached file) returns : <entry finess="300007119" datefin="2011-11-30"> <entry>2012-07-04T23:32:34.632+02:00</entry> </entry> <entry finess="300007119" datefin="2012-05-31"> <entry>2012-07-04T23:32:39.59+02:00</entry> </entry> <entry finess="340780600" datefin="2011-11-30"/> <entry finess="340780600" datefin="2012-05-31"/> But an entry is missing, it should return <entry finess="340780600" datefin="2012-05-31"> <entry>2012-07-04T23:32:16.906+02:00</entry> </entry> <entry finess="340780600" datefin="2011-11-30"/> <entry finess="300007119" datefin="2012-05-31"> <entry>2012-07-04T23:32:39.59+02:00</entry> <======================== Here is the missing line </entry> <entry finess="300007119" datefin="2011-11-30"> <entry>2012-07-04T23:32:34.632+02:00</entry> </entry> Running Sedna on Windows Seven (from sedna-3.5.161-bin-win-x86.tar.gz) ---------------------------------------------------------------------- >Comment By: Ivan Shcheklein (shcheklein) Date: 2012-07-05 07:40 Message: Please, try on the latest development build: http://modis.ispras.ru/FTPContent/sedna/development/ ---------------------------------------------------------------------- Comment By: Ivan Shcheklein (shcheklein) Date: 2012-07-05 07:35 Message: Query: let $items:=fn:document("test")/test/(RSF2009 | RSF2012)/content/RsfHeader for $l in distinct-values($items/@Finess/string()), $m in distinct-values($items/@DateFin/string()) let $items2:=fn:document("test")/test/(RSF2009 | RSF2012)/content[RsfHeader/@Finess = $l and RsfHeader/@DateFin = $m] let $oi:=fn:max($items2/@insertionTimeStamp cast as xs:dateTime?) return <entry finess="{$l}" datefin="{$m}"> { for $p in $oi return <entry>{$p}</entry> } </entry> ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=713730&aid=3540329&group_id=129076 ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Sedna-discussion mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sedna-discussion
