diff options
| author | svoj@june.mysql.com <> | 2007-11-02 13:20:38 +0400 |
|---|---|---|
| committer | svoj@june.mysql.com <> | 2007-11-02 13:20:38 +0400 |
| commit | beb5f7f46293885669d571d1b07ae596d2b576bf (patch) | |
| tree | 4e53d3bf08c7e0be27ef19cee6e921079393490e /mysql-test/r/fulltext.result | |
| parent | 791deb8b780a1cf0806d873dbc1a92d286024999 (diff) | |
| parent | 0ea269caac0ca40fd1882ba432318a3cf0434a6b (diff) | |
| download | mariadb-git-beb5f7f46293885669d571d1b07ae596d2b576bf.tar.gz | |
Merge mysql.com:/home/svoj/devel/mysql/BUG11392/mysql-5.0-engines
into mysql.com:/home/svoj/devel/mysql/BUG11392/mysql-5.1-engines
Diffstat (limited to 'mysql-test/r/fulltext.result')
| -rw-r--r-- | mysql-test/r/fulltext.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext.result b/mysql-test/r/fulltext.result index 96ebb9bf254..c3fa427127b 100644 --- a/mysql-test/r/fulltext.result +++ b/mysql-test/r/fulltext.result @@ -476,6 +476,12 @@ ALTER TABLE t1 DISABLE KEYS; SELECT * FROM t1 WHERE MATCH(a) AGAINST('test'); ERROR HY000: Can't find FULLTEXT index matching the column list DROP TABLE t1; +CREATE TABLE t1(a TEXT); +INSERT INTO t1 VALUES(' aaaaa aaaa'); +SELECT * FROM t1 WHERE MATCH(a) AGAINST ('"aaaa"' IN BOOLEAN MODE); +a + aaaaa aaaa +DROP TABLE t1; CREATE TABLE t1(a VARCHAR(20), FULLTEXT(a)); INSERT INTO t1 VALUES('Offside'),('City Of God'); SELECT a FROM t1 WHERE MATCH a AGAINST ('+city of*' IN BOOLEAN MODE); |