1 # 2008 July 14

     2 #

     3 # The author disclaims copyright to this source code.  In place of

     4 # a legal notice, here is a blessing:

     5 #

     6 #    May you do good and not evil.

     7 #    May you find forgiveness for yourself and forgive others.

     8 #    May you share freely, never taking more than you give.

     9 #

    10 #***********************************************************************

    11 #

    12 # Test the btree mutex protocol for shared cache mode.

    13 #

    14 # $Id: shared4.test,v 1.2 2008/08/04 03:51:24 danielk1977 Exp $

    15 

    16 set testdir [file dirname $argv0]

    17 source $testdir/tester.tcl

    18 db close

    19 puts hello

    20 

    21 # This script is only valid if we are running shared-cache mode in a

    22 # threadsafe-capable database engine.

    23 #

    24 ifcapable !shared_cache||!compound {

    25   finish_test

    26   return

    27 }

    28 set ::enable_shared_cache [sqlite3_enable_shared_cache 1]

    29 

    30 # Prepare multiple databases in shared cache mode.

    31 #

    32 do_test shared4-1.1 {

    33   file delete -force test1.db test1.db-journal

    34   file delete -force test2.db test2.db-journal

    35   file delete -force test3.db test3.db-journal

    36   file delete -force test4.db test4.db-journal

    37   sqlite3 db1 test1.db

    38   sqlite3 db2 test2.db

    39   sqlite3 db3 test3.db

    40   sqlite3 db4 test4.db

    41   db1 eval {

    42     CREATE TABLE t1(a);

    43     INSERT INTO t1 VALUES(111);

    44   }

    45   db2 eval {

    46     CREATE TABLE t2(b);

    47     INSERT INTO t2 VALUES(222);

    48   }

    49   db3 eval {

    50     CREATE TABLE t3(c);

    51     INSERT INTO t3 VALUES(333);

    52   }

    53   db4 eval {

    54     CREATE TABLE t4(d);

    55     INSERT INTO t4 VALUES(444);

    56   }

    57   db1 eval {

    58     ATTACH DATABASE 'test2.db' AS two;

    59     ATTACH DATABASE 'test3.db' AS three;

    60     ATTACH DATABASE 'test4.db' AS four;

    61   }

    62   db2 eval {

    63     ATTACH DATABASE 'test4.db' AS four;

    64     ATTACH DATABASE 'test3.db' AS three;

    65     ATTACH DATABASE 'test1.db' AS one;

    66   }

    67   db3 eval {

    68     ATTACH DATABASE 'test1.db' AS one;

    69     ATTACH DATABASE 'test2.db' AS two;

    70     ATTACH DATABASE 'test4.db' AS four;

    71   }

    72   db4 eval {

    73     ATTACH DATABASE 'test3.db' AS three;

    74     ATTACH DATABASE 'test2.db' AS two;

    75     ATTACH DATABASE 'test1.db' AS one;

    76   }

    77   db1 eval {

    78      SELECT a FROM t1 UNION ALL

    79      SELECT b FROM t2 UNION ALL

    80      SELECT c FROM t3 UNION ALL

    81      SELECT d FROM t4;

    82   }

    83 } {111 222 333 444}

    84 do_test shared4-1.2 {

    85   db2 eval {

    86      SELECT a FROM t1 UNION ALL

    87      SELECT b FROM t2 UNION ALL

    88      SELECT d FROM t4 UNION ALL

    89      SELECT c FROM t3;

    90   }

    91 } {111 222 444 333}

    92 do_test shared4-1.3 {

    93   db3 eval {

    94      SELECT a FROM t1 UNION ALL

    95      SELECT c FROM t3 UNION ALL

    96      SELECT b FROM t2 UNION ALL

    97      SELECT d FROM t4;

    98   }

    99 } {111 333 222 444}

   100 do_test shared4-1.4 {

   101   db4 eval {

   102      SELECT a FROM t1 UNION ALL

   103      SELECT c FROM t3 UNION ALL

   104      SELECT d FROM t4 UNION ALL

   105      SELECT b FROM t2;

   106   }

   107 } {111 333 444 222}

   108 do_test shared4-1.5 {

   109   db3 eval {

   110      SELECT a FROM t1 UNION ALL

   111      SELECT d FROM t4 UNION ALL

   112      SELECT b FROM t2 UNION ALL

   113      SELECT c FROM t3;

   114   }

   115 } {111 444 222 333}

   116 do_test shared4-1.6 {

   117   db4 eval {

   118      SELECT a FROM t1 UNION ALL

   119      SELECT d FROM t4 UNION ALL

   120      SELECT c FROM t3 UNION ALL

   121      SELECT b FROM t2;

   122   }

   123 } {111 444 333 222}

   124 do_test shared4-1.7 {

   125   db1 eval {

   126      SELECT b FROM t2 UNION ALL

   127      SELECT a FROM t1 UNION ALL

   128      SELECT c FROM t3 UNION ALL

   129      SELECT d FROM t4;

   130   }

   131 } {222 111 333 444}

   132 do_test shared4-1.8 {

   133   db2 eval {

   134      SELECT b FROM t2 UNION ALL

   135      SELECT a FROM t1 UNION ALL

   136      SELECT d FROM t4 UNION ALL

   137      SELECT c FROM t3;

   138   }

   139 } {222 111 444 333}

   140 do_test shared4-1.9 {

   141   db3 eval {

   142      SELECT b FROM t2 UNION ALL

   143      SELECT c FROM t3 UNION ALL

   144      SELECT a FROM t1 UNION ALL

   145      SELECT d FROM t4;

   146   }

   147 } {222 333 111 444}

   148 do_test shared4-1.10 {

   149   db4 eval {

   150      SELECT b FROM t2 UNION ALL

   151      SELECT c FROM t3 UNION ALL

   152      SELECT d FROM t4 UNION ALL

   153      SELECT a FROM t1;

   154   }

   155 } {222 333 444 111}

   156 do_test shared4-1.11 {

   157   db1 eval {

   158      SELECT c FROM t3 UNION ALL

   159      SELECT a FROM t1 UNION ALL

   160      SELECT b FROM t2 UNION ALL

   161      SELECT d FROM t4;

   162   }

   163 } {333 111 222 444}

   164 do_test shared4-1.12 {

   165   db2 eval {

   166      SELECT c FROM t3 UNION ALL

   167      SELECT a FROM t1 UNION ALL

   168      SELECT d FROM t4 UNION ALL

   169      SELECT b FROM t2;

   170   }

   171 } {333 111 444 222}

   172 

   173 do_test shared4-2.1 {

   174   db1 eval {

   175     UPDATE t1 SET a=a+1000;

   176     UPDATE t2 SET b=b+2000;

   177     UPDATE t3 SET c=c+3000;

   178     UPDATE t4 SET d=d+4000;

   179   }

   180   db2 eval {

   181     UPDATE t1 SET a=a+10000;

   182     UPDATE t2 SET b=b+20000;

   183     UPDATE t3 SET c=c+30000;

   184     UPDATE t4 SET d=d+40000;

   185   }

   186   db3 eval {

   187     UPDATE t1 SET a=a+100000;

   188     UPDATE t2 SET b=b+200000;

   189     UPDATE t3 SET c=c+300000;

   190     UPDATE t4 SET d=d+400000;

   191   }

   192   db4 eval {

   193     UPDATE t1 SET a=a+1000000;

   194     UPDATE t2 SET b=b+2000000;

   195     UPDATE t3 SET c=c+3000000;

   196     UPDATE t4 SET d=d+4000000;

   197   }

   198   db1 eval {

   199      SELECT a FROM t1 UNION ALL

   200      SELECT b FROM t2 UNION ALL

   201      SELECT c FROM t3 UNION ALL

   202      SELECT d FROM t4;

   203   }

   204 } {1111111 2222222 3333333 4444444}

   205 do_test shared4-2.2 {

   206   db2 eval {

   207      SELECT a FROM t1 UNION ALL

   208      SELECT b FROM t2 UNION ALL

   209      SELECT d FROM t4 UNION ALL

   210      SELECT c FROM t3;

   211   }

   212 } {1111111 2222222 4444444 3333333}

   213 do_test shared4-2.3 {

   214   db3 eval {

   215      SELECT a FROM t1 UNION ALL

   216      SELECT c FROM t3 UNION ALL

   217      SELECT b FROM t2 UNION ALL

   218      SELECT d FROM t4;

   219   }

   220 } {1111111 3333333 2222222 4444444}

   221 do_test shared4-2.4 {

   222   db4 eval {

   223      SELECT a FROM t1 UNION ALL

   224      SELECT c FROM t3 UNION ALL

   225      SELECT d FROM t4 UNION ALL

   226      SELECT b FROM t2;

   227   }

   228 } {1111111 3333333 4444444 2222222}

   229 

   230 

   231 db1 close

   232 db2 close

   233 db3 close

   234 db4 close

   235 

   236 sqlite3_enable_shared_cache $::enable_shared_cache

   237 finish_test