Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|Comment:||Add a test case demonstrating the collation problem with constant propagation.|
|Downloads:||Tarball | ZIP archive | SQL archive|
|Timelines:||family | ancestors | descendants | both | propagate-const-opt|
|Files:||files | file ages | folders|
|User & Date:||drh 2018-07-26 23:54:19|
|16:57||Constant propagation is now restricted to just the WHERE clause. The mechanism is changed to take affinity and collation into account. This seems to give correct answers. But the search for constant propagation costs 4 million cycles in the speed test. check-in: 82c67efb user: drh tags: propagate-const-opt|
|23:54||Add a test case demonstrating the collation problem with constant propagation. check-in: 50add839 user: drh tags: propagate-const-opt|
|23:47||Generalize the constant propagation optimization so that it applies on every WHERE close, not just those that contain a subquery. This then demonstrates that the current implementation is inadequate since it does not take into account collating sequences. check-in: 57eb2abd user: drh tags: propagate-const-opt|
Changes to test/whereL.test.