/ Check-in [a758465e]
Login

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

Overview
Comment:Fix a couple of 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: a758465e3cfa7e0cb8749d097cd6fb5f86b60955
User & Date: mistachkin 2014-09-06 02:00:41
Context
2014-09-06
03:16
Add the sqlite3_memdebug_title_count global variable, used during debugging to count the number of invocations of test_memdebug_settitle. By examining this variable in the debugger after a segfault, one can then set a breakpoint on test_memdebug_settitle that will fire just before the problem. check-in: 27e3ca3e user: drh tags: trunk
02:00
Fix a couple of typos in comments. No changes to code. check-in: a758465e user: mistachkin tags: trunk
01:35
Query planner heuristic update: When doing a full table scan on a table that has an equality constraint on an unindexed column, do not allow the estimated number of output rows to be greater than half the total number of rows in the table. check-in: 73954f93 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/where.c.

  4225   4225     WhereClause *pWC,      /* The WHERE clause */
  4226   4226     WhereLoop *pLoop,      /* The loop to adjust downward */
  4227   4227     LogEst nRow            /* Number of rows in the entire table */
  4228   4228   ){
  4229   4229     WhereTerm *pTerm, *pX;
  4230   4230     Bitmask notAllowed = ~(pLoop->prereq|pLoop->maskSelf);
  4231   4231     int i, j;
  4232         -  int nEq = 0;    /* Number of = constraints not within likely()/unlike() */
         4232  +  int nEq = 0;    /* Number of = constraints not within likely()/unlikely() */
  4233   4233   
  4234   4234     for(i=pWC->nTerm, pTerm=pWC->a; i>0; i--, pTerm++){
  4235   4235       if( (pTerm->wtFlags & TERM_VIRTUAL)!=0 ) break;
  4236   4236       if( (pTerm->prereqAll & pLoop->maskSelf)==0 ) continue;
  4237   4237       if( (pTerm->prereqAll & notAllowed)!=0 ) continue;
  4238   4238       for(j=pLoop->nLTerm-1; j>=0; j--){
  4239   4239         pX = pLoop->aLTerm[j];

Changes to test/whereJ.test.

   414    414       c BETWEEN 150 AND 160                   -- Matches 10 rows
   415    415   } {
   416    416     0 0 0 {SEARCH TABLE t1 USING INDEX idx_ab (a=? AND b>? AND b<?)}
   417    417   }
   418    418   
   419    419   ###########################################################################################
   420    420   
   421         -# Reset the database and setup for a test case derived from an actual SQLite users
          421  +# Reset the database and setup for a test case derived from actual SQLite users
   422    422   #
   423    423   db close
   424    424   sqlite3 db test.db
   425    425   do_execsql_test 4.1 {
   426    426     CREATE TABLE le(
   427    427       le_id largeint,
   428    428       xid char(31),
................................................................................
   614    614     INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','98066 98066','98066 98066',X'03030302a76500ce54');
   615    615     INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','101590 101590','101590 101590',X'03030302b63d00d3b5');
   616    616     INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','101727 101727','101727 101727',X'03030202b6f24e9b');
   617    617     INSERT INTO sqlite_stat4 VALUES('px','p_id','1 1','107960 107960','107960 107960',X'03030302d8ce0136ad');
   618    618     ANALYZE sqlite_master;
   619    619   } {}
   620    620   
   621         -# The following query should do a ful ltable scan of cx in the outer loop.
          621  +# The following query should do a full table scan of cx in the outer loop.
   622    622   # It is not correct to search table px using indx p_pt in the outer loop
   623    623   # with cx in the middle loop.  Test case from Bloomberg on 2014-09-05.
   624    624   #
   625    625   do_execsql_test 4.2 {
   626    626     EXPLAIN QUERY PLAN
   627    627     SELECT
   628    628        px.name,