-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 10.1
-
Fix Version/s: 10.1.16
-
Component/s: Plugins
-
Labels:None
I don't think it's important, just a small inconsistency. Please feel free to close as 'Won't fix' if you so prefer.
1) All InnoDB, MyISAM and Aria BOOLEAN variables have NULL in ENUM_VALUE_LIST, while most of server ones have OFF,ON there.
2) Apart from storage engine variables, there is also this:
+-----------------------------------+---------------+-----------------+
|
| variable_name | variable_type | enum_value_list |
|
+-----------------------------------+---------------+-----------------+
|
| BINLOG_OPTIMIZE_THREAD_SCHEDULING | BOOLEAN | NULL |
|
+-----------------------------------+---------------+-----------------+
|
Since they are boolean variables, it should not really matter from user's perspective whether OFF,ON are explicitly listed or not.
3) Some ENUM variables also have NULL in the field. All of them are character-set-related, so I suppose it might be on purpose:
+--------------------------+---------------+-----------------+
|
| variable_name | variable_type | enum_value_list |
|
+--------------------------+---------------+-----------------+
|
| CHARACTER_SET_RESULTS | ENUM | NULL |
|
| CHARACTER_SET_CONNECTION | ENUM | NULL |
|
| CHARACTER_SET_CLIENT | ENUM | NULL |
|
| COLLATION_CONNECTION | ENUM | NULL |
|
| CHARACTER_SET_SYSTEM | ENUM | NULL |
|
| CHARACTER_SET_SERVER | ENUM | NULL |
|
| LC_MESSAGES | ENUM | NULL |
|
| CHARACTER_SET_DATABASE | ENUM | NULL |
|
| COLLATION_DATABASE | ENUM | NULL |
|
| LC_TIME_NAMES | ENUM | NULL |
|
| COLLATION_SERVER | ENUM | NULL |
|
| CHARACTER_SET_FILESYSTEM | ENUM | NULL |
|
+--------------------------+---------------+-----------------+
|
- relates to
-
MDEV-6137 better help for SET/ENUM sysvars
-
- Closed
-