1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext_order_by.test b/mysql-test/t/fulltext_order_by.test
new file mode 100644
index 00000000000..05947be51a4
--- /dev/null
+++ b/mysql-test/t/fulltext_order_by.test
@@ -0,0 +1,23 @@
+use test;
+DROP TABLE IF EXISTS test;
+CREATE TABLE test (
+  a INT AUTO_INCREMENT PRIMARY KEY,
+  message CHAR(20),
+  FULLTEXT(message)
+) comment = 'original testcase by sroussey@network54.com';
+INSERT INTO test (message) VALUES ("Testing"),("table"),("testbug"),
+        ("steve"),("is"),("cool"),("steve is cool");
+# basic MATCH
+SELECT a, MATCH (message) AGAINST ('steve') FROM test WHERE MATCH (message) AGAINST ('steve');
+
+# MATCH + ORDER BY (with ft-ranges)
+SELECT a, MATCH (message) AGAINST ('steve') FROM test WHERE MATCH (message) AGAINST ('steve') ORDER BY a;
+
+# MATCH + ORDER BY (with normal ranges) + UNIQUE
+SELECT a, MATCH (message) AGAINST ('steve') FROM test WHERE a in (2,7,4) and MATCH (message) AGAINST ('steve') ORDER BY a DESC;
+
+# MATCH + ORDER BY + UNIQUE (const_table)
+SELECT a, MATCH (message) AGAINST ('steve') FROM test WHERE a=7 and MATCH (message) AGAINST ('steve') ORDER BY 1;
+
+# ORDER BY MATCH
+SELECT a, MATCH (message) AGAINST ('steve') as rel FROM test ORDER BY rel;