Bug #95705 character "．" regexp probrem

• Submitted: 10 Jun 2019 10:04
• Modified: 10 Jun 2019 13:27
• Reporter: silence Year
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.7
• OS: Any
• CPU Architecture: Any

[10 Jun 2019 10:04] silence Year

Description:
select 'A：' regexp binary 'A[、．\\.]';//1
select 'A。' regexp binary 'A[、．\\.]';//1
select 'A，' regexp binary 'A[、．\\.]';//1
select 'A（' regexp binary 'A[、．\\.]';//1
select 'AＡ' regexp binary 'A[、．\\.]';//1

select 'A:' regexp binary 'A[、．\\.]';//0
select 'A,' regexp binary 'A[、．\\.]';//0
select 'A(' regexp binary 'A[、．\\.]';//0

"．" match two space character?but when i change to 'A[、\\．\\.]' they still match,and i can't find any regexp usage for "．".

How to repeat:
as description

[10 Jun 2019 13:27] MySQL Verification Team

Hi Mr. Year,

Thank you for your bug report.

However, it is not a bug .....

Many of the characters have special meanings in both InnoDB and MyISAM full text searches. This is fully explained in our Reference Manual.

Also, please do note this sentence from our manual:

"
By default, words less than 3 characters in length or greater than 84 characters in length do not appear in an InnoDB full-text search index. 
"
 
Not a bug.