AryaWu/sqlite

1# 2006 September 92#3# The author disclaims copyright to this source code.  In place of4# 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.  The12# focus of this script is testing the FTS3 module.13#14 15set testdir [file dirname $argv0]16source $testdir/tester.tcl17set testprefix fts3expr518 19# If SQLITE_ENABLE_FTS3 is defined, omit this file.20ifcapable !fts3 {21  finish_test22  return23}24 25proc test_fts3expr {expr} {26  db one {SELECT fts3_exprtest('simple', $expr, 'a', 'b', 'c')}27}28 29#-------------------------------------------------------------------------30# Various forms of empty phrase expressions.31#32do_execsql_test 1.0 {33  CREATE VIRTUAL TABLE t0 USING fts3(x);34  SELECT rowid FROM t0 WHERE x MATCH '';35} {}36do_execsql_test 1.1 {37  SELECT rowid FROM t0 WHERE x MATCH '""';38} {}39do_execsql_test 1.2 {40  SELECT rowid FROM t0 WHERE x MATCH '"" ""';41} {}42do_execsql_test 1.3 {43  SELECT rowid FROM t0 WHERE x MATCH '"" OR ""';44} {}45do_execsql_test 1.4 {46  SELECT rowid FROM t0 WHERE x MATCH '"" NOT ""';47} {}48do_execsql_test 1.5 {49  SELECT rowid FROM t0 WHERE x MATCH '""""';50} {}51 52#-------------------------------------------------------------------------53# Various forms of empty phrase expressions.54#55set sqlite_fts3_enable_parentheses 156do_test 2.0 {57  test_fts3expr {(a:123)(b:234)()(c:456)}58} {AND {AND {PHRASE 0 0 123} {PHRASE 1 0 234}} {PHRASE 2 0 456}}59do_test 2.1 {60  test_fts3expr {(a:123)(b:234)(c:456)}61} {AND {AND {PHRASE 0 0 123} {PHRASE 1 0 234}} {PHRASE 2 0 456}}62do_test 2.2 {63  list [catch { test_fts3expr {"123" AND ( )} } msg] $msg64} {1 {Error parsing expression}}65 66finish_test67