]> git.ipfire.org Git - thirdparty/sqlite.git/commit
If a subquery has an ORDER BY clause and that ordering is helpfile in
authordrh <>
Fri, 16 Aug 2024 18:51:46 +0000 (18:51 +0000)
committerdrh <>
Fri, 16 Aug 2024 18:51:46 +0000 (18:51 +0000)
commit65a46af7ae11ffe430519dec1aa8aee9c9281376
tree11f7e25266f018b0e2dbded1f36998f0370e6e3c
parentb8123415b2952793279bad794680c14e191d7ca5
parent2ed4f5016a591b5aaabe4a80fc073faab4ad907d
If a subquery has an ORDER BY clause and that ordering is helpfile in
satisfying the ORDER BY or GROUP BY of the outer query without doing an
extra sort, then omit or reduce the sort in the outer query.  Call
this the "order-by-subquery optimization".

FossilOrigin-Name: 7a0cdc7edb704a88a77b748cd28f6e00c49849cc2c1af838b95b34232ecc21f9
manifest
manifest.uuid