[MDEV-8580] For some BOOLEAN or ENUM sysvars list of valid values is not generated Created: 2015-08-07  Updated: 2016-07-18  Resolved: 2016-07-13

Status: Closed
Project: MariaDB Server
Component/s: Plugins
Affects Version/s: 10.1
Fix Version/s: 10.1.16

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-6137 better help for SET/ENUM sysvars Closed

 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            |
 
+--------------------------+---------------+-----------------+



 Comments   
Comment by Sergei Golubchik [ 2015-09-04 ]

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.

Generated at Thu Feb 08 07:28:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.