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: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.1
    • Fix Version/s: 10.1.16
    • Component/s: Plugins
    • 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            |
      +--------------------------+---------------+-----------------+

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: