| 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: | |
| Category: | MySQL Server: Options | Severity: | S2 (Serious) |
| Version: | 8.0.27, 8.0.28, 8.0.33 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[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
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 '中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中中??'