Return to stmt.test CVS log

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

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

1.1       misho       1: # 2010 February 18
                      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: # The tests in this file check that SQLite uses (or does not use) a
                     13: # statement journal for various SQL statements.
                     14: #
                     15: 
                     16: set testdir [file dirname $argv0]
                     17: source $testdir/tester.tcl
                     18: 
                     19: do_test stmt-1.1 {
                     20:   execsql { CREATE TABLE t1(a integer primary key, b INTEGER NOT NULL) }
                     21: } {}
                     22: 
                     23: # The following tests verify the method used for the tests in this file -
                     24: # that if a statement journal is required by a statement it is opened and
                     25: # remains open until the current transaction is committed or rolled back.
                     26: #
                     27: # This only work if SQLITE_TEMP_STORE!=3
                     28: #
                     29: if {$::TEMP_STORE==3} {
                     30:   finish_test
                     31:   return
                     32: }
                     33: do_test stmt-1.2 {
                     34:   set sqlite_open_file_count
                     35: } {1}
                     36: do_test stmt-1.3 {
                     37:   execsql {
                     38:     PRAGMA temp_store = file;
                     39:     BEGIN;
                     40:       INSERT INTO t1 VALUES(1, 1);
                     41:   }
                     42:   set sqlite_open_file_count
                     43: } {2}
                     44: do_test stmt-1.4 {
                     45:   execsql {
                     46:     INSERT INTO t1 SELECT a+1, b+1 FROM t1;
                     47:   }
                     48:   set sqlite_open_file_count
                     49: } {3}
                     50: do_test stmt-1.5 {
                     51:   execsql COMMIT
                     52:   set sqlite_open_file_count
                     53: } {1}
                     54: do_test stmt-1.6.1 {
                     55:   execsql {
                     56:     BEGIN;
                     57:       INSERT INTO t1 SELECT a+2, b+2 FROM t1;
                     58:   }
                     59:   set sqlite_open_file_count
                     60: } {2}
                     61: do_test stmt-1.6.2 {
                     62:   execsql { INSERT INTO t1 SELECT a+4, b+4 FROM t1 }
                     63:   set sqlite_open_file_count
                     64: } {3}
                     65: do_test stmt-1.7 {
                     66:   execsql COMMIT
                     67:   set sqlite_open_file_count
                     68: } {1}
                     69: 
                     70: 
                     71: proc filecount {testname sql expected} {
                     72:   uplevel [list do_test $testname [subst -nocommand {
                     73:     execsql BEGIN
                     74:     execsql { $sql }
                     75:     set ret [set sqlite_open_file_count]
                     76:     execsql ROLLBACK
                     77:     set ret
                     78:   }] $expected]
                     79: }
                     80: 
                     81: filecount stmt-2.1 { INSERT INTO t1 VALUES(9, 9)  } 2
                     82: filecount stmt-2.2 { REPLACE INTO t1 VALUES(9, 9) } 2
                     83: filecount stmt-2.3 { INSERT INTO t1 SELECT 9, 9   } 2
                     84: filecount stmt-2.4 { 
                     85:     INSERT INTO t1 SELECT 9, 9;
                     86:     INSERT INTO t1 SELECT 10, 10;
                     87: } 3
                     88: 
                     89: do_test stmt-2.5 {
                     90:   execsql { CREATE INDEX i1 ON t1(b) }
                     91: } {}
                     92: filecount stmt-2.6 { 
                     93:   REPLACE INTO t1 VALUES(5, 5);
                     94:   REPLACE INTO t1 VALUES(5, 5); 
                     95: } 3
                     96: 
                     97: finish_test