diff options
author | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2023-02-21 10:57:52 +0530 |
---|---|---|
committer | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2023-02-21 10:57:52 +0530 |
commit | 958ab165f7c44921ffadfc1685c25c7d23453f9f (patch) | |
tree | 476a831fc967a6e284dd7ddd53f3ff3c0b422ddb | |
parent | 67a6ad0a4a36bd59fabbdd6b1cdd38de54e82c79 (diff) | |
download | mariadb-git-bb-10.6-MDEV-29871.tar.gz |
MDEV-29871 innodb_fts.fulltext_misc unexpectedly reports a resultbb-10.6-MDEV-29871
- match()+0 returns the floating result and converts into integer value
and it leads to sporadic failure.
-rw-r--r-- | mysql-test/suite/innodb_fts/r/fulltext_misc.result | 3 | ||||
-rw-r--r-- | mysql-test/suite/innodb_fts/t/fulltext_misc.test | 5 |
2 files changed, 3 insertions, 5 deletions
diff --git a/mysql-test/suite/innodb_fts/r/fulltext_misc.result b/mysql-test/suite/innodb_fts/r/fulltext_misc.result index c58cf5ba62c..69812ff8b72 100644 --- a/mysql-test/suite/innodb_fts/r/fulltext_misc.result +++ b/mysql-test/suite/innodb_fts/r/fulltext_misc.result @@ -129,8 +129,9 @@ test select * from t1 where a like "te_t"; a test -select * from t1 where match a against ("te*" in boolean mode)+0; +select * from t1 where match a against ("te*" in boolean mode); a +test drop table t1; # # Bug #49734: Crash on EXPLAIN EXTENDED UNION ... ORDER BY diff --git a/mysql-test/suite/innodb_fts/t/fulltext_misc.test b/mysql-test/suite/innodb_fts/t/fulltext_misc.test index 7a1ddd98d2b..083953a44ce 100644 --- a/mysql-test/suite/innodb_fts/t/fulltext_misc.test +++ b/mysql-test/suite/innodb_fts/t/fulltext_misc.test @@ -152,10 +152,7 @@ insert into t1 values ("a"),("abc"),("abcd"),("hello"),("test"); select * from t1 where a like "abc%"; select * from t1 where a like "test%"; select * from t1 where a like "te_t"; -# InnoDB_FTS: we don't support the postfix "+0" -# Work around MDEV-29871 (FIXME: remove this) ---echo select * from t1 where match a against ("te*" in boolean mode)+0; ---echo a +select * from t1 where match a against ("te*" in boolean mode); drop table t1; |