Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update a couple of existing test cases. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | fts4-incr-merge |
| Files: | files | file ages | folders |
| SHA1: | dcb8fa0f77a44250df0e8c4f6cfb9f6e |
| User & Date: | dan 2012-03-23 11:07:22 |
Context
|
2012-03-23
| ||
| 11:09 | When an incremental blob cursor is invalidated (occurs when an SQL statement modifies or deletes the row the blob cursor points to) release all page references held by the cursor. Otherwise, the presence of these references may cause other code in btree.c to incorrectly infer that the database is corrupt. check-in: 82c3f2ba user: dan tags: fts4-incr-merge | |
| 11:07 | Update a couple of existing test cases. check-in: dcb8fa0f user: dan tags: fts4-incr-merge | |
|
2012-03-22
| ||
| 17:48 | Add test cases to fts4merge.test. check-in: ecab2083 user: dan tags: fts4-incr-merge | |
Changes
Changes to test/fts4merge3.test.
84 85 86 87 88 89 90 91 92 93 94 95 96 |
do_test 1.14 {
sql2 "INSERT INTO t2(t2) VALUES('optimize')"
sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'"
} {1485 21485 22985}
do_test 1.15 { sql2 {
SELECT level, count(*) FROM t2_segdir GROUP BY level ORDER BY 1
} } {5 1}
}
}
finish_test
|
| |
84 85 86 87 88 89 90 91 92 93 94 95 96 |
do_test 1.14 {
sql2 "INSERT INTO t2(t2) VALUES('optimize')"
sql2 "SELECT docid FROM t2 WHERE t2 MATCH 'abc'"
} {1485 21485 22985}
do_test 1.15 { sql2 {
SELECT level, count(*) FROM t2_segdir GROUP BY level ORDER BY 1
} } {6 1}
}
}
finish_test
|
Changes to test/trace2.test.
126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 |
do_trace_test 2.2 {
INSERT INTO x1 VALUES('North northwest wind between 8 and 14 mph');
} {
"INSERT INTO x1 VALUES('North northwest wind between 8 and 14 mph');"
"-- INSERT INTO 'main'.'x1_content' VALUES(?,(?))"
"-- REPLACE INTO 'main'.'x1_docsize' VALUES(?,?)"
"-- SELECT value FROM 'main'.'x1_stat' WHERE id=0"
"-- REPLACE INTO 'main'.'x1_stat' VALUES(0,?)"
"-- SELECT (SELECT max(idx) FROM 'main'.'x1_segdir' WHERE level = ?) + 1"
"-- SELECT coalesce((SELECT max(blockid) FROM 'main'.'x1_segments') + 1, 1)"
"-- REPLACE INTO 'main'.'x1_segdir' VALUES(?,?,?,?,?,?)"
}
do_trace_test 2.3 {
|
| |
126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 |
do_trace_test 2.2 {
INSERT INTO x1 VALUES('North northwest wind between 8 and 14 mph');
} {
"INSERT INTO x1 VALUES('North northwest wind between 8 and 14 mph');"
"-- INSERT INTO 'main'.'x1_content' VALUES(?,(?))"
"-- REPLACE INTO 'main'.'x1_docsize' VALUES(?,?)"
"-- SELECT value FROM 'main'.'x1_stat' WHERE id=?"
"-- REPLACE INTO 'main'.'x1_stat' VALUES(0,?)"
"-- SELECT (SELECT max(idx) FROM 'main'.'x1_segdir' WHERE level = ?) + 1"
"-- SELECT coalesce((SELECT max(blockid) FROM 'main'.'x1_segments') + 1, 1)"
"-- REPLACE INTO 'main'.'x1_segdir' VALUES(?,?,?,?,?,?)"
}
do_trace_test 2.3 {
|