OLD | NEW |
1 # 2002 March 6 | 1 # 2002 March 6 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
(...skipping 237 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
248 do_execsql_test pragma2-4.8 { | 248 do_execsql_test pragma2-4.8 { |
249 PRAGMA cache_spill=ON; -- Applies to all databases | 249 PRAGMA cache_spill=ON; -- Applies to all databases |
250 BEGIN; | 250 BEGIN; |
251 UPDATE t2 SET c=c-1; | 251 UPDATE t2 SET c=c-1; |
252 PRAGMA lock_status; | 252 PRAGMA lock_status; |
253 } {main unlocked temp unknown aux1 exclusive} | 253 } {main unlocked temp unknown aux1 exclusive} |
254 db close | 254 db close |
255 forcedelete test.db | 255 forcedelete test.db |
256 sqlite3 db test.db | 256 sqlite3 db test.db |
257 | 257 |
258 breakpoint | |
259 do_execsql_test pragma2-5.1 { | 258 do_execsql_test pragma2-5.1 { |
260 PRAGMA page_size=16384; | 259 PRAGMA page_size=16384; |
261 CREATE TABLE t1(x); | 260 CREATE TABLE t1(x); |
262 PRAGMA cache_size=2; | 261 PRAGMA cache_size=2; |
263 PRAGMA cache_spill=YES; | 262 PRAGMA cache_spill=YES; |
264 PRAGMA cache_spill; | 263 PRAGMA cache_spill; |
265 } {2} | 264 } {2} |
266 do_execsql_test pragma2-5.2 { | 265 do_execsql_test pragma2-5.2 { |
267 PRAGMA cache_spill=NO; | 266 PRAGMA cache_spill=NO; |
268 PRAGMA cache_spill; | 267 PRAGMA cache_spill; |
269 } {0} | 268 } {0} |
270 do_execsql_test pragma2-5.3 { | 269 do_execsql_test pragma2-5.3 { |
271 PRAGMA cache_spill(-51); | 270 PRAGMA cache_spill(-51); |
272 PRAGMA cache_spill; | 271 PRAGMA cache_spill; |
273 } {3} | 272 } {3} |
274 | 273 |
275 test_restore_config_pagecache | 274 test_restore_config_pagecache |
276 finish_test | 275 finish_test |
OLD | NEW |