Le 21/04/2020 à 13:53, Wes McKinney a écrit : >> >> That said, in the SortToIndices case, this wouldn't be a problem, since >> only the second pass writes to the output. > > This kernel is not valid for normal array-exprs (see the spreadsheet I > linked), such as what you can write in SQL > > Kernels like SortToIndices are a different type of function (in other > words, "not a SQL function") and so if we choose to allow such a > "non-SQL-like" functions in the expression evaluator then different > logic must be used.
Hmm, I think that maybe I'm misunderstanding at which level we're talking here. SortToIndices() may not be a "SQL function", but it looks like an important basic block for a query engine (since, after all, sorting results is an often used feature in SQL and other languages). So it should be usable *inside* the expression engine, even though it's not part of the exposed vocabulary, no? Regards Antoine.
