xref: /sqlite-3.40.0/test/fts3ak.test (revision 7d44b22d) 
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
13set testdir [file dirname $argv0]
14source $testdir/tester.tcl
15
16# If SQLITE_ENABLE_FTS3 is defined, omit this file.
17ifcapable !fts3 {
18  finish_test
19  return
20}
21
22db 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.
30do_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.
42do_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.
54do_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!
66do_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.
73do_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.
84do_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.
95do_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
105finish_test
106