Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
11.8
-
None
-
None
Description
The information_schema.system_variables table is not showing the correct value for the global_value_origin column. Even after updating the configuration through the config file, it still displays COMPILE-TIME.
Default value for collation_server
MariaDB [(none)]> select variable_name, session_value, global_value, global_value_origin, default_value from information_schema.system_variables where variable_name='collation_server '\G |
*************************** 1. row *************************** |
variable_name: COLLATION_SERVER
|
session_value: utf8mb4_uca1400_ai_ci
|
global_value: utf8mb4_uca1400_ai_ci
|
global_value_origin: COMPILE-TIME
|
default_value: utf8mb4_uca1400_ai_ci
|
1 row in set (0.003 sec) |
Updated config file to use utf8mb3 and still it is showing COMPILE-TIME
[mariadb]
|
CHARACTER_SET_SERVER='utf8mb3' |
collation_server='utf8mb3_unicode_ci' |
MariaDB [(none)]> select variable_name, session_value, global_value, global_value_origin, default_value from information_schema.system_variables where variable_name='collation_server '\G |
*************************** 1. row *************************** |
variable_name: COLLATION_SERVER
|
session_value: utf8mb3_unicode_ci
|
global_value: utf8mb3_unicode_ci
|
global_value_origin: COMPILE-TIME
|
default_value: utf8mb3_unicode_ci
|
1 row in set (0.004 sec) |