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(?,?,?,?,?,?)" |
} |
} |