Return to fts3ak.test CVS log

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

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

1.1       misho       1: # 2007 March 9
                      2: #
                      3: # The author disclaims copyright to this source code.
                      4: #
                      5: #*************************************************************************
                      6: # This file implements regression tests for SQLite library.  These
                      7: # make sure that fts3 insertion buffering is fully transparent when
                      8: # using transactions.
                      9: #
                     10: # $Id: fts3ak.test,v 1.1 2007/08/20 17:38:42 shess Exp $
                     11: #
                     12: 
                     13: set testdir [file dirname $argv0]
                     14: source $testdir/tester.tcl
                     15: 
                     16: # If SQLITE_ENABLE_FTS3 is defined, omit this file.
                     17: ifcapable !fts3 {
                     18:   finish_test
                     19:   return
                     20: }
                     21: 
                     22: db eval {
                     23:   CREATE VIRTUAL TABLE t1 USING fts3(content);
                     24:   INSERT INTO t1 (rowid, content) VALUES(1, "hello world");
                     25:   INSERT INTO t1 (rowid, content) VALUES(2, "hello there");
                     26:   INSERT INTO t1 (rowid, content) VALUES(3, "cruel world");
                     27: }
                     28: 
                     29: # Test that possibly-buffered inserts went through after commit.
                     30: do_test fts3ak-1.1 {
                     31:   execsql {
                     32:     BEGIN TRANSACTION;
                     33:     INSERT INTO t1 (rowid, content) VALUES(4, "false world");
                     34:     INSERT INTO t1 (rowid, content) VALUES(5, "false door");
                     35:     COMMIT TRANSACTION;
                     36:     SELECT rowid FROM t1 WHERE t1 MATCH 'world';
                     37:   }
                     38: } {1 3 4}
                     39: 
                     40: # Test that buffered inserts are seen by selects in the same
                     41: # transaction.
                     42: do_test fts3ak-1.2 {
                     43:   execsql {
                     44:     BEGIN TRANSACTION;
                     45:     INSERT INTO t1 (rowid, content) VALUES(6, "another world");
                     46:     INSERT INTO t1 (rowid, content) VALUES(7, "another test");
                     47:     SELECT rowid FROM t1 WHERE t1 MATCH 'world';
                     48:     COMMIT TRANSACTION;
                     49:   }
                     50: } {1 3 4 6}
                     51: 
                     52: # Test that buffered inserts are seen within a transaction.  This is
                     53: # really the same test as 1.2.
                     54: do_test fts3ak-1.3 {
                     55:   execsql {
                     56:     BEGIN TRANSACTION;
                     57:     INSERT INTO t1 (rowid, content) VALUES(8, "second world");
                     58:     INSERT INTO t1 (rowid, content) VALUES(9, "second sight");
                     59:     SELECT rowid FROM t1 WHERE t1 MATCH 'world';
                     60:     ROLLBACK TRANSACTION;
                     61:   }
                     62: } {1 3 4 6 8}
                     63: 
                     64: # Double-check that the previous result doesn't persist past the
                     65: # rollback!
                     66: do_test fts3ak-1.4 {
                     67:   execsql {
                     68:     SELECT rowid FROM t1 WHERE t1 MATCH 'world';
                     69:   }
                     70: } {1 3 4 6}
                     71: 
                     72: # Test it all together.
                     73: do_test fts3ak-1.5 {
                     74:   execsql {
                     75:     BEGIN TRANSACTION;
                     76:     INSERT INTO t1 (rowid, content) VALUES(10, "second world");
                     77:     INSERT INTO t1 (rowid, content) VALUES(11, "second sight");
                     78:     ROLLBACK TRANSACTION;
                     79:     SELECT rowid FROM t1 WHERE t1 MATCH 'world';
                     80:   }
                     81: } {1 3 4 6}
                     82: 
                     83: # Test that the obvious case works.
                     84: do_test fts3ak-1.6 {
                     85:   execsql {
                     86:     BEGIN;
                     87:     INSERT INTO t1 (rowid, content) VALUES(12, "third world");
                     88:     COMMIT;
                     89:     SELECT rowid FROM t1 WHERE t1 MATCH 'third';
                     90:   }
                     91: } {12}
                     92: 
                     93: # This is exactly the same as the previous test, except that older
                     94: # code loses the INSERT due to an SQLITE_SCHEMA error.
                     95: do_test fts3ak-1.7 {
                     96:   execsql {
                     97:     BEGIN;
                     98:     INSERT INTO t1 (rowid, content) VALUES(13, "third dimension");
                     99:     CREATE TABLE x (c);
                    100:     COMMIT;
                    101:     SELECT rowid FROM t1 WHERE t1 MATCH 'dimension';
                    102:   }
                    103: } {13}
                    104: 
                    105: finish_test