]> git.ipfire.org Git - thirdparty/sqlite.git/commit
When flattening a query of the form "SELECT * FROM (SELECT * FROM tbl WHERE x=?)...
authordan <dan@noemail.net>
Mon, 26 Sep 2016 14:39:05 +0000 (14:39 +0000)
committerdan <dan@noemail.net>
Mon, 26 Sep 2016 14:39:05 +0000 (14:39 +0000)
commit4c5ebee0b569bc0063ca76c35193454844a81adb
tree1e37f82c0534434a59fc024a2612e1126e006a80
parent0cd874bd5723fd95ffe69ab7f843ad7cfdc3671f
When flattening a query of the form "SELECT * FROM (SELECT * FROM tbl WHERE x=?) WHERE y=?", ensure that the final WHERE clause is "x=? AND y=?" instead of "y=? AND x=?". Although it is still not guaranteed, this makes the order in which WHERE clause terms are processed comport more closely to users expectations.

FossilOrigin-Name: cf7f9e6d5abff273dd2f8a8dce27d52e1449b3be
manifest
manifest.uuid
src/select.c