diff options
author | unknown <sergefp@mysql.com> | 2005-08-06 21:08:28 +0000 |
---|---|---|
committer | unknown <sergefp@mysql.com> | 2005-08-06 21:08:28 +0000 |
commit | 852dcb75973a612ef5c28645018551ed7bd0055c (patch) | |
tree | 3f10d695326e0c90c60ade90588c6342eb72cb17 /mysql-test/t/fulltext_order_by.test | |
parent | 82f674f9e0c40db21f9c9b211f8e097f9b74498b (diff) | |
download | mariadb-git-852dcb75973a612ef5c28645018551ed7bd0055c.tar.gz |
BUG#11869 (cont'd, eliminating "table type doesn't support FULLTEXT" error):
When creating temporary table for UNION, pass TMP_TABLE_FORCE_MYISAM flag to
create_tmp_table if we will be using fulltext function(s) when reading from the
temp. table.
mysql-test/r/fulltext_order_by.result:
Testcase for BUG#11869 (cont'd, eliminating "table type doesn't support FULLTEXT" error)
mysql-test/t/fulltext_order_by.test:
Testcase for BUG#11869 (cont'd, eliminating "table type doesn't support FULLTEXT" error)
sql/mysql_priv.h:
BUG#11869 (cont'd, eliminating "table type doesn't support FULLTEXT" error):
Added TMP_TABLE_FORCE_MYISAM flag
sql/sql_select.cc:
BUG#11869 (cont'd, eliminating "table type doesn't support FULLTEXT" error):
In create_tmp_table(), honor the TMP_TABLE_FORCE_MYISAM flag
Diffstat (limited to 'mysql-test/t/fulltext_order_by.test')
-rw-r--r-- | mysql-test/t/fulltext_order_by.test | 11 |
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 1a70ac3880b..fec74b5dc54 100644 --- a/mysql-test/t/fulltext_order_by.test +++ b/mysql-test/t/fulltext_order_by.test @@ -133,6 +133,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 |