diff options
| author | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2008-12-09 16:11:01 +0400 |
|---|---|---|
| committer | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2008-12-09 16:11:01 +0400 |
| commit | d49d4298e9ca332fc345e2af5b19a932bb053215 (patch) | |
| tree | 0c40807e00943fcb4f86ba852c163a782cbd1d7e /mysql-test/r | |
| parent | 681a2d1a53999f70e5437f62d8478caade48f3b3 (diff) | |
| parent | 121ed547e91b9d1227303233dd5c70a1adf268a0 (diff) | |
| download | mariadb-git-d49d4298e9ca332fc345e2af5b19a932bb053215.tar.gz | |
automerge
Diffstat (limited to 'mysql-test/r')
| -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 e73f8af405c..6821691c9d0 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -497,3 +497,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; |