| # 2014 January 4 |
| # |
| # The author disclaims copyright to this source code. In place of |
| # a legal notice, here is a blessing: |
| # |
| # May you do good and not evil. |
| # May you find forgiveness for yourself and forgive others. |
| # May you share freely, never taking more than you give. |
| # |
| #************************************************************************* |
| # This file implements regression tests for SQLite library. The |
| # focus of this script is testing the FTS3 module. |
| # |
| |
| set testdir [file dirname $argv0] |
| source $testdir/tester.tcl |
| set ::testprefix fts3join |
| |
| # If SQLITE_ENABLE_FTS3 is defined, omit this file. |
| ifcapable !fts3 { |
| finish_test |
| return |
| } |
| |
| do_execsql_test 1.0 { |
| CREATE VIRTUAL TABLE ft1 USING fts4(x); |
| INSERT INTO ft1 VALUES('aaa aaa'); |
| INSERT INTO ft1 VALUES('aaa bbb'); |
| INSERT INTO ft1 VALUES('bbb aaa'); |
| INSERT INTO ft1 VALUES('bbb bbb'); |
| |
| CREATE TABLE t1(id, y); |
| INSERT INTO t1 VALUES(1, 'aaa'); |
| INSERT INTO t1 VALUES(2, 'bbb'); |
| } |
| |
| do_execsql_test 1.1 { |
| SELECT docid FROM ft1, t1 WHERE ft1 MATCH y AND id=1; |
| } {1 2 3} |
| |
| do_execsql_test 1.2 { |
| SELECT docid FROM ft1, t1 WHERE ft1 MATCH y AND id=1 ORDER BY docid; |
| } {1 2 3} |
| |
| do_execsql_test 2.0 { |
| CREATE VIRTUAL TABLE ft2 USING fts4(x); |
| CREATE VIRTUAL TABLE ft3 USING fts4(y); |
| |
| INSERT INTO ft2 VALUES('abc'); |
| INSERT INTO ft2 VALUES('def'); |
| INSERT INTO ft3 VALUES('ghi'); |
| INSERT INTO ft3 VALUES('abc'); |
| } |
| |
| do_execsql_test 2.1 { SELECT * FROM ft2, ft3 WHERE x MATCH y; } {abc abc} |
| do_execsql_test 2.2 { SELECT * FROM ft2, ft3 WHERE y MATCH x; } {abc abc} |
| do_execsql_test 2.3 { SELECT * FROM ft3, ft2 WHERE x MATCH y; } {abc abc} |
| do_execsql_test 2.4 { SELECT * FROM ft3, ft2 WHERE y MATCH x; } {abc abc} |
| |
| do_catchsql_test 2.5 { |
| SELECT * FROM ft3, ft2 WHERE y MATCH x AND x MATCH y; |
| } {1 {unable to use function MATCH in the requested context}} |
| |
| finish_test |
| |
| |