Grouping and sorting
Saturday, 14 August 2010 · 3 messages · last reply 27 Aug 2010
R
reference14 Aug 2010 10:37 #
XQuery:
let $type :=
<type>
<item id="id1"><value>3</value></item>
<item id="id2"><value>3</value></item>
<item id="id3"><value>6</value></item>
<item id="id4"><value>5</value></item>
<item id="id5"><value>5</value></item>
</type>
for $i in $type/item
let $v := $i/value
group by $v
order by $v return $vResult in BaseX:
<value>3</value>
<value>5</value>
<value>5</value>As I understand XQuery the result should be as follows:
<value>3</value>
<value>5</value>
<value>6</value>Where ist my mistake or is it a bug in BaseX?
MS
Michael Seiferle14 Aug 2010 10:39 #
Hi there,
(group by as well as) sorting among groups is not yet (fully) implemented, but expect it to be done soon.
Kind regards
Michael
Quoted text · reference · 31 lines
Am 14.08.2010 um 10:37 schrieb reference at gmx.de: > XQuery: > let $type := > <type> > <item id="id1"><value>3</value></item> > <item id="id2"><value>3</value></item> > <item id="id3"><value>6</value></item> > <item id="id4"><value>5</value></item> > <item id="id5"><value>5</value></item> > </type> > > for $i in $type/item > let $v := $i/value > group by $v > order by $v return $v > > Result in BaseX: > <value>3</value> > <value>5</value> > <value>5</value> > > As I understand XQuery the result should be as follows: > <value>3</value> > <value>5</value> > <value>6</value> > > Where ist my mistake or is it a bug in BaseX? > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk at mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk
MS
Michael Seiferle27 Aug 2010 16:01 #
Hi there,
you could give the latest repository version [1] a try.
While I am not yet fully done with implementing your query should run fine now. Feedback is very much appreciated.
Kind regards
Michael
[1] http://www.inf.uni-konstanz.de/dbis/basex/install
Quoted text · Michael Seiferle · 36 lines
Am 14.08.2010 um 10:39 schrieb Michael Seiferle: > Hi there, > (group by as well as) sorting among groups is not yet (fully) implemented, but expect it to be done soon. > > Kind regards > Michael > > Am 14.08.2010 um 10:37 schrieb reference at gmx.de: > >> XQuery: >> let $type := >> <type> >> <item id="id1"><value>3</value></item> >> <item id="id2"><value>3</value></item> >> <item id="id3"><value>6</value></item> >> <item id="id4"><value>5</value></item> >> <item id="id5"><value>5</value></item> >> </type> >> >> for $i in $type/item >> let $v := $i/value >> group by $v >> order by $v return $v >> >> Result in BaseX: >> <value>3</value> >> <value>5</value> >> <value>5</value> >> >> As I understand XQuery the result should be as follows: >> <value>3</value> >> <value>5</value> >> <value>6</value> >> >> Where ist my mistake or is it a bug in BaseX? >
Written for BaseX 6. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery