Hi,

While doing some tests, I noticed an unexpected query result in Basex 9.6.3 (on Windows 10).

This query:

let $ids := for $i in 1 to 10 return random:uuid()
for $id in $ids
order by $id
return $id

... returns 10 UUIDs, but they are not sorted.

Information from the Info pane in the GUI:

Compiling:
- rewrite range expression to range sequence: (1 to 10)
- rewrite simple map to util:replicate(items,count[,multiple]): (1 to 10) ! random:uuid() -> util:replicate(random:uuid(), 10, true())
- inline for $i_1 in (1 to 10)
- simplify FLWOR expression: util:replicate(random:uuid(), 10, true())
- inline let $ids_0 := util:replicate(random:uuid(), 10, true())
- rewrite fn:sort(items[,collation[,function]]) to util:replicate(items,count[,multiple]): sort(util:replicate(random:uuid(), 10, true())) -> util:replicate(random:uuid(), 10, true())
- inline for $id_2 in util:replicate(random:uuid(), 10, true())
- simplify FLWOR expression: util:replicate(random:uuid(), 10, true())
Optimized Query:
util:replicate(random:uuid(), 10, true())

In Basex 9.3.2 (on another Windows machine) items are sorted alphabetically, as I would expect them to be – but I may be overlooking something.

Any ideas?

Thanks,
Tom De Herdt