summaryrefslogtreecommitdiff
path: root/mysql-test/t/fulltext.test
diff options
context:
space:
mode:
authorAnurag Shekhar <anurag.shekhar@sun.com>2009-07-15 15:43:45 +0530
committerAnurag Shekhar <anurag.shekhar@sun.com>2009-07-15 15:43:45 +0530
commit0ad57bef5dafbd0f7bdab4b43790f30efb614034 (patch)
tree9a63f438d090152a5936abcef3fa7ab0883e91a8 /mysql-test/t/fulltext.test
parentada6ad4570c941fdf0ef767536c23a18ac178d68 (diff)
parentc77b836ab8c12e6008f1dd63a7eb510d534d6a74 (diff)
downloadmariadb-git-0ad57bef5dafbd0f7bdab4b43790f30efb614034.tar.gz
merging with 5.0 bugteam tree
Diffstat (limited to 'mysql-test/t/fulltext.test')
-rw-r--r--mysql-test/t/fulltext.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test
index b565485bab9..80c8658d35c 100644
--- a/mysql-test/t/fulltext.test
+++ b/mysql-test/t/fulltext.test
@@ -471,3 +471,16 @@ CREATE TABLE t1(a VARCHAR(64), FULLTEXT(a));
INSERT INTO t1 VALUES('awrd bwrd cwrd'),('awrd bwrd cwrd'),('awrd bwrd cwrd');
SELECT * FROM t1 WHERE MATCH(a) AGAINST('+awrd bwrd* +cwrd*' IN BOOLEAN MODE);
DROP TABLE t1;
+
+#
+# BUG#37740 Server crashes on execute statement with full text search and match against
+#
+CREATE TABLE t1 (col text, FULLTEXT KEY full_text (col));
+
+PREPARE s FROM
+ "SELECT MATCH (col) AGAINST('findme') FROM t1 ORDER BY MATCH (col) AGAINST('findme')"
+ ;
+
+EXECUTE s;
+DEALLOCATE PREPARE s;
+DROP TABLE t1;