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 | |
| 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')
| -rw-r--r-- | mysql-test/r/fulltext.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/fulltext.test | 8 |
2 files changed, 14 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); diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 1f8a3b82cfd..64f77b4f0b7 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -400,6 +400,14 @@ SELECT * FROM t1 WHERE MATCH(a) AGAINST('test'); DROP TABLE t1; # +# BUG#11392 - fulltext search bug +# +CREATE TABLE t1(a TEXT); +INSERT INTO t1 VALUES(' aaaaa aaaa'); +SELECT * FROM t1 WHERE MATCH(a) AGAINST ('"aaaa"' IN BOOLEAN MODE); +DROP TABLE t1; + +# # BUG#29445 - match ... against () never returns # CREATE TABLE t1(a VARCHAR(20), FULLTEXT(a)); |