1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/main/fulltext_multi.test b/mysql-test/main/fulltext_multi.test
new file mode 100644
index 00000000..fe64fe88
--- /dev/null
+++ b/mysql-test/main/fulltext_multi.test
@@ -0,0 +1,25 @@
+# several FULLTEXT indexes in one table test
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+CREATE TABLE t1 (
+  a int(11) NOT NULL auto_increment,
+  b text,
+  c varchar(254) default NULL,
+  PRIMARY KEY (a),
+  FULLTEXT KEY bb(b),
+  FULLTEXT KEY cc(c),
+  FULLTEXT KEY a(b,c)
+);
+
+INSERT INTO t1 VALUES (1,'lala lolo lili','oooo aaaa pppp');
+INSERT INTO t1 VALUES (2,'asdf fdsa','lkjh fghj');
+INSERT INTO t1 VALUES (3,'qpwoei','zmxnvb');
+
+SELECT a, round(MATCH  b  AGAINST ('lala lkjh'),5) FROM t1;
+SELECT a, round(MATCH  c  AGAINST ('lala lkjh'),5) FROM t1;
+SELECT a, round(MATCH b,c AGAINST ('lala lkjh'),5) FROM t1;
+drop table t1;
+
+# End of 4.1 tests