3 ms·
yup - strict tables is very welcome. This also is an interesting tidbit: "The query planner now omits ORDER BY clauses on subqueries and views if removing tho
by gigatexal 5y ago
yup - strict tables is very welcome.
This also is an interesting tidbit:
"The query planner now omits ORDER BY clauses on subqueries and views if removing those clauses does not change the semantics of the query."
Curious how it might improve queries -- I wonder how many folks were doing potentially redundant order by's in subqueries
- 41b696ef1113 5y agoThe order by optimization was a work-around for auto-generated SQL. The original (?) issue [0] [0] https://sqlite.org/forum/forumpost/2d76f2bcf65d256a https://sqlite.org/forum/forumpost/2d76f2bcf65d256a