Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | New testcase() macros on virtual table xBestIndex logic. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
3bbd9c5f2f1990f7d187951474a86996 |
| User & Date: | drh 2018-09-10 14:43:15.694 |
Context
|
2018-09-10
| ||
| 16:38 | Fix a broken assert() in fts3.c. (check-in: 564fa75195 user: dan tags: trunk) | |
| 14:43 | New testcase() macros on virtual table xBestIndex logic. (check-in: 3bbd9c5f2f user: drh tags: trunk) | |
| 12:40 | Fix the LIKE optimization so that it is disabled when the LHS of the expression does not have TEXT affinity and the RHS is the pattern '/%' or the RHS begins with the escape character. Fix for ticket [c94369cae9b561b1f996d0054b]. (check-in: f191431d63 user: drh tags: trunk) | |
Changes
Changes to src/where.c.
| ︙ | |||
972 973 974 975 976 977 978 979 980 981 982 983 984 985 | 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 | + + |
){
/* An "IS" term in the WHERE clause where the virtual table is the rhs
** of a LEFT JOIN. Do not pass this term to the virtual table
** implementation, as this can lead to incorrect results from SQL such
** as:
**
** "LEFT JOIN vtab WHERE vtab.col IS NULL" */
testcase( pTerm->eOperator & WO_ISNULL );
testcase( pTerm->eOperator & WO_IS );
continue;
}
assert( pTerm->u.leftColumn>=(-1) );
pIdxCons[j].iColumn = pTerm->u.leftColumn;
pIdxCons[j].iTermOffset = i;
op = pTerm->eOperator & WO_ALL;
if( op==WO_IN ) op = WO_EQ;
|
| ︙ |