summaryrefslogtreecommitdiff
path: root/mysql-test/t/fulltext.test
diff options
context:
space:
mode:
authorsasha@mysql.sashanet.com <>2001-03-01 11:49:06 -0700
committersasha@mysql.sashanet.com <>2001-03-01 11:49:06 -0700
commitbc52b4a28032c8922099bd9d59986d7874feec8e (patch)
tree2e4d93e47910811a9995561ff75ede1c04afc2d1 /mysql-test/t/fulltext.test
parent21c601760c3bf85d16503e484155d49c0495d092 (diff)
downloadmariadb-git-bc52b4a28032c8922099bd9d59986d7874feec8e.tar.gz
text/blob fields in some cases were not handled properly
Diffstat (limited to 'mysql-test/t/fulltext.test')
-rw-r--r--mysql-test/t/fulltext.test17
1 files changed, 9 insertions, 8 deletions
diff --git a/mysql-test/t/fulltext.test b/mysql-test/t/fulltext.test
index 555c543664e..29c115f2bdd 100644
--- a/mysql-test/t/fulltext.test
+++ b/mysql-test/t/fulltext.test
@@ -48,8 +48,8 @@ drop table t1,t2;
# check for bug reported by Stephan Skusa
-drop table if exists fulltextTEST;
-CREATE TABLE fulltextTEST (
+drop table if exists t1;
+CREATE TABLE t1 (
field1 varchar(40) NOT NULL,
field2 varchar(20) NOT NULL,
field3 varchar(40) NOT NULL,
@@ -57,9 +57,10 @@ CREATE TABLE fulltextTEST (
FULLTEXT idx_fulltext (field1, field2, field3)
);
-INSERT INTO fulltextTEST VALUES ( 'test1', 'test1.1', 'test1.1.1');
-INSERT INTO fulltextTEST VALUES ( 'test2', 'test2.1', 'test2.1.1');
-select *
-from fulltextTEST
-where MATCH (field1,field2,field3) AGAINST (NULL);
-drop table fulltextTEST;
+INSERT INTO t1 VALUES ( 'test1', 'test1.1', 'test1.1.1');
+INSERT INTO t1 VALUES ( 'test2', 'test2.1', 'test2.1.1');
+#select *
+#from t1
+#where MATCH (field1,field2,field3) AGAINST (NULL);
+drop table t1;
+