subject:"\[sqlite\] Group\-by and order\-by\-desc does not work as expected"

Re: [sqlite] Group-by and order-by-desc does not work as expected

2019-09-19 Thread Simon Slavin

On 19 Sep 2019, at 1:14pm, Fredrik Larsen wrote: > I have a aggregate query that works as expected when the ordering is > ascending, but uses a TMP B-TREE when changing order to descending, see > stackoverflow link below. For experimental purposes, you might take a backup copy of your database

[sqlite] Group-by and order-by-desc does not work as expected

2019-09-19 Thread Fredrik Larsen

I have a aggregate query that works as expected when the ordering is ascending, but uses a TMP B-TREE when changing order to descending, see stackoverflow link below. Is there something I'm missing? I would expect same performance when ordering both directions. Link: