/ Check-in [3546e245]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add a test to check that opening a second connection to a shared cache does not reset the cache size to its default value. (CVS 5256)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 3546e245aaf5d75b9f52ffb3268da9bc26946396
User & Date: danielk1977 2008-06-20 17:51:17
Context
2008-06-20
18:13
Add new Compare and Jump codes to the virtual machine. Use them in the implementation of aggregate queries. (CVS 5257) check-in: 08311365 user: drh tags: trunk
17:51
Add a test to check that opening a second connection to a shared cache does not reset the cache size to its default value. (CVS 5256) check-in: 3546e245 user: danielk1977 tags: trunk
15:24
Change the SRT_Subroutine mode into SRT_Coroutine. Use co-routines in the INSERT processing logic. (CVS 5255) check-in: 6b9d92fc user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/shared3.test.

     5      5   #
     6      6   #    May you do good and not evil.
     7      7   #    May you find forgiveness for yourself and forgive others.
     8      8   #    May you share freely, never taking more than you give.
     9      9   #
    10     10   #***********************************************************************
    11     11   #
    12         -# $Id: shared3.test,v 1.1 2006/05/24 12:43:28 drh Exp $
           12  +# $Id: shared3.test,v 1.2 2008/06/20 17:51:17 danielk1977 Exp $
    13     13   
    14     14   set testdir [file dirname $argv0]
    15     15   source $testdir/tester.tcl
    16     16   db close
    17     17   
    18     18   ifcapable !shared_cache {
    19     19     finish_test
................................................................................
    35     35     sqlite3 db1 test.db
    36     36     db1 eval {SELECT * FROM t1}
    37     37   } {abc {This is a test string}}
    38     38   do_test shared3-1.2 {
    39     39     sqlite3 db2 test.db
    40     40     db2 eval {SELECT y FROM t1 WHERE x='abc'}
    41     41   } {{This is a test string}}
           42  +
           43  +db1 close
           44  +db2 close
           45  +
           46  +do_test shared3-2.1 {
           47  +  sqlite3 db1 test.db
           48  +  execsql {
           49  +    PRAGMA main.cache_size = 64;
           50  +  } db1
           51  +} {}
           52  +do_test shared3-2.2 {
           53  +  execsql { PRAGMA main.cache_size } db1
           54  +} {64}
           55  +do_test shared3-2.3 {
           56  +  sqlite3 db2 test.db
           57  +  execsql { PRAGMA main.cache_size } db1
           58  +} {64}
           59  +do_test shared3-2.4 {
           60  +  execsql { PRAGMA main.cache_size } db2
           61  +} {64}
           62  +do_test shared3-2.5 {
           63  +  execsql { PRAGMA main.cache_size } db1
           64  +} {64}
    42     65   
    43     66   db1 close
    44     67   db2 close
    45     68   
    46     69   sqlite3_enable_shared_cache $::enable_shared_cache
    47     70   finish_test