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
commit064c990b12611d1a4b2a7d5a33b616837460e1d5 (patch)
tree9a63f438d090152a5936abcef3fa7ab0883e91a8 /mysql-test/t/fulltext.test
parent7a305e31e872dfee2301e0c48bf7094d0a62490c (diff)
parent7c670fc3e142ddb2c5fb948fc619dfbd6ccffaa8 (diff)
downloadmariadb-git-064c990b12611d1a4b2a7d5a33b616837460e1d5.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;