Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|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)|