1# 2016 March 17
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
13source [file join [file dirname [info script]] fts5_common.tcl]
14source $testdir/lock_common.tcl
15
16set testprefix fts5multiclient
17return_if_no_fts5
18
19foreach_detail_mode $testprefix {
20
21do_multiclient_test tn {
22
23  do_test 1.$tn.1 {
24    sql1 { CREATE VIRTUAL TABLE t1 USING fts5(x, detail=%DETAIL%) }
25    sql1 { INSERT INTO t1 VALUES('a b c') }
26    sql2 { SELECT rowid FROM t1('b') }
27  } {1}
28
29  do_test 1.$tn.2 {
30    sql2 { INSERT INTO t1 VALUES('a b c') }
31    sql1 { SELECT rowid FROM t1('b') }
32  } {1 2}
33
34  do_test 1.$tn.3 {
35    sql2 { INSERT INTO t1 VALUES('a b c') }
36    sql1 { SELECT rowid FROM t1('b') }
37  } {1 2 3}
38
39  do_test 1.$tn.4 {
40    sql2 { INSERT INTO t1 VALUES('a b c') }
41    sql1 { INSERT INTO t1 VALUES('a b c') }
42    sql3 { INSERT INTO t1(t1) VALUES('integrity-check') }
43  } {}
44
45};# do_multiclient_test
46};# foreach_detail_mode
47finish_test
48