Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.1(EOL)
-
None
Description
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 |
|
+--------------------------+---------------+-----------------+
|
Attachments
Issue Links
- relates to
-
MDEV-6137 better help for SET/ENUM sysvars
-
- Closed
-
Charset related variables are on purpose. They are kind of an enum, because they take a string literal value from a fixed set of valid values. Or a value number. But they aren't an enum internally and the set of valid values is pretty large. So they're shown as "ENUM" but without a value list.