diff options
| author | unknown <monty@tik.mysql.fi> | 2001-08-04 00:10:00 +0300 |
|---|---|---|
| committer | unknown <monty@tik.mysql.fi> | 2001-08-04 00:10:00 +0300 |
| commit | 9d7a659b21d5afe1073adaa5a9320022683a23cc (patch) | |
| tree | e66ed14abc4942fc09ac21472d60a38c725d4f39 /mysql-test/t/fulltext.test | |
| parent | 9563e658c986be854453215d22c7e090c4132df6 (diff) | |
| download | mariadb-git-9d7a659b21d5afe1073adaa5a9320022683a23cc.tar.gz | |
Fix when using --without-server --with-thread-safe-client
Added prototype for my_thread_end
New error message for MATCH
Give error when using myisamchk --force --readonly
BitKeeper/deleted/.del-fulltext_join.test~e347c8f04405c916:
Delete: mysql-test/t/fulltext_join.test
Docs/manual.texi:
Added node to fulltext
configure.in:
Fix when using --without-server --with-thread-safe-client
include/mysql_com.h:
Added prototype for my_thread_end
include/mysqld_error.h:
New error message for MATCH
myisam/myisamchk.c:
Give error when using --force --readonly
mysql-test/t/fulltext.test:
Added test for error conditons with fulltext
sql/item_func.cc:
Fixed error messages when using MATCH ... AGAINST
sql/mysqld.cc:
Portability fix
sql/share/czech/errmsg.txt:
New error message when using MATCH
sql/share/danish/errmsg.txt:
New error message when using MATCH
sql/share/dutch/errmsg.txt:
New error message when using MATCH
sql/share/english/errmsg.txt:
New error message when using MATCH
sql/share/estonian/errmsg.txt:
New error message when using MATCH
sql/share/french/errmsg.txt:
New error message when using MATCH
sql/share/german/errmsg.txt:
New error message when using MATCH
sql/share/greek/errmsg.txt:
New error message when using MATCH
sql/share/hungarian/errmsg.txt:
New error message when using MATCH
sql/share/italian/errmsg.txt:
New error message when using MATCH
sql/share/japanese/errmsg.txt:
New error message when using MATCH
sql/share/korean/errmsg.txt:
New error message when using MATCH
sql/share/norwegian-ny/errmsg.txt:
New error message when using MATCH
sql/share/norwegian/errmsg.txt:
New error message when using MATCH
sql/share/polish/errmsg.txt:
New error message when using MATCH
sql/share/portuguese/errmsg.txt:
New error message when using MATCH
sql/share/romanian/errmsg.txt:
New error message when using MATCH
sql/share/russian/errmsg.txt:
New error message when using MATCH
sql/share/slovak/errmsg.txt:
New error message when using MATCH
sql/share/spanish/errmsg.txt:
New error message when using MATCH
sql/share/swedish/errmsg.OLD:
New error message when using MATCH
sql/share/swedish/errmsg.txt:
New error message when using MATCH
Diffstat (limited to 'mysql-test/t/fulltext.test')
| -rw-r--r-- | mysql-test/t/fulltext.test | 23 |
1 files changed, 21 insertions, 2 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test index 064219c6ad3..153fdefd960 100644 --- a/mysql-test/t/fulltext.test +++ b/mysql-test/t/fulltext.test @@ -2,7 +2,7 @@ # Test of fulltext index # -drop table if exists t1,t2; +drop table if exists t1,t2,t3; CREATE TABLE t1 (a VARCHAR(200), b TEXT, FULLTEXT (a,b)); INSERT INTO t1 VALUES('MySQL has now support', 'for full-text search'),('Full-text indexes', 'are called collections'),('Only MyISAM tables','support collections'),('Function MATCH ... AGAINST()','is used to do a search'),('Full-text search in MySQL', 'implements vector space model'); @@ -61,4 +61,23 @@ select * from t2 where MATCH inhalt AGAINST (NULL); select * from t2 where MATCH inhalt AGAINST ('foobar'); select * from t2 having MATCH inhalt AGAINST ('foobar'); -drop table t1,t2; +# +# check of fulltext errors +# + +CREATE TABLE t3 ( + ticket int(11), + inhalt text, + KEY tig (ticket), + fulltext index tix (inhalt) +); + +--error 1210 +select * from t2 having MATCH inhalt AGAINST (t1.id); +--error 1210 +select * from t2 having MATCH ticket AGAINST ('foobar'); +--error 1210 +select * from t2,t3 having MATCH (t2.inhalt,t3.inhalt) AGAINST ('foobar'); + +drop table t1,t2,t3; + |