Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a problem in fts4merge3.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | fts4-incr-merge |
| Files: | files | file ages | folders |
| SHA1: |
64fc8b30f8bc7ddc697b6042040e9587 |
| User & Date: | dan 2012-03-28 13:55:29 |
Context
|
2012-03-28
| ||
| 16:44 | Merge in the latest changes from trunk. Closed-Leaf check-in: 66c4aaad user: drh tags: fts4-incr-merge | |
| 13:55 | Fix a problem in fts4merge3.test. check-in: 64fc8b30 user: dan tags: fts4-incr-merge | |
|
2012-03-27
| ||
| 18:00 | Add output of PRAGMAs auto_vacuum and encoding to the "schema" command of the fts3view utility program. check-in: e3107631 user: drh tags: fts4-incr-merge | |
Changes
Changes to test/fts4merge3.test.
49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 |
do_test 1.6.$i.2 {
sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'"
} {1485}
}
do_test 1.7 { sql2 {
SELECT level, count(*) FROM t2_segdir GROUP BY level ORDER BY 1
} } [list 0 15 1 1 2 14 3 4 4 1]
# Using the old connection, insert many rows.
do_test 1.8 {
for {set i 0} {$i < 1500} {incr i} {
sql2 "INSERT INTO t2 SELECT content FROM t2 WHERE docid = $i"
}
} {}
do_test 1.9 { sql2 {
SELECT level, count(*) FROM t2_segdir GROUP BY level ORDER BY 1
} } {0 11 1 15 2 3 3 5 4 1}
# Run a big incr-merge operation on the db.
do_test 1.10 { sql1 { INSERT INTO t2(t2) VALUES('merge=2000,2') } } {}
do_test 1.11 {
sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'"
} {1485 21485}
|
| | |
49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 |
do_test 1.6.$i.2 {
sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'"
} {1485}
}
do_test 1.7 { sql2 {
SELECT level, count(*) FROM t2_segdir GROUP BY level ORDER BY 1
} } [list 0 1 2 18 3 5]
# Using the old connection, insert many rows.
do_test 1.8 {
for {set i 0} {$i < 1500} {incr i} {
sql2 "INSERT INTO t2 SELECT content FROM t2 WHERE docid = $i"
}
} {}
do_test 1.9 { sql2 {
SELECT level, count(*) FROM t2_segdir GROUP BY level ORDER BY 1
} } [list 0 13 1 13 2 5 3 6]
# Run a big incr-merge operation on the db.
do_test 1.10 { sql1 { INSERT INTO t2(t2) VALUES('merge=2000,2') } } {}
do_test 1.11 {
sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'"
} {1485 21485}
|