Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Also run analyze8.test as part of src4.test. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
21b5123716144a1fca786c84e1ef56bd |
User & Date: | dan 2013-06-25 16:22:42.764 |
Context
2013-06-25
| ||
20:07 | Fixes for ALTER TABLE functionality. check-in: c23ed5d08f user: dan tags: trunk | |
16:22 | Also run analyze8.test as part of src4.test. check-in: 21b5123716 user: dan tags: trunk | |
15:28 | Fix comments and a memory leak in analyze.c. check-in: 8a25008dfe user: dan tags: trunk | |
Changes
Changes to test/analyze8.test.
︙ | ︙ | |||
33 34 35 36 37 38 39 40 41 42 43 44 45 46 | # values there are hundreds of entries. The other has 10-20 # entries per value. # # Verify that the query planner chooses the first index for the singleton # entries and the second index for the others. # do_test 1.0 { db eval { CREATE TABLE t1(a,b,c,d); CREATE INDEX t1a ON t1(a); CREATE INDEX t1b ON t1(b); CREATE INDEX t1c ON t1(c); } for {set i 0} {$i<1000} {incr i} { | > | 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 | # values there are hundreds of entries. The other has 10-20 # entries per value. # # Verify that the query planner chooses the first index for the singleton # entries and the second index for the others. # do_test 1.0 { prng_state_set 123456789009876543 db eval { CREATE TABLE t1(a,b,c,d); CREATE INDEX t1a ON t1(a); CREATE INDEX t1b ON t1(b); CREATE INDEX t1c ON t1(c); } for {set i 0} {$i<1000} {incr i} { |
︙ | ︙ | |||
87 88 89 90 91 92 93 | # do_test 3.1 { eqp {SELECT * FROM t1 WHERE b BETWEEN 50 AND 54 AND c BETWEEN 0 AND 100000} } {0 0 0 {SEARCH TABLE t1 USING INDEX t1b (b>? AND b<?) (~6 rows)}} do_test 3.2 { eqp {SELECT * FROM t1 WHERE b BETWEEN 50 AND 54 AND c BETWEEN 800000 AND 900000} | | | 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 | # do_test 3.1 { eqp {SELECT * FROM t1 WHERE b BETWEEN 50 AND 54 AND c BETWEEN 0 AND 100000} } {0 0 0 {SEARCH TABLE t1 USING INDEX t1b (b>? AND b<?) (~6 rows)}} do_test 3.2 { eqp {SELECT * FROM t1 WHERE b BETWEEN 50 AND 54 AND c BETWEEN 800000 AND 900000} } {0 0 0 {SEARCH TABLE t1 USING INDEX t1c (c>? AND c<?) (~5 rows)}} do_test 3.3 { eqp {SELECT * FROM t1 WHERE a=100 AND c BETWEEN 0 AND 100000} } {0 0 0 {SEARCH TABLE t1 USING INDEX t1a (a=?) (~63 rows)}} do_test 3.4 { eqp {SELECT * FROM t1 WHERE a=100 AND c BETWEEN 800000 AND 900000} } {0 0 0 {SEARCH TABLE t1 USING INDEX t1c (c>? AND c<?) (~2 rows)}} finish_test |
Changes to test/permutations.test.
︙ | ︙ | |||
138 139 140 141 142 143 144 | csr1.test ckpt1.test mc1.test fts5expr1.test fts5query1.test fts5rnd1.test fts5create.test fts5snippet.test analyze.test analyze3.test analyze4.test analyze5.test | | | 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 | csr1.test ckpt1.test mc1.test fts5expr1.test fts5query1.test fts5rnd1.test fts5create.test fts5snippet.test analyze.test analyze3.test analyze4.test analyze5.test analyze6.test analyze7.test analyze8.test auth.test auth2.test auth3.test auth4.test aggerror.test attach.test autoindex1.test badutf.test between.test bigrow.test |
︙ | ︙ |