diff options
| author | Sergey Vojtovich <svoj@mysql.com> | 2008-12-09 13:27:46 +0400 |
|---|---|---|
| committer | Sergey Vojtovich <svoj@mysql.com> | 2008-12-09 13:27:46 +0400 |
| commit | 0e62ee8e798008696c1c376081e08a72773e4519 (patch) | |
| tree | 3c60ce09334b484ddf73de3412a8954ff6718af1 /mysql-test/r/fulltext.result | |
| parent | 0d2db9c02023c5867e92c31c53da9c5431042387 (diff) | |
| parent | 34eff0a97974acc4042a1e2be58613ce6fa119f7 (diff) | |
| download | mariadb-git-0e62ee8e798008696c1c376081e08a72773e4519.tar.gz | |
Merge.
Diffstat (limited to 'mysql-test/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index 0124ced40ce..8633bd61681 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -522,3 +522,12 @@ WHERE MATCH(a) AGAINST('test' IN BOOLEAN MODE) AND b=1; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref b b 5 const 4 Using where DROP TABLE t1; +CREATE TABLE t1(a CHAR(10)); +INSERT INTO t1 VALUES('aaa15'); +SELECT MATCH(a) AGAINST('aaa1* aaa14 aaa16' IN BOOLEAN MODE) FROM t1; +MATCH(a) AGAINST('aaa1* aaa14 aaa16' IN BOOLEAN MODE) +1 +SELECT MATCH(a) AGAINST('aaa1* aaa14 aaa15 aaa16' IN BOOLEAN MODE) FROM t1; +MATCH(a) AGAINST('aaa1* aaa14 aaa15 aaa16' IN BOOLEAN MODE) +2 +DROP TABLE t1; |