/ Check-in [53299575]
Login

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

Overview
Comment:Add a compound-query test to the speedtest1 test program.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 532995759114ab7a7cba18cc9d8820d78eb1a96e
User & Date: drh 2014-02-09 23:59:28
Context
2014-02-10
03:21
Faster and smaller implementation of sqlite3_value_type(). check-in: 5708bc24 user: drh tags: trunk
2014-02-09
23:59
Add a compound-query test to the speedtest1 test program. check-in: 53299575 user: drh tags: trunk
18:02
Use the WITH clause to help resolve names for SELECT statements on the left of a compound query. Proposed fix for ticket [31a19d11b97088296a]. check-in: 67bfd59d user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/speedtest1.c.

   774    774       "....2...6"
   775    775       ".6....28."
   776    776       "...419..5"
   777    777       "....8..79",
   778    778     };
   779    779     const char *zPuz;
   780    780     double rSpacing;
          781  +  int nElem;
   781    782   
   782    783     if( g.szTest<25 ){
   783    784       zPuz = azPuzzle[0];
   784    785     }else if( g.szTest<70 ){
   785    786       zPuz = azPuzzle[1];
   786    787     }else{
   787    788       zPuz = azPuzzle[2];
................................................................................
   868    869      "    SELECT group_concat( substr(' .+*#', 1+min(iter/7,4), 1), '') \n"
   869    870      "    FROM m2 GROUP BY cy\n"
   870    871      "  )\n"
   871    872      "SELECT group_concat(rtrim(t),x'0a') FROM a;"
   872    873     );
   873    874     sqlite3_bind_double(g.pStmt, 1, rSpacing*.05);
   874    875     sqlite3_bind_double(g.pStmt, 2, rSpacing);
          876  +  speedtest1_run();
          877  +  speedtest1_end_test();
          878  +
          879  +  nElem = 10000*g.szTest;
          880  +  speedtest1_begin_test(400, "EXCEPT operator on %d-element tables", nElem);
          881  +  speedtest1_prepare(
          882  +    "WITH RECURSIVE \n"
          883  +    "  t1(x) AS (VALUES(2) UNION ALL SELECT x+2 FROM t1 WHERE x<%d),\n"
          884  +    "  t2(y) AS (VALUES(3) UNION ALL SELECT y+3 FROM t2 WHERE y<%d)\n"
          885  +    "SELECT count(x), avg(x) FROM (\n"
          886  +    "  SELECT x FROM t1 EXCEPT SELECT y FROM t2 ORDER BY 1\n"
          887  +    ");",
          888  +    nElem, nElem
          889  +  );
   875    890     speedtest1_run();
   876    891     speedtest1_end_test();
   877    892   
   878    893   }
   879    894   
   880    895   /*
   881    896   ** A testset used for debugging speedtest1 itself.