modernc.org/cc@v1.0.1/v2/testdata/_sqlite/test/fts3expr5.test (about)

     1  # 2006 September 9
     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  # This file implements regression tests for SQLite library.  The
    12  # focus of this script is testing the FTS3 module.
    13  #
    14  
    15  set testdir [file dirname $argv0]
    16  source $testdir/tester.tcl
    17  set testprefix fts3expr5
    18  
    19  # If SQLITE_ENABLE_FTS3 is defined, omit this file.
    20  ifcapable !fts3 {
    21    finish_test
    22    return
    23  }
    24  
    25  #-------------------------------------------------------------------------
    26  # Various forms of empty phrase expressions.
    27  #
    28  do_execsql_test 1.0 {
    29    CREATE VIRTUAL TABLE t0 USING fts3(x);
    30    SELECT rowid FROM t0 WHERE x MATCH '';
    31  } {}
    32  do_execsql_test 1.1 {
    33    SELECT rowid FROM t0 WHERE x MATCH '""';
    34  } {}
    35  do_execsql_test 1.2 {
    36    SELECT rowid FROM t0 WHERE x MATCH '"" ""';
    37  } {}
    38  do_execsql_test 1.3 {
    39    SELECT rowid FROM t0 WHERE x MATCH '"" OR ""';
    40  } {}
    41  do_execsql_test 1.4 {
    42    SELECT rowid FROM t0 WHERE x MATCH '"" NOT ""';
    43  } {}
    44  do_execsql_test 1.5 {
    45    SELECT rowid FROM t0 WHERE x MATCH '""""';
    46  } {}
    47  
    48  finish_test