| 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 |