diff options
| author | unknown <monty@mashka.mysql.fi> | 2002-09-18 00:44:58 +0300 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2002-09-18 00:44:58 +0300 |
| commit | 00b310fa54d6ab7dabcb626595ff35a980a85d9c (patch) | |
| tree | 3b3ac8adddfe90dfa853b5ab7001f1226a371b45 /mysql-test/t | |
| parent | f0fbecca27b1a5b754636b9372b37454c28ec336 (diff) | |
| parent | 475f7300e9a49933004a679d7f09a02122663aa3 (diff) | |
| download | mariadb-git-00b310fa54d6ab7dabcb626595ff35a980a85d9c.tar.gz | |
Merge
Docs/manual.texi:
SCCS merged
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/fulltext_order_by.test | 14 |
1 files changed, 14 insertions, 0 deletions
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; + |