took it for a spin in local dev environment, at least our test suite has no regressions

and xtdb-inspector works as well, no problems so far

that's great to hear, thank you 🙂

I’m getting the following error:

; Execution error (IllegalArgumentException) at xtdb.error/illegal-arg (error.clj:12).
; Order by requires an element from :find. unreturned element: [:logic-var ?ts]

(xt/q (xt/db mem-node)
        '{:find [(pull ?trade [* {:trade/market [*]}])]
          :where [[?trade :trade/id _]
                  [?trade :trade/timestamp ?ts]]
          :order-by [[?ts :asc]]
          :limit 10})

Hey @U6CN6JQ22 I think you just need to include ?ts in your :find so that the order-by kicks in, but ignore it from the tuples when processing the results, i.e.

(xt/q (xt/db mem-node)
        '{:find [(pull ?trade [* {:trade/market [*]}]) ?ts]
          :where [[?trade :trade/id _]
                  [?trade :trade/timestamp ?ts]]
          :order-by [[?ts :asc]]
          :limit 10})

that worked, thanks!