On Sun, Sep 14, 2014 at 11:47 AM, Keith Medcalf <kmedc...@dessus.com> wrote:
> > Yes, the max(y) operation is flattened out of the query probably because > it is not referenced anywhere and the optimizer does not see that it is > performing any useful function. There is still only one row returned, > however, because the same accumulator is used to collect the result, it > just operates on all rows instead of only those which set the max() return > value. > An accurate and succinct summary of the issue. The question now: what to do about it. I'll save that question for a workday... -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users