]> git.ipfire.org Git - thirdparty/sqlite.git/commit
In the push-down optimization, do not substitute columns that have previously branch-3.31
authordrh <drh@noemail.net>
Sat, 4 Apr 2020 00:29:18 +0000 (00:29 +0000)
committerdrh <drh@noemail.net>
Sat, 4 Apr 2020 00:29:18 +0000 (00:29 +0000)
commit415ae35ee2db59df4a9a763f3d78f82dc1ab19df
treed919c54656a811544d9cc78a4c58e3f8a4876f9a
parentc40d2db7ec62ccb6d7242e07525faa6700d0520e
In the push-down optimization, do not substitute columns that have previously
been identified as being constant by the propagate-constants optimization.
Fix for ticket [51166be0159fd2ce].
Also, avoid factoring out constant expressions on the LHS of an IN(...)
operator, as the IN(...) operation may affect the affinity of these values.
Fix for [fd1bda016d1].

FossilOrigin-Name: 43612157f87f7365cdb6d77ca3f1e06efd64ce023fb6825bbd3895265cc10f51
manifest
manifest.uuid
src/expr.c
src/select.c
test/cse.test
test/select4.test