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