Return to fts3shared.test CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test

Annotation of embedaddon/sqlite3/test/fts3shared.test, revision 1.1

1.1     ! misho       1: # 2010 September 17
        !             2: #
        !             3: #    May you do good and not evil.
        !             4: #    May you find forgiveness for yourself and forgive others.
        !             5: #    May you share freely, never taking more than you give.
        !             6: #
        !             7: #***********************************************************************
        !             8: #
        !             9: 
        !            10: set testdir [file dirname $argv0]
        !            11: source $testdir/tester.tcl
        !            12: 
        !            13: ifcapable !fts3||!shared_cache {
        !            14:   finish_test
        !            15:   return
        !            16: }
        !            17: 
        !            18: db close
        !            19: set ::enable_shared_cache [sqlite3_enable_shared_cache 1]
        !            20: 
        !            21: # Open two connections to the database in shared-cache mode.
        !            22: #
        !            23: sqlite3 db test.db
        !            24: sqlite3 db2 test.db
        !            25: 
        !            26: # Create a virtual FTS3 table. Populate it with some initial data.
        !            27: #
        !            28: do_execsql_test fts3shared-1.1 {
        !            29:   CREATE VIRTUAL TABLE t1 USING fts3(x);
        !            30:   BEGIN;
        !            31:   INSERT INTO t1 VALUES('We listened and looked sideways up!');
        !            32:   INSERT INTO t1 VALUES('Fear at my heart, as at a cup,');
        !            33:   INSERT INTO t1 VALUES('My life-blood seemed to sip!');
        !            34:   INSERT INTO t1 VALUES('The stars were dim, and thick the night');
        !            35:   COMMIT;
        !            36: } {}
        !            37: 
        !            38: # Open a write transaction and insert rows into the FTS3 table. This takes
        !            39: # a write-lock on the underlying t1_content table.
        !            40: #
        !            41: do_execsql_test fts3shared-1.2 {
        !            42:   BEGIN;
        !            43:     INSERT INTO t1 VALUES('The steersman''s face by his lamp gleamed white;');
        !            44: } {}
        !            45: 
        !            46: # Now try a SELECT on the full-text table. This particular SELECT does not
        !            47: # read data from the %_content table. But it still attempts to obtain a lock
        !            48: # on that table and so the SELECT fails.
        !            49: #
        !            50: do_test fts3shared-1.3 {
        !            51:   catchsql {  
        !            52:     BEGIN;
        !            53:       SELECT rowid FROM t1 WHERE t1 MATCH 'stars' 
        !            54:   } db2
        !            55: } {1 {database table is locked}}
        !            56: 
        !            57: # Verify that the first connection can commit its transaction.
        !            58: #
        !            59: do_test fts3shared-1.4 { sqlite3_get_autocommit db } 0
        !            60: do_execsql_test fts3shared-1.5 { COMMIT } {}
        !            61: do_test fts3shared-1.6 { sqlite3_get_autocommit db } 1
        !            62: 
        !            63: # Verify that the second connection still has an open transaction.
        !            64: #
        !            65: do_test fts3shared-1.6 { sqlite3_get_autocommit db2 } 0
        !            66: 
        !            67: db close
        !            68: db2 close
        !            69: 
        !            70: sqlite3_enable_shared_cache $::enable_shared_cache
        !            71: finish_test
        !            72: