[Sedna-discussion] [ sedna-Bugs-3540329 ] Error in XQuery fn:max

[SourceForge.net <no...@so...>]

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