mysql 5.6.10 fulltext search not working with #

With mysql 5.6.10 , following MATCH condition in WHERE clause gives no result , however there is 1 record in table with col1 having "#xyz". There is also a fulltext index on individual fields ie col1 and col2 as well as on combination of all these fields ie (col1 and col2)

AND MATCH(t1.col1, t1.col2) against('#xyz' IN BOOLEAN MODE) 

innodb_ft_min_token_size is set to 1

But with mysql 5.6.28 / Mariadb 10.1.9, above query works and gives results with identical settings

sql_mode is set in both places to STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION

When I remove # it works however with also 5.6.10. Is there any bug with 5.6.10 wrt full text search and # character ?

I have tried dropping and recreating index without success.

链接地址: http://www.djcxy.com/p/13116.html

上一篇: 如何检查一个字符串是否包含任何文本

下一篇: MySQL 5.6.10全文搜索不兼容＃