diff options
| author | unknown <sergefp@mysql.com> | 2005-08-07 21:03:45 +0000 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2005-08-07 21:03:45 +0000 |
| commit | b9e04cf1efa45a717832cd2500502edb4c318858 (patch) | |
| tree | e2b5cb84b734323b2287064d4d2617bac73932d5 /mysql-test/t/fulltext_order_by.test | |
| parent | 1b431c427457a4619d03c0818391638ce01c30c1 (diff) | |
| download | mariadb-git-b9e04cf1efa45a717832cd2500502edb4c318858.tar.gz | |
BUG#11869: part2: post-review fixes:
In init_prepare_fake_select_lex() don't empty ftfunc_list. UNION's ORDER BY clause may
contain MATCH(...), for which fix_index() should be called.
mysql-test/r/fulltext_order_by.result:
BUG#11869 part2 : added another test case
mysql-test/t/fulltext_order_by.test:
BUG#11869 part2 : added another test case
Diffstat (limited to 'mysql-test/t/fulltext_order_by.test')
| -rw-r--r-- | mysql-test/t/fulltext_order_by.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/fulltext_order_by.test b/mysql-test/t/fulltext_order_by.test index fec74b5dc54..da05fd494c4 100644 --- a/mysql-test/t/fulltext_order_by.test +++ b/mysql-test/t/fulltext_order_by.test @@ -138,6 +138,11 @@ order by (select b.id, b.betreff from t3 b) order by match(betreff) against ('+abc' in boolean mode) desc; +--error 1191 +(select b.id, b.betreff from t3 b) union +(select b.id, b.betreff from t3 b) +order by match(betreff) against ('+abc') desc; + select distinct b.id, b.betreff from t3 b order by match(betreff) against ('+abc' in boolean mode) desc; |