Return to jrnlmode2.test CVS log

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

Annotation of embedaddon/sqlite3/test/jrnlmode2.test, revision 1.1.1.1

1.1       misho       1: # 2009 March 24
                      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: 
                     13: set testdir [file dirname $argv0]
                     14: source $testdir/tester.tcl
                     15: 
                     16: ifcapable {!pager_pragmas} {
                     17:   finish_test
                     18:   return
                     19: }
                     20: 
                     21: #-------------------------------------------------------------------------
                     22: # The tests in this file check that the following two bugs (both now fixed)
                     23: # do not reappear.
                     24: #
                     25: # jrnlmode2-1.*: Demonstrate bug #3745:
                     26: #
                     27: #     In persistent journal mode, if:
                     28: #
                     29: #       * There is a persistent journal in the file-system, AND
                     30: #       * there exists a connection with a shared lock on the db file, 
                     31: #
                     32: #     then a second connection cannot open a read-transaction on the database.
                     33: #     The reason is because while determining that the persistent-journal is
                     34: #     not a hot-journal, SQLite currently grabs an exclusive lock on the
                     35: #     database file. If this fails because another connection has a shared
                     36: #     lock, then SQLITE_BUSY is returned to the user.  
                     37: #
                     38: # jrnlmode2-2.*: Demonstrate bug #3751:
                     39: #
                     40: #     If a connection is opened in SQLITE_OPEN_READONLY mode, the underlying
                     41: #     unix file descriptor on the database file is opened in O_RDONLY mode.
                     42: #
                     43: #     When SQLite queries the database file for the schema in order to compile
                     44: #     the SELECT statement, it sees the empty journal in the file system, it
                     45: #     attempts to obtain an exclusive lock on the database file (this is a
                     46: #     bug). The attempt to obtain an exclusive (write) lock on a read-only file
                     47: #     fails at the OS level. Under unix, fcntl() reports an EBADF - "Bad file
                     48: #     descriptor" - error. 
                     49: #
                     50: 
                     51: do_test jrnlmode2-1.1 {
                     52:   execsql {
                     53:     PRAGMA journal_mode = persist;
                     54:     CREATE TABLE t1(a, b);
                     55:     INSERT INTO t1 VALUES(1, 2);
                     56:   }
                     57: } {persist}
                     58: 
                     59: do_test jrnlmode2-1.2 {
                     60:   file exists test.db-journal
                     61: } {1}
                     62: 
                     63: do_test jrnlmode2-1.3 {
                     64:   sqlite3 db2 test.db
                     65:   execsql { SELECT * FROM t1 } db2
                     66: } {1 2}
                     67: 
                     68: do_test jrnlmode2-1.4 {
                     69:   execsql {
                     70:     INSERT INTO t1 VALUES(3, 4);
                     71:   }
                     72:   execsql {
                     73:     BEGIN;
                     74:     SELECT * FROM t1;
                     75:   }
                     76:   execsql { PRAGMA lock_status }
                     77: } {main shared temp closed}
                     78: 
                     79: do_test jrnlmode2-1.5 {
                     80:   file exists test.db-journal
                     81: } {1}
                     82: 
                     83: do_test jrnlmode2-1.6 {
                     84:   catchsql { SELECT * FROM t1 } db2
                     85: } {0 {1 2 3 4}}
                     86: 
                     87: do_test jrnlmode2-1.7 {
                     88:   execsql { COMMIT }
                     89:   catchsql { SELECT * FROM t1 } db2
                     90: } {0 {1 2 3 4}}
                     91: 
                     92: 
                     93: 
                     94: do_test jrnlmode2-2.1 {
                     95:   db2 close
                     96:   execsql { PRAGMA journal_mode = truncate }
                     97:   execsql { INSERT INTO t1 VALUES(5, 6) }
                     98: } {}
                     99: 
                    100: do_test jrnlmode2-2.2 {
                    101:   file exists test.db-journal
                    102: } {1}
                    103: 
                    104: do_test jrnlmode2-2.3 {
                    105:   file size test.db-journal
                    106: } {0}
                    107: 
                    108: do_test jrnlmode2-2.4 {
                    109:   sqlite3 db2 test.db -readonly 1
                    110:   catchsql { SELECT * FROM t1 } db2
                    111: } {0 {1 2 3 4 5 6}}
                    112: 
                    113: do_test jrnlmode2-2.5 {
                    114:   db close
                    115:   delete_file test.db-journal
                    116: } {}
                    117: do_test jrnlmode2-2.6 {
                    118:   sqlite3 db2 test.db -readonly 1
                    119:   catchsql { SELECT * FROM t1 } db2
                    120: } {0 {1 2 3 4 5 6}}
                    121: 
                    122: catch { db2 close }
                    123: finish_test