/ Check-in [10238fad]
Login

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

Overview
Comment:Add a test for the EQP output of a skip-scan query that uses the PK index of a WITHOUT ROWID table.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 10238fad94a198c0639461645227b6c5ebe16eee
User & Date: dan 2014-05-22 09:58:45
Context
2014-05-23
11:48
Make sure sufficient VDBE registers are allocated for an INSERT...SELECT when there is an idlist on the insert table that includes an explicit rowid. Ticket [e9654505cfda93610585fde5a9bbf2e730c8a8d5] check-in: 9a2dd187 user: drh tags: trunk
2014-05-22
09:58
Add a test for the EQP output of a skip-scan query that uses the PK index of a WITHOUT ROWID table. check-in: 10238fad user: dan tags: trunk
2014-05-21
08:48
Do not burn memory remembering CHECK constraints in a read-only database. check-in: 34ddf02d user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/skipscan2.test.

   182    182     SELECT name FROM peoplew WHERE height>=180 ORDER BY +name;
   183    183   } {David Jack Patrick Quiana Xavier}
   184    184   do_execsql_test skipscan2-2.5eqp {
   185    185     EXPLAIN QUERY PLAN
   186    186     SELECT name FROM peoplew WHERE height>=180 ORDER BY +name;
   187    187   } {/*INDEX peoplew_idx1 */}
   188    188   
          189  +# A skip-scan on a PK index of a WITHOUT ROWID table.
          190  +#
          191  +do_execsql_test skipscan2-3.1 {
          192  +  CREATE TABLE t3(a, b, c, PRIMARY KEY(a, b)) WITHOUT ROWID;
          193  +}
          194  +do_test skipscan2-3.2 {
          195  +  for {set i 0} {$i < 1000} {incr i} {
          196  +    execsql { INSERT INTO t3 VALUES($i%2, $i, 'xyz') }
          197  +  }
          198  +  execsql { ANALYZE }
          199  +} {}
          200  +do_eqp_test skipscan2-3.3eqp {
          201  +  SELECT * FROM t3 WHERE b=42;
          202  +} {0 0 0 {SEARCH TABLE t3 USING COVERING INDEX sqlite_autoindex_t3_1 (ANY(a) AND b=?)}}
   189    203   
   190    204   
   191    205   finish_test