Lines Matching refs:page
129 # crash-2.3: Delete 15 or so pages (with a 10 page page-cache), then crash.
325 CREATE TABLE abc(a, b, c); -- Root page 3
326 INSERT INTO abc VALUES(randstr(1500,1500), 0, 0); -- Overflow page 4
342 # 2: Put page 4 on the free-list (was the overflow page for the row deleted).
343 # 3: Write data to page 4 (it becomes the overflow page for the row inserted).
344 # The old page 4 data has been written to the journal file, but the
346 # 4: Create a table, which calls sqlite3pager_movepage() to move page 4
347 # to the end of the database (page 12) to make room for the new root-page.
348 # 5: Put pressure on the pager-cache. This results in page 4 being written
349 # to the database file to make space in the cache to load a new page. The
350 # bug was that page 4 was written to the database file before the journal
354 # End result: Before the bug was fixed, data has been written to page 4 of the
356 # data for this page.