summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorserg@sergbook.mysql.com <>2002-09-17 21:04:10 +0200
committerserg@sergbook.mysql.com <>2002-09-17 21:04:10 +0200
commit7118d006b4aec093081b61a2776bc264a39c9fe6 (patch)
treefb168913574627a302f9436c98a285c1f7ea7b97 /mysql-test
parent1ec47f10cc77d41267d856c573da48bc54896c93 (diff)
downloadmariadb-git-7118d006b4aec093081b61a2776bc264a39c9fe6.tar.gz
ft-boolean + ORDER BY (ftb tree reusing) bug
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/fulltext_order_by.result15
-rw-r--r--mysql-test/t/fulltext_order_by.test14
2 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/r/fulltext_order_by.result b/mysql-test/r/fulltext_order_by.result
index 8d88b8d6ebf..c0e72ff789f 100644
--- a/mysql-test/r/fulltext_order_by.result
+++ b/mysql-test/r/fulltext_order_by.result
@@ -64,3 +64,18 @@ a rel
4 1
7 1
drop table t1;
+CREATE TABLE t1 (
+a INT AUTO_INCREMENT PRIMARY KEY,
+message CHAR(20),
+FULLTEXT(message)
+);
+INSERT INTO t1 (message) VALUES ("testbug"),("testbug foobar");
+SELECT a, MATCH (message) AGAINST ('t* f*' IN BOOLEAN MODE) as rel FROM t1;
+a rel
+1 1
+2 2
+SELECT a, MATCH (message) AGAINST ('t* f*' IN BOOLEAN MODE) as rel FROM t1 ORDER BY rel,a;
+a rel
+1 1
+2 2
+drop table t1;
diff --git a/mysql-test/t/fulltext_order_by.test b/mysql-test/t/fulltext_order_by.test
index d5cb99ef0ee..3b60ee77db2 100644
--- a/mysql-test/t/fulltext_order_by.test
+++ b/mysql-test/t/fulltext_order_by.test
@@ -30,3 +30,17 @@ SELECT a, MATCH (message) AGAINST ('steve') as rel FROM t1 ORDER BY rel;
SELECT a, MATCH (message) AGAINST ('steve' IN BOOLEAN MODE) as rel FROM t1 ORDER BY rel;
drop table t1;
+
+#
+# reused boolean scan bug
+#
+CREATE TABLE t1 (
+ a INT AUTO_INCREMENT PRIMARY KEY,
+ message CHAR(20),
+ FULLTEXT(message)
+);
+INSERT INTO t1 (message) VALUES ("testbug"),("testbug foobar");
+SELECT a, MATCH (message) AGAINST ('t* f*' IN BOOLEAN MODE) as rel FROM t1;
+SELECT a, MATCH (message) AGAINST ('t* f*' IN BOOLEAN MODE) as rel FROM t1 ORDER BY rel,a;
+drop table t1;
+