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

Misleading VARIABLE_COMMENT for SERVER_AUDIT_OUTPUT_TYPE in SYSTEM_VARIABLES

    XMLWordPrintable

    Details

      Description

      Note: Possibly other versions are also affected, I didn't check. Please adjust the "Fix Version/s" field accordingly.

      10.4 f98bb231

      MariaDB [(none)]> select * from information_schema.system_variables where variable_name = 'SERVER_AUDIT_OUTPUT_TYPE' \G
      *************************** 1. row ***************************
              VARIABLE_NAME: SERVER_AUDIT_OUTPUT_TYPE
              SESSION_VALUE: NULL
               GLOBAL_VALUE: file
        GLOBAL_VALUE_ORIGIN: SQL
              DEFAULT_VALUE: file
             VARIABLE_SCOPE: GLOBAL
              VARIABLE_TYPE: ENUM
           VARIABLE_COMMENT: Desired output type. Possible values - 'syslog', 'file' or 'null' as no output.
          NUMERIC_MIN_VALUE: NULL
          NUMERIC_MAX_VALUE: NULL
         NUMERIC_BLOCK_SIZE: NULL
            ENUM_VALUE_LIST: syslog,file
                  READ_ONLY: NO
      COMMAND_LINE_ARGUMENT: REQUIRED
      1 row in set (0.002 sec)
      

      Neither null nor 'null' are accepted.

        Attachments

          Activity

            People

            Assignee:
            holyfoot Alexey Botchkov
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: