SQLite Forum

Should SQLite be able to optimize this query?
Login
I don't see that that really helps.  Because I still need to deal with
(omit the optimization from) this case:

> ~~~~
SELECT count(*) FROM (SELECT sideeffectfunc(x) FROM table ORDER BY x);
~~~~