Bug #107115 ??at the end of the error mecessage after setting Chinese characters to variable
Submitted: 25 Apr 2022 3:47 Modified: 25 Apr 2022 6:01
Reporter: cenjiong Zhao Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S2 (Serious)
Version:8.0.27, 8.0.28 OS:Any
Assigned to: CPU Architecture:Any

[25 Apr 2022 3:47] cenjiong Zhao
Description:
??at the end of the error mecessage after setting Chinese characters to string variables

mysql> select version();
+--------------+
| version()    |
+--------------+
| 8.0.27-debug |
+--------------+
1 row in set (0.00 sec)

mysql> set global ft_boolean_syntax = repeat('中', 99);
ERROR 1231 (42000): Variable 'ft_boolean_syntax' can't be set to the value of '中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中??'

How to repeat:
mysql> select version();
+--------------+
| version()    |
+--------------+
| 8.0.27-debug |
+--------------+
1 row in set (0.00 sec)

mysql> set global ft_boolean_syntax = repeat('中', 99);
ERROR 1231 (42000): Variable 'ft_boolean_syntax' can't be set to the value of '中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中??'
[25 Apr 2022 3:48] cenjiong Zhao
mysql> select version();
+--------------+
| version()    |
+--------------+
| 8.0.27-debug |
+--------------+
1 row in set (0.00 sec)

mysql> set global ft_boolean_syntax = repeat('中', 99);
ERROR 1231 (42000): Variable 'ft_boolean_syntax' can't be set to the value of '中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中??'
mysql> show variables like '%char%';
+--------------------------+---------------------------------------------------------+
| Variable_name            | Value                                                   |
+--------------------------+---------------------------------------------------------+
| character_set_client     | utf8mb4                                                 |
| character_set_connection | utf8mb4                                                 |
| character_set_database   | utf8mb4                                                 |
| character_set_filesystem | binary                                                  |
| character_set_results    | utf8mb4                                                 |
| character_set_server     | utf8mb4                                                 |
| character_set_system     | utf8mb3                                                 |
| character_sets_dir       | /home/zcj/test/hwsql8/build_com/install/share/charsets/ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.01 sec)
[25 Apr 2022 6:01] MySQL Verification Team
Hello cenjiong Zhao,

Thank you for the report and feedback.

regards,
Umesh