diff options
author | unknown <serg@sergbook.mysql.com> | 2002-09-17 21:04:10 +0200 |
---|---|---|
committer | unknown <serg@sergbook.mysql.com> | 2002-09-17 21:04:10 +0200 |
commit | 5f6bd7ddb14d5508fc51d032d53454c05cb009aa (patch) | |
tree | fb168913574627a302f9436c98a285c1f7ea7b97 /mysql-test/r/fulltext_order_by.result | |
parent | 590a0ed3fce8576fa85bb78b1727b2d34782ca8b (diff) | |
download | mariadb-git-5f6bd7ddb14d5508fc51d032d53454c05cb009aa.tar.gz |
ft-boolean + ORDER BY (ftb tree reusing) bug
Diffstat (limited to 'mysql-test/r/fulltext_order_by.result')
-rw-r--r-- | mysql-test/r/fulltext_order_by.result | 15 |
1 files changed, 15 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; |