/ Check-in [57005085]
Login

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

Overview
Comment:In the ".scanstats on" output from the shell, round the estRows value to the nearest integer, rather than rounding toward zero.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:5700508535c35ac6b158b527e1d47e529e8e28ab
User & Date: drh 2014-11-07 13:52:44
Context
2014-11-07
14:37
Fix another harmless comment typo. check-in: b45bc80b user: drh tags: trunk
13:52
In the ".scanstats on" output from the shell, round the estRows value to the nearest integer, rather than rounding toward zero. check-in: 57005085 user: drh tags: trunk
13:24
Fix harmless typos in comments. check-in: 94c564da user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/shell.c.

  1218   1218         n++;
  1219   1219         sqlite3_stmt_scanstatus(p, i, SQLITE_SCANSTAT_NVISIT, (void*)&nVisit);
  1220   1220         sqlite3_stmt_scanstatus(p, i, SQLITE_SCANSTAT_EST, (void*)&rEst);
  1221   1221         sqlite3_stmt_scanstatus(p, i, SQLITE_SCANSTAT_EXPLAIN, (void*)&zExplain);
  1222   1222         fprintf(pArg->out, "Loop %2d: %s\n", n, zExplain);
  1223   1223         rEstLoop *= rEst;
  1224   1224         fprintf(pArg->out, "         nLoop=%-8lld nRow=%-8lld estRow=%-8lld estRow/Loop=%-8g\n",
  1225         -          nLoop, nVisit, (sqlite3_int64)rEstLoop, rEst
         1225  +          nLoop, nVisit, (sqlite3_int64)(rEstLoop+0.5), rEst
  1226   1226         );
  1227   1227       }
  1228   1228     }
  1229   1229     fprintf(pArg->out, "---------------------------\n");
  1230   1230   #endif
  1231   1231   }
  1232   1232