modernc.org/cc@v1.0.1/v2/testdata/_sqlite/ext/fts5/test/fts5multiclient.test (about)

     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  
    13  source [file join [file dirname [info script]] fts5_common.tcl]
    14  source $testdir/lock_common.tcl
    15  
    16  set testprefix fts5multiclient
    17  return_if_no_fts5
    18  
    19  foreach_detail_mode $testprefix {
    20  
    21  do_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
    47  finish_test