/ Check-in [c2f84f63]
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 the speedtest1.c test program so that it gives closing "%" wildcards on LIKE searches.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: c2f84f637f994c3b4522b48161185a4a2c5bca23
User & Date: drh 2016-11-08 16:27:59
Context
2016-11-08
17:19
Avoid generating OP_TableLock unnecessary instructions on btrees that are not sharable. check-in: 8cb8516d user: drh tags: trunk
16:27
Fix the speedtest1.c test program so that it gives closing "%" wildcards on LIKE searches. check-in: c2f84f63 user: drh tags: trunk
00:30
Tweaks to speedtest1.c to better reflect mobile usage based on findings in the "Pocket Data" paper by Kennedy, Ajay, Challen, and Ziarek. check-in: b5733cae user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/speedtest1.c.

   556    556       if( (i-1)%g.nRepeat==0 ){
   557    557         x1 = speedtest1_random()%maxb;
   558    558         zNum[0] = '%';
   559    559         len = speedtest1_numbername(i, zNum+1, sizeof(zNum)-2);
   560    560         zNum[len] = '%';
   561    561         zNum[len+1] = 0;
   562    562       }
   563         -    sqlite3_bind_text(g.pStmt, 1, zNum, len, SQLITE_STATIC);
          563  +    sqlite3_bind_text(g.pStmt, 1, zNum, len+1, SQLITE_STATIC);
   564    564       speedtest1_run();
   565    565     }
   566    566     speedtest1_exec("COMMIT");
   567    567     speedtest1_end_test();
   568    568   
   569    569   
   570    570     n = 10;
................................................................................
   578    578       if( (i-1)%g.nRepeat==0 ){
   579    579         x1 = speedtest1_random()%maxb;
   580    580         zNum[0] = '%';
   581    581         len = speedtest1_numbername(i, zNum+1, sizeof(zNum)-2);
   582    582         zNum[len] = '%';
   583    583         zNum[len+1] = 0;
   584    584       }
   585         -    sqlite3_bind_text(g.pStmt, 1, zNum, len, SQLITE_STATIC);
          585  +    sqlite3_bind_text(g.pStmt, 1, zNum, len+1, SQLITE_STATIC);
   586    586       speedtest1_run();
   587    587     }
   588    588     speedtest1_exec("COMMIT");
   589    589     speedtest1_end_test();
   590    590   
   591    591     n = 10; /* g.szTest/5; */
   592    592     speedtest1_begin_test(145, "%d SELECTS w/ORDER BY and LIMIT, unindexed", n);
................................................................................
   599    599       if( (i-1)%g.nRepeat==0 ){
   600    600         x1 = speedtest1_random()%maxb;
   601    601         zNum[0] = '%';
   602    602         len = speedtest1_numbername(i, zNum+1, sizeof(zNum)-2);
   603    603         zNum[len] = '%';
   604    604         zNum[len+1] = 0;
   605    605       }
   606         -    sqlite3_bind_text(g.pStmt, 1, zNum, len, SQLITE_STATIC);
          606  +    sqlite3_bind_text(g.pStmt, 1, zNum, len+1, SQLITE_STATIC);
   607    607       speedtest1_run();
   608    608     }
   609    609     speedtest1_exec("COMMIT");
   610    610     speedtest1_end_test();
   611    611   
   612    612   
   613    613     speedtest1_begin_test(150, "CREATE INDEX five times");