/ Check-in [77c692a6]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

Overview
Comment:Fix typos in comments. No changes to code.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 77c692a6704cd877ba35d0afb774ab9b46364d59
User & Date: mistachkin 2016-07-10 19:35:10
Context
2016-07-12
19:54
Fix the error counter reset in Lemon generated parsers. This has no effect on SQLite. check-in: 3ef93950 user: drh tags: trunk
2016-07-10
19:35
Merge comment typo fixes from trunk. check-in: 728c5aa4 user: mistachkin tags: rowvalue
19:35
Fix typos in comments. No changes to code. check-in: 77c692a6 user: mistachkin tags: trunk
2016-07-09
17:47
Add the "#/value-list/" style of results for approximate value matching in the do_test command of the test infrastructure. Use this new result style to make the SQLITE_DBSTATUS_CACHE_SIZE_SHARED tests cross-platform. check-in: c869bf34 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/expr.c.

  1831   1831         }
  1832   1832       }
  1833   1833     }
  1834   1834   
  1835   1835     /* If no preexisting index is available for the IN clause
  1836   1836     ** and IN_INDEX_NOOP is an allowed reply
  1837   1837     ** and the RHS of the IN operator is a list, not a subquery
  1838         -  ** and the RHS is not contant or has two or fewer terms,
         1838  +  ** and the RHS is not constant or has two or fewer terms,
  1839   1839     ** then it is not worth creating an ephemeral table to evaluate
  1840   1840     ** the IN operator so return IN_INDEX_NOOP.
  1841   1841     */
  1842   1842     if( eType==0
  1843   1843      && (inFlags & IN_INDEX_NOOP_OK)
  1844   1844      && !ExprHasProperty(pX, EP_xIsSelect)
  1845   1845      && (!sqlite3InRhsIsConstant(pX) || pX->x.pList->nExpr<=2)

Changes to src/wherecode.c.

   565    565   ** set P3 and P5 on the OP_String opcode so that the string will be cast
   566    566   ** to a BLOB at appropriate times.
   567    567   **
   568    568   ** The LIKE optimization trys to evaluate "x LIKE 'abc%'" as a range
   569    569   ** expression: "x>='ABC' AND x<'abd'".  But this requires that the range
   570    570   ** scan loop run twice, once for strings and a second time for BLOBs.
   571    571   ** The OP_String opcodes on the second pass convert the upper and lower
   572         -** bound string contants to blobs.  This routine makes the necessary changes
          572  +** bound string constants to blobs.  This routine makes the necessary changes
   573    573   ** to the OP_String opcodes for that to happen.
   574    574   **
   575    575   ** Except, of course, if SQLITE_LIKE_DOESNT_MATCH_BLOBS is defined, then
   576    576   ** only the one pass through the string space is required, so this routine
   577    577   ** becomes a no-op.
   578    578   */
   579    579   static void whereLikeOptimizationStringFixup(