Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|Comment:||Enhance the LIKE optimization so that it works for arbitrary expressions on the LHS as long as the pattern on the RHS does not begin with a digit or a minus sign.|
|Downloads:||Tarball | ZIP archive | SQL archive|
|Timelines:||family | ancestors | descendants | both | trunk|
|Files:||files | file ages | folders|
|User & Date:||drh 2017-02-10 21:37:57|
|12:28||Refactor the LIKE optimization decision logic so that it uses sqlite3AtoF() on both boundary keys to determine if the optimization can be used when the LHS is something that might not have TEXT affinity. Ticket [ce8717f0885af975]. See also [c94369cae9b561b1], [b043a54c3de54b28], [fd76310a5e843e07], and [158290c0abafde67]. check-in: b4a9e09e user: drh tags: trunk|
|19:21||• New ticket [b9f01010] Violation of the Query Planner Stability Guarantee. artifact: 81c613f2 user: drh|
|02:04||Fix a test case that was made to fail by the LIKE optimization enhancement in check-in [158290c0ab] but which went unnoticed because test builds were running with ICU enabled and ICU disables the LIKE optimization. check-in: 218b2bbb user: drh tags: trunk|
|21:40||Bump the version number up to 3.18.0. check-in: 7520c238 user: drh tags: trunk|
|21:37||Enhance the LIKE optimization so that it works for arbitrary expressions on the LHS as long as the pattern on the RHS does not begin with a digit or a minus sign. check-in: 158290c0 user: drh tags: trunk|
|19:38||Add the "," flag to printf(). check-in: 064445b1 user: drh tags: trunk|
Changes to src/whereexpr.c.
Changes to test/vtab1.test.
Changes to test/vtabH.test.