summaryrefslogtreecommitdiff
path: root/mysql-test/t/fulltext_order_by.test
diff options
context:
space:
mode:
authorunknown <sergefp@mysql.com>2005-08-07 11:03:54 +0000
committerunknown <sergefp@mysql.com>2005-08-07 11:03:54 +0000
commitf3ce475dcec23a51cff93aaa1bbaa27eba978b05 (patch)
tree418be3169a67dfe101f87edef1ffee62e1c08a2e /mysql-test/t/fulltext_order_by.test
parent2b41471429d9db41d64bfb214e29ba57cb3db381 (diff)
parent852dcb75973a612ef5c28645018551ed7bd0055c (diff)
downloadmariadb-git-f3ce475dcec23a51cff93aaa1bbaa27eba978b05.tar.gz
Manual merge
mysql-test/t/fulltext_order_by.test: Auto merged sql/sql_select.cc: Auto merged sql/sql_union.cc: Auto merged
Diffstat (limited to 'mysql-test/t/fulltext_order_by.test')
-rw-r--r--mysql-test/t/fulltext_order_by.test11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext_order_by.test b/mysql-test/t/fulltext_order_by.test
index a0bd7954674..5bad8161a0a 100644
--- a/mysql-test/t/fulltext_order_by.test
+++ b/mysql-test/t/fulltext_order_by.test
@@ -135,6 +135,17 @@ where
order by
match(betreff) against ('+abc' in boolean mode) desc;
+# BUG#11869 part2: used table type doesn't support FULLTEXT indexes error
+(select b.id, b.betreff from t3 b) union
+(select b.id, b.betreff from t3 b)
+order by match(betreff) against ('+abc' in boolean mode) desc;
+
+select distinct b.id, b.betreff from t3 b
+order by match(betreff) against ('+abc' in boolean mode) desc;
+
+select b.id, b.betreff from t3 b group by b.id+1
+order by match(betreff) against ('+abc' in boolean mode) desc;
+
drop table t1,t2,t3;
# End of 4.1 tests