| OLD | NEW | 
|---|
| 1 # 2005 January 19 | 1 # 2005 January 19 | 
| 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 72 matching lines...) Expand 10 before | Expand all | Expand 10 after  Loading... | 
| 83     BEGIN; | 83     BEGIN; | 
| 84     INSERT INTO t1 VALUES(10, randomblob(5000)) | 84     INSERT INTO t1 VALUES(10, randomblob(5000)) | 
| 85   } db1 | 85   } db1 | 
| 86   catchsql {select count(*) from sqlite_master} db3 | 86   catchsql {select count(*) from sqlite_master} db3 | 
| 87 } {0 1} | 87 } {0 1} | 
| 88 do_test shared3-2.8 { | 88 do_test shared3-2.8 { | 
| 89   db3 close | 89   db3 close | 
| 90   execsql { | 90   execsql { | 
| 91     INSERT INTO t1 VALUES(10, randomblob(10000)) | 91     INSERT INTO t1 VALUES(10, randomblob(10000)) | 
| 92   } db1 | 92   } db1 | 
| 93   sqlite3 db3 $alternative_name |  | 
| 94 | 93 | 
| 95   # If the pager-cache is really still limited to 10 pages, then the INSERT | 94   # If the pager-cache is really still limited to 10 pages, then the INSERT | 
| 96   # statement above should have caused the pager to grab an exclusive lock | 95   # statement above should have caused the pager to grab an exclusive lock | 
| 97   # on the database file so that the cache could be spilled. | 96   # on the database file so that the cache could be spilled. | 
| 98   # | 97   # | 
|  | 98   catch { sqlite3 db3 $alternative_name } | 
| 99   catchsql {select count(*) from sqlite_master} db3 | 99   catchsql {select count(*) from sqlite_master} db3 | 
| 100 } {1 {database is locked}} | 100 } {1 {database is locked}} | 
| 101 | 101 | 
| 102 db1 close | 102 db1 close | 
| 103 db2 close | 103 db2 close | 
| 104 db3 close | 104 db3 close | 
| 105 | 105 | 
| 106 sqlite3_enable_shared_cache $::enable_shared_cache | 106 sqlite3_enable_shared_cache $::enable_shared_cache | 
| 107 finish_test | 107 finish_test | 
| OLD | NEW | 
|---|