Annotation of embedaddon/sqlite3/test/fts3expr.test, revision 1.1
1.1 ! misho 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: # $Id: fts3expr.test,v 1.9 2009/07/28 16:44:26 danielk1977 Exp $
! 15: #
! 16:
! 17: set testdir [file dirname $argv0]
! 18: source $testdir/tester.tcl
! 19:
! 20: # If SQLITE_ENABLE_FTS3 is defined, omit this file.
! 21: ifcapable !fts3 {
! 22: finish_test
! 23: return
! 24: }
! 25:
! 26: set sqlite_fts3_enable_parentheses 1
! 27:
! 28: proc test_fts3expr {expr} {
! 29: db one {SELECT fts3_exprtest('simple', $expr, 'a', 'b', 'c')}
! 30: }
! 31: do_test fts3expr-1.0 {
! 32: test_fts3expr "abcd"
! 33: } {PHRASE 3 0 abcd}
! 34: do_test fts3expr-1.1 {
! 35: test_fts3expr " tag "
! 36: } {PHRASE 3 0 tag}
! 37:
! 38: do_test fts3expr-1.2 {
! 39: test_fts3expr "ab AND cd"
! 40: } {AND {PHRASE 3 0 ab} {PHRASE 3 0 cd}}
! 41: do_test fts3expr-1.2.1 {
! 42: test_fts3expr "ab cd"
! 43: } {AND {PHRASE 3 0 ab} {PHRASE 3 0 cd}}
! 44: do_test fts3expr-1.3 {
! 45: test_fts3expr "ab OR cd"
! 46: } {OR {PHRASE 3 0 ab} {PHRASE 3 0 cd}}
! 47: do_test fts3expr-1.4 {
! 48: test_fts3expr "ab NOT cd"
! 49: } {NOT {PHRASE 3 0 ab} {PHRASE 3 0 cd}}
! 50: do_test fts3expr-1.5 {
! 51: test_fts3expr "ab NEAR cd"
! 52: } {NEAR/10 {PHRASE 3 0 ab} {PHRASE 3 0 cd}}
! 53: do_test fts3expr-1.6.1 {
! 54: test_fts3expr "ab NEAR/5 cd"
! 55: } {NEAR/5 {PHRASE 3 0 ab} {PHRASE 3 0 cd}}
! 56: do_test fts3expr-1.6.2 {
! 57: test_fts3expr "ab NEAR/87654321 cd"
! 58: } {NEAR/87654321 {PHRASE 3 0 ab} {PHRASE 3 0 cd}}
! 59: do_test fts3expr-1.6.3 {
! 60: test_fts3expr "ab NEAR/7654321 cd"
! 61: } {NEAR/7654321 {PHRASE 3 0 ab} {PHRASE 3 0 cd}}
! 62: do_test fts3expr-1.6.4 {
! 63: test_fts3expr "ab NEAR/654321 cd"
! 64: } {NEAR/654321 {PHRASE 3 0 ab} {PHRASE 3 0 cd}}
! 65: do_test fts3expr-1.6.5 {
! 66: test_fts3expr "ab NEAR/54321 cd"
! 67: } {NEAR/54321 {PHRASE 3 0 ab} {PHRASE 3 0 cd}}
! 68: do_test fts3expr-1.6.6 {
! 69: test_fts3expr "ab NEAR/4321 cd"
! 70: } {NEAR/4321 {PHRASE 3 0 ab} {PHRASE 3 0 cd}}
! 71: do_test fts3expr-1.6.7 {
! 72: test_fts3expr "ab NEAR/321 cd"
! 73: } {NEAR/321 {PHRASE 3 0 ab} {PHRASE 3 0 cd}}
! 74: do_test fts3expr-1.6.8 {
! 75: test_fts3expr "ab NEAR/21 cd"
! 76: } {NEAR/21 {PHRASE 3 0 ab} {PHRASE 3 0 cd}}
! 77:
! 78: do_test fts3expr-1.7 {
! 79: test_fts3expr {"one two three"}
! 80: } {PHRASE 3 0 one two three}
! 81: do_test fts3expr-1.8.1 {
! 82: test_fts3expr {zero "one two three" four}
! 83: } {AND {AND {PHRASE 3 0 zero} {PHRASE 3 0 one two three}} {PHRASE 3 0 four}}
! 84: do_test fts3expr-1.8.2 {
! 85: test_fts3expr {zero AND "one two three" four}
! 86: } {AND {AND {PHRASE 3 0 zero} {PHRASE 3 0 one two three}} {PHRASE 3 0 four}}
! 87: do_test fts3expr-1.8.3 {
! 88: test_fts3expr {zero "one two three" AND four}
! 89: } {AND {AND {PHRASE 3 0 zero} {PHRASE 3 0 one two three}} {PHRASE 3 0 four}}
! 90: do_test fts3expr-1.8.4 {
! 91: test_fts3expr {zero AND "one two three" AND four}
! 92: } {AND {AND {PHRASE 3 0 zero} {PHRASE 3 0 one two three}} {PHRASE 3 0 four}}
! 93: do_test fts3expr-1.9.1 {
! 94: test_fts3expr {"one* two three"}
! 95: } {PHRASE 3 0 one+ two three}
! 96: do_test fts3expr-1.9.2 {
! 97: test_fts3expr {"one two* three"}
! 98: } {PHRASE 3 0 one two+ three}
! 99: do_test fts3expr-1.9.3 {
! 100: test_fts3expr {"one* two* three"}
! 101: } {PHRASE 3 0 one+ two+ three}
! 102: do_test fts3expr-1.9.4 {
! 103: test_fts3expr {"one two three*"}
! 104: } {PHRASE 3 0 one two three+}
! 105: do_test fts3expr-1.9.5 {
! 106: test_fts3expr {"one* two three*"}
! 107: } {PHRASE 3 0 one+ two three+}
! 108: do_test fts3expr-1.9.6 {
! 109: test_fts3expr {"one two* three*"}
! 110: } {PHRASE 3 0 one two+ three+}
! 111: do_test fts3expr-1.9.7 {
! 112: test_fts3expr {"one* two* three*"}
! 113: } {PHRASE 3 0 one+ two+ three+}
! 114:
! 115: do_test fts3expr-1.10 {
! 116: test_fts3expr {one* two}
! 117: } {AND {PHRASE 3 0 one+} {PHRASE 3 0 two}}
! 118: do_test fts3expr-1.11 {
! 119: test_fts3expr {one two*}
! 120: } {AND {PHRASE 3 0 one} {PHRASE 3 0 two+}}
! 121:
! 122: do_test fts3expr-1.14 {
! 123: test_fts3expr {a:one two}
! 124: } {AND {PHRASE 0 0 one} {PHRASE 3 0 two}}
! 125: do_test fts3expr-1.15.1 {
! 126: test_fts3expr {one b:two}
! 127: } {AND {PHRASE 3 0 one} {PHRASE 1 0 two}}
! 128: do_test fts3expr-1.15.2 {
! 129: test_fts3expr {one B:two}
! 130: } {AND {PHRASE 3 0 one} {PHRASE 1 0 two}}
! 131:
! 132: do_test fts3expr-1.16 {
! 133: test_fts3expr {one AND two AND three AND four AND five}
! 134: } [list AND \
! 135: [list AND \
! 136: [list AND \
! 137: [list AND {PHRASE 3 0 one} {PHRASE 3 0 two}] \
! 138: {PHRASE 3 0 three} \
! 139: ] \
! 140: {PHRASE 3 0 four} \
! 141: ] \
! 142: {PHRASE 3 0 five} \
! 143: ]
! 144: do_test fts3expr-1.17 {
! 145: test_fts3expr {(one AND two) AND ((three AND four) AND five)}
! 146: } [list AND \
! 147: [list AND {PHRASE 3 0 one} {PHRASE 3 0 two}] \
! 148: [list AND \
! 149: [list AND {PHRASE 3 0 three} {PHRASE 3 0 four}] \
! 150: {PHRASE 3 0 five} \
! 151: ] \
! 152: ]
! 153: do_test fts3expr-1.18 {
! 154: test_fts3expr {(one AND two) OR ((three AND four) AND five)}
! 155: } [list OR \
! 156: [list AND {PHRASE 3 0 one} {PHRASE 3 0 two}] \
! 157: [list AND \
! 158: [list AND {PHRASE 3 0 three} {PHRASE 3 0 four}] \
! 159: {PHRASE 3 0 five} \
! 160: ] \
! 161: ]
! 162: do_test fts3expr-1.19 {
! 163: test_fts3expr {(one AND two) AND ((three AND four) OR five)}
! 164: } [list AND \
! 165: [list AND {PHRASE 3 0 one} {PHRASE 3 0 two}] \
! 166: [list OR \
! 167: [list AND {PHRASE 3 0 three} {PHRASE 3 0 four}] \
! 168: {PHRASE 3 0 five} \
! 169: ] \
! 170: ]
! 171: do_test fts3expr-1.20 {
! 172: test_fts3expr {(one OR two) AND ((three OR four) AND five)}
! 173: } [list AND \
! 174: [list OR {PHRASE 3 0 one} {PHRASE 3 0 two}] \
! 175: [list AND \
! 176: [list OR {PHRASE 3 0 three} {PHRASE 3 0 four}] \
! 177: {PHRASE 3 0 five} \
! 178: ] \
! 179: ]
! 180: do_test fts3expr-1.21 {
! 181: test_fts3expr {(one OR two) AND ((three NOT four) AND five)}
! 182: } [list AND \
! 183: [list OR {PHRASE 3 0 one} {PHRASE 3 0 two}] \
! 184: [list AND \
! 185: [list NOT {PHRASE 3 0 three} {PHRASE 3 0 four}] \
! 186: {PHRASE 3 0 five} \
! 187: ] \
! 188: ]
! 189: do_test fts3expr-1.22 {
! 190: test_fts3expr {(one OR two) NOT ((three OR four) AND five)}
! 191: } [list NOT \
! 192: [list OR {PHRASE 3 0 one} {PHRASE 3 0 two}] \
! 193: [list AND \
! 194: [list OR {PHRASE 3 0 three} {PHRASE 3 0 four}] \
! 195: {PHRASE 3 0 five} \
! 196: ] \
! 197: ]
! 198: do_test fts3expr-1.23 {
! 199: test_fts3expr {(((((one OR two))))) NOT (((((three OR four))) AND five))}
! 200: } [list NOT \
! 201: [list OR {PHRASE 3 0 one} {PHRASE 3 0 two}] \
! 202: [list AND \
! 203: [list OR {PHRASE 3 0 three} {PHRASE 3 0 four}] \
! 204: {PHRASE 3 0 five} \
! 205: ] \
! 206: ]
! 207: do_test fts3expr-1.24 {
! 208: test_fts3expr {one NEAR two}
! 209: } [list NEAR/10 {PHRASE 3 0 one} {PHRASE 3 0 two}]
! 210: do_test fts3expr-1.25 {
! 211: test_fts3expr {(one NEAR two)}
! 212: } [list NEAR/10 {PHRASE 3 0 one} {PHRASE 3 0 two}]
! 213: do_test fts3expr-1.26 {
! 214: test_fts3expr {((((((one NEAR two))))))}
! 215: } [list NEAR/10 {PHRASE 3 0 one} {PHRASE 3 0 two}]
! 216: do_test fts3expr-1.27 {
! 217: test_fts3expr {(one NEAR two) OR ((three OR four) AND five)}
! 218: } [list OR \
! 219: [list NEAR/10 {PHRASE 3 0 one} {PHRASE 3 0 two}] \
! 220: [list AND \
! 221: [list OR {PHRASE 3 0 three} {PHRASE 3 0 four}] \
! 222: {PHRASE 3 0 five} \
! 223: ] \
! 224: ]
! 225: do_test fts3expr-1.28 {
! 226: test_fts3expr {(one NEAR/321 two) OR ((three OR four) AND five)}
! 227: } [list OR \
! 228: [list NEAR/321 {PHRASE 3 0 one} {PHRASE 3 0 two}] \
! 229: [list AND \
! 230: [list OR {PHRASE 3 0 three} {PHRASE 3 0 four}] \
! 231: {PHRASE 3 0 five} \
! 232: ] \
! 233: ]
! 234:
! 235: proc strip_phrase_data {L} {
! 236: if {[lindex $L 0] eq "PHRASE"} {
! 237: return [lrange $L 3 end]
! 238: }
! 239: return [list \
! 240: [lindex $L 0] \
! 241: [strip_phrase_data [lindex $L 1]] \
! 242: [strip_phrase_data [lindex $L 2]] \
! 243: ]
! 244: }
! 245: proc test_fts3expr2 {expr} {
! 246: strip_phrase_data [
! 247: db one {SELECT fts3_exprtest('simple', $expr, 'a', 'b', 'c')}
! 248: ]
! 249: }
! 250: do_test fts3expr-2.1 {
! 251: test_fts3expr2 "ab OR cd AND ef"
! 252: } {OR ab {AND cd ef}}
! 253: do_test fts3expr-2.2 {
! 254: test_fts3expr2 "cd AND ef OR ab"
! 255: } {OR {AND cd ef} ab}
! 256: do_test fts3expr-2.3 {
! 257: test_fts3expr2 "ab AND cd AND ef OR gh"
! 258: } {OR {AND {AND ab cd} ef} gh}
! 259: do_test fts3expr-2.4 {
! 260: test_fts3expr2 "ab AND cd OR ef AND gh"
! 261: } {OR {AND ab cd} {AND ef gh}}
! 262: do_test fts3expr-2.5 {
! 263: test_fts3expr2 "ab cd"
! 264: } {AND ab cd}
! 265:
! 266: do_test fts3expr-3.1 {
! 267: test_fts3expr2 "(ab OR cd) AND ef"
! 268: } {AND {OR ab cd} ef}
! 269: do_test fts3expr-3.2 {
! 270: test_fts3expr2 "ef AND (ab OR cd)"
! 271: } {AND ef {OR ab cd}}
! 272: do_test fts3expr-3.3 {
! 273: test_fts3expr2 "(ab OR cd)"
! 274: } {OR ab cd}
! 275: do_test fts3expr-3.4 {
! 276: test_fts3expr2 "(((ab OR cd)))"
! 277: } {OR ab cd}
! 278:
! 279: do_test fts3expr-3.5 {
! 280: test_fts3expr2 "one AND (two NEAR three)"
! 281: } {AND one {NEAR/10 two three}}
! 282: do_test fts3expr-3.6 {
! 283: test_fts3expr2 "one (two NEAR three)"
! 284: } {AND one {NEAR/10 two three}}
! 285: do_test fts3expr-3.7 {
! 286: test_fts3expr2 "(two NEAR three) one"
! 287: } {AND {NEAR/10 two three} one}
! 288: do_test fts3expr-3.8 {
! 289: test_fts3expr2 "(two NEAR three) AND one"
! 290: } {AND {NEAR/10 two three} one}
! 291: do_test fts3expr-3.9 {
! 292: test_fts3expr2 "(two NEAR three) (four five)"
! 293: } {AND {NEAR/10 two three} {AND four five}}
! 294: do_test fts3expr-3.10 {
! 295: test_fts3expr2 "(two NEAR three) AND (four five)"
! 296: } {AND {NEAR/10 two three} {AND four five}}
! 297: do_test fts3expr-3.11 {
! 298: test_fts3expr2 "(two NEAR three) (four NEAR five)"
! 299: } {AND {NEAR/10 two three} {NEAR/10 four five}}
! 300: do_test fts3expr-3.12 {
! 301: test_fts3expr2 "(two NEAR three) OR (four NEAR five)"
! 302: } {OR {NEAR/10 two three} {NEAR/10 four five}}
! 303:
! 304: do_test fts3expr-3.13 {
! 305: test_fts3expr2 "(two NEAR/1a three)"
! 306: } {AND {AND {AND two near} 1a} three}
! 307:
! 308: do_test fts3expr-3.14 {
! 309: test_fts3expr2 "(two NEAR// three)"
! 310: } {AND {AND two near} three}
! 311: do_test fts3expr-3.15 {
! 312: test_fts3expr2 "(two NEAR/: three)"
! 313: } {AND {AND two near} three}
! 314:
! 315: do_test fts3expr-3.16 {
! 316: test_fts3expr2 "(two NEAR three)OR(four NEAR five)"
! 317: } {OR {NEAR/10 two three} {NEAR/10 four five}}
! 318: do_test fts3expr-3.17 {
! 319: test_fts3expr2 "(two NEAR three)OR\"four five\""
! 320: } {OR {NEAR/10 two three} {four five}}
! 321: do_test fts3expr-3.18 {
! 322: test_fts3expr2 "one \u0080wo"
! 323: } "AND one \u0080wo"
! 324:
! 325:
! 326:
! 327: #------------------------------------------------------------------------
! 328: # The following tests, fts3expr-4.*, test the parsers response to syntax
! 329: # errors in query expressions. This is done using a real fts3 table and
! 330: # MATCH clauses, not the parser test interface.
! 331: #
! 332: do_test fts3expr-4.1 {
! 333: execsql { CREATE VIRTUAL TABLE t1 USING fts3(a, b, c) }
! 334: } {}
! 335:
! 336: # Mismatched parenthesis:
! 337: do_test fts3expr-4.2.1 {
! 338: catchsql { SELECT * FROM t1 WHERE t1 MATCH 'example AND (hello OR world))' }
! 339: } {1 {malformed MATCH expression: [example AND (hello OR world))]}}
! 340: do_test fts3expr-4.2.2 {
! 341: catchsql { SELECT * FROM t1 WHERE t1 MATCH 'example AND (hello OR world' }
! 342: } {1 {malformed MATCH expression: [example AND (hello OR world]}}
! 343: do_test fts3expr-4.2.3 {
! 344: catchsql { SELECT * FROM t1 WHERE t1 MATCH '(hello' }
! 345: } {1 {malformed MATCH expression: [(hello]}}
! 346: do_test fts3expr-4.2.4 {
! 347: catchsql { SELECT * FROM t1 WHERE t1 MATCH '(' }
! 348: } {1 {malformed MATCH expression: [(]}}
! 349: do_test fts3expr-4.2.5 {
! 350: catchsql { SELECT * FROM t1 WHERE t1 MATCH ')' }
! 351: } {1 {malformed MATCH expression: [)]}}
! 352:
! 353: do_test fts3expr-4.2.6 {
! 354: catchsql { SELECT * FROM t1 WHERE t1 MATCH 'example (hello world' }
! 355: } {1 {malformed MATCH expression: [example (hello world]}}
! 356:
! 357: # Unterminated quotation marks:
! 358: do_test fts3expr-4.3.1 {
! 359: catchsql { SELECT * FROM t1 WHERE t1 MATCH 'example OR "hello world' }
! 360: } {1 {malformed MATCH expression: [example OR "hello world]}}
! 361: do_test fts3expr-4.3.2 {
! 362: catchsql { SELECT * FROM t1 WHERE t1 MATCH 'example OR hello world"' }
! 363: } {1 {malformed MATCH expression: [example OR hello world"]}}
! 364:
! 365: # Binary operators without the required operands.
! 366: do_test fts3expr-4.4.1 {
! 367: catchsql { SELECT * FROM t1 WHERE t1 MATCH 'OR hello world' }
! 368: } {1 {malformed MATCH expression: [OR hello world]}}
! 369: do_test fts3expr-4.4.2 {
! 370: catchsql { SELECT * FROM t1 WHERE t1 MATCH 'hello world OR' }
! 371: } {1 {malformed MATCH expression: [hello world OR]}}
! 372: do_test fts3expr-4.4.3 {
! 373: catchsql { SELECT * FROM t1 WHERE t1 MATCH 'one (hello world OR) two' }
! 374: } {1 {malformed MATCH expression: [one (hello world OR) two]}}
! 375: do_test fts3expr-4.4.4 {
! 376: catchsql { SELECT * FROM t1 WHERE t1 MATCH 'one (OR hello world) two' }
! 377: } {1 {malformed MATCH expression: [one (OR hello world) two]}}
! 378:
! 379: # NEAR operators with something other than phrases as arguments.
! 380: do_test fts3expr-4.5.1 {
! 381: catchsql { SELECT * FROM t1 WHERE t1 MATCH '(hello OR world) NEAR one' }
! 382: } {1 {malformed MATCH expression: [(hello OR world) NEAR one]}}
! 383: do_test fts3expr-4.5.2 {
! 384: catchsql { SELECT * FROM t1 WHERE t1 MATCH 'one NEAR (hello OR world)' }
! 385: } {1 {malformed MATCH expression: [one NEAR (hello OR world)]}}
! 386:
! 387: #------------------------------------------------------------------------
! 388: # The following OOM tests are designed to cover cases in fts3_expr.c.
! 389: #
! 390: source $testdir/malloc_common.tcl
! 391: do_malloc_test fts3expr-malloc-1 -sqlbody {
! 392: SELECT fts3_exprtest('simple', 'a b c "d e f"', 'a', 'b', 'c')
! 393: }
! 394: do_malloc_test fts3expr-malloc-2 -tclprep {
! 395: set sqlite_fts3_enable_parentheses 0
! 396: } -sqlbody {
! 397: SELECT fts3_exprtest('simple', 'a -b', 'a', 'b', 'c')
! 398: } -cleanup {
! 399: set sqlite_fts3_enable_parentheses 1
! 400: }
! 401:
! 402: #------------------------------------------------------------------------
! 403: # The following tests are not very important. They cover error handling
! 404: # cases in the test code, which makes test coverage easier to measure.
! 405: #
! 406: do_test fts3expr-5.1 {
! 407: catchsql { SELECT fts3_exprtest('simple', 'a b') }
! 408: } {1 {Usage: fts3_exprtest(tokenizer, expr, col1, ...}}
! 409: do_test fts3expr-5.2 {
! 410: catchsql { SELECT fts3_exprtest('doesnotexist', 'a b', 'c') }
! 411: } {1 {No such tokenizer module}}
! 412: do_test fts3expr-5.3 {
! 413: catchsql { SELECT fts3_exprtest('simple', 'a b OR', 'c') }
! 414: } {1 {Error parsing expression}}
! 415:
! 416: #------------------------------------------------------------------------
! 417: # The next set of tests verifies that things actually work as they are
! 418: # supposed to when using the new syntax.
! 419: #
! 420: do_test fts3expr-6.1 {
! 421: execsql {
! 422: CREATE VIRTUAL TABLE t1 USING fts3(a);
! 423: }
! 424: for {set ii 1} {$ii < 32} {incr ii} {
! 425: set v [list]
! 426: if {$ii & 1} { lappend v one }
! 427: if {$ii & 2} { lappend v two }
! 428: if {$ii & 4} { lappend v three }
! 429: if {$ii & 8} { lappend v four }
! 430: if {$ii & 16} { lappend v five }
! 431: execsql { INSERT INTO t1 VALUES($v) }
! 432: }
! 433:
! 434: execsql {SELECT rowid FROM t1 WHERE t1 MATCH 'five four one' ORDER BY rowid}
! 435: } {25 27 29 31}
! 436:
! 437: foreach {id expr res} {
! 438:
! 439: 2 "five four NOT one" {24 26 28 30}
! 440:
! 441: 3 "five AND four OR one"
! 442: {1 3 5 7 9 11 13 15 17 19 21 23 24 25 26 27 28 29 30 31}
! 443:
! 444: 4 "five AND (four OR one)" {17 19 21 23 24 25 26 27 28 29 30 31}
! 445:
! 446: 5 "five NOT (four OR one)" {16 18 20 22}
! 447:
! 448: 6 "(five NOT (four OR one)) OR (five AND (four OR one))"
! 449: {16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31}
! 450:
! 451: 7 "(five OR one) AND two AND three" {7 15 22 23 30 31}
! 452:
! 453: 8 "five OR one AND two AND three"
! 454: {7 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31}
! 455:
! 456: 9 "five OR one two three"
! 457: {7 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31}
! 458:
! 459: 10 "five OR \"one two three\""
! 460: {7 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31}
! 461:
! 462: 11 "one two OR four five NOT three" {3 7 11 15 19 23 24 25 26 27 31}
! 463:
! 464: 12 "(one two OR four five) NOT three" {3 11 19 24 25 26 27}
! 465:
! 466: 13 "((((((one two OR four five)))))) NOT three" {3 11 19 24 25 26 27}
! 467:
! 468: } {
! 469: do_test fts3expr-6.1.$id {
! 470: execsql { SELECT rowid FROM t1 WHERE t1 MATCH $expr ORDER BY rowid }
! 471: } $res
! 472: }
! 473:
! 474: set sqlite_fts3_enable_parentheses 0
! 475: foreach {id expr res} {
! 476: 1 "one -two three" {5 13 21 29}
! 477: 2 "-two one three" {5 13 21 29}
! 478: 3 "one three -two" {5 13 21 29}
! 479: 4 "-one -two three" {4 12 20 28}
! 480: 5 "three -one -two" {4 12 20 28}
! 481: 6 "-one three -two" {4 12 20 28}
! 482: } {
! 483: do_test fts3expr-6.2.$id {
! 484: execsql { SELECT rowid FROM t1 WHERE t1 MATCH $expr ORDER BY rowid }
! 485: } $res
! 486: }
! 487: set sqlite_fts3_enable_parentheses 1
! 488:
! 489: do_test fts3expr-7.1 {
! 490: execsql {
! 491: CREATE VIRTUAL TABLE test USING fts3 (keyword);
! 492: INSERT INTO test VALUES ('abc');
! 493: SELECT * FROM test WHERE keyword MATCH '""';
! 494: }
! 495: } {}
! 496:
! 497:
! 498: set sqlite_fts3_enable_parentheses 0
! 499: finish_test
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/icons/cvsweb/back.gif){kind=icon}
Return to fts3expr.test CVS log ![[TXT]](/icons/cvsweb/text.gif){kind=icon}
![[DIR]](/icons/cvsweb/dir.gif){kind=icon}
Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test