/ Check-in [3bbd9c5f]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:New testcase() macros on virtual table xBestIndex logic.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:3bbd9c5f2f1990f7d187951474a86996650dcede12c2608484d43250ae0b30d6
User & Date: drh 2018-09-10 14:43:15
Context
2018-09-10
16:38
Fix a broken assert() in fts3.c. check-in: 564fa751 user: dan tags: trunk
14:43
New testcase() macros on virtual table xBestIndex logic. check-in: 3bbd9c5f 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: f191431d user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/where.c.

   972    972       ){
   973    973         /* An "IS" term in the WHERE clause where the virtual table is the rhs
   974    974         ** of a LEFT JOIN. Do not pass this term to the virtual table
   975    975         ** implementation, as this can lead to incorrect results from SQL such
   976    976         ** as:
   977    977         **
   978    978         **   "LEFT JOIN vtab WHERE vtab.col IS NULL"  */
          979  +      testcase( pTerm->eOperator & WO_ISNULL );
          980  +      testcase( pTerm->eOperator & WO_IS );
   979    981         continue;
   980    982       }
   981    983       assert( pTerm->u.leftColumn>=(-1) );
   982    984       pIdxCons[j].iColumn = pTerm->u.leftColumn;
   983    985       pIdxCons[j].iTermOffset = i;
   984    986       op = pTerm->eOperator & WO_ALL;
   985    987       if( op==WO_IN ) op = WO_EQ;