Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8580

For some BOOLEAN or ENUM sysvars list of valid values is not generated

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.1
        • Fix Version/s: 10.1
        • Component/s: OTHER
        • Labels:
          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            |
+--------------------------+---------------+-----------------+

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Task - A task that needs to be done. MDEV-6137 better help for SET/ENUM sysvars

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Closed

                  Activity

                  Hide
                  Permalink
                  serg Sergei Golubchik added a comment -

                  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.

                  Show
                  serg Sergei Golubchik added a comment - 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.

                    People

                    • Assignee:
                      serg Sergei Golubchik
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated: