]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Simplify the query flattener so that it does not duplicate the WHERE clause
authordrh <drh@noemail.net>
Thu, 6 Dec 2018 19:15:36 +0000 (19:15 +0000)
committerdrh <drh@noemail.net>
Thu, 6 Dec 2018 19:15:36 +0000 (19:15 +0000)
commit11df7d2839a44e4814ebb110718e658c5ad9014a
tree906ae947c3fa7a5cf12bbab9d46923b9cc030f8c
parentd5b44d60c7c79ff828e790a6fe31c80cdf10e47c
Simplify the query flattener so that it does not duplicate the WHERE clause
of subquery that is being incorporated into the outer query - copies it
directly.  This is more efficient.  And it also fixes the specific test case
show for ticket [f09fcd17810f65f71789525] but it does not resolve the more
general problem that sqlite3ExprDup() does not correctly duplicate expressions
that contain subqueries with window functions.

FossilOrigin-Name: f1b18d44ff855573542c1947a42d4025dff54cacc13dac14d044521762ea9736
manifest
manifest.uuid
src/select.c
test/window1.test