| Index: third_party/sqlite/src/test/trace2.test
|
| diff --git a/third_party/sqlite/src/test/trace2.test b/third_party/sqlite/src/test/trace2.test
|
| index a70dd89d1db732fea94c29a5ead1a633472b894c..562c70c538aabade24644247ffa66361cf8b1309 100644
|
| --- a/third_party/sqlite/src/test/trace2.test
|
| +++ b/third_party/sqlite/src/test/trace2.test
|
| @@ -128,24 +128,27 @@ ifcapable fts3 {
|
| INSERT INTO x1 VALUES('North northwest wind between 8 and 14 mph');
|
| } {
|
| "INSERT INTO x1 VALUES('North northwest wind between 8 and 14 mph');"
|
| + "-- DELETE FROM 'main'.'x1_segdir' WHERE level = ?"
|
| "-- 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 value FROM 'main'.'x1_stat' WHERE id=?"
|
| + "-- REPLACE INTO 'main'.'x1_stat' VALUES(?,?)"
|
| "-- SELECT (SELECT max(idx) FROM 'main'.'x1_segdir' WHERE level = ?) + 1"
|
| "-- SELECT coalesce((SELECT max(blockid) FROM 'main'.'x1_segments') + 1, 1)"
|
| - "-- INSERT INTO 'main'.'x1_segdir' VALUES(?,?,?,?,?,?)"
|
| + "-- REPLACE INTO 'main'.'x1_segdir' VALUES(?,?,?,?,?,?)"
|
| + "-- SELECT level, idx, end_block FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ? ORDER BY level DESC, idx ASC"
|
| }
|
|
|
| do_trace_test 2.3 {
|
| INSERT INTO x1(x1) VALUES('optimize');
|
| } {
|
| "INSERT INTO x1(x1) VALUES('optimize');"
|
| - "-- SELECT idx, start_block, leaves_end_block, end_block, root FROM 'main'.'x1_segdir' ORDER BY level DESC, idx ASC"
|
| - "-- SELECT count(*), max(level) FROM 'main'.'x1_segdir'"
|
| + "-- SELECT DISTINCT level / (1024 * ?) FROM 'main'.'x1_segdir'"
|
| + "-- SELECT idx, start_block, leaves_end_block, end_block, root FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?ORDER BY level DESC, idx ASC"
|
| + "-- SELECT max(level) FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?"
|
| "-- SELECT coalesce((SELECT max(blockid) FROM 'main'.'x1_segments') + 1, 1)"
|
| - "-- DELETE FROM 'main'.'x1_segdir'"
|
| - "-- INSERT INTO 'main'.'x1_segdir' VALUES(?,?,?,?,?,?)"
|
| + "-- DELETE FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?"
|
| + "-- REPLACE INTO 'main'.'x1_segdir' VALUES(?,?,?,?,?,?)"
|
| }
|
| }
|
|
|
|
|