[MDEV-26737] Outdated VARIABLE_COMMENT for HISTOGRAM_TYPE in I_S.SYSTEM_VARIABLES and help Created: 2021-09-30  Updated: 2022-01-19  Resolved: 2021-10-04

Status: Closed
Project: MariaDB Server
Component/s: Information Schema, Optimizer
Affects Version/s: N/A
Fix Version/s: 10.7.1

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-21130 Histograms: use JSON as on-disk format Closed

 Description   

*************************** 1. row ***************************
        VARIABLE_NAME: HISTOGRAM_TYPE
        SESSION_VALUE: DOUBLE_PREC_HB
         GLOBAL_VALUE: DOUBLE_PREC_HB
  GLOBAL_VALUE_ORIGIN: COMPILE-TIME
        DEFAULT_VALUE: DOUBLE_PREC_HB
       VARIABLE_SCOPE: SESSION
        VARIABLE_TYPE: ENUM
     VARIABLE_COMMENT: Specifies type of the histograms created by ANALYZE. Possible values are: SINGLE_PREC_HB - single precision height-balanced, DOUBLE_PREC_HB - double precision height-balanced.
    NUMERIC_MIN_VALUE: NULL
    NUMERIC_MAX_VALUE: NULL
   NUMERIC_BLOCK_SIZE: NULL
      ENUM_VALUE_LIST: SINGLE_PREC_HB,DOUBLE_PREC_HB,JSON_HB
            READ_ONLY: NO
COMMAND_LINE_ARGUMENT: REQUIRED
    GLOBAL_VALUE_PATH: NULL
1 row in set (0.003 sec)

$ sql/mysqld --help --verbose
<...>
  --histogram-type=name 
                      Specifies type of the histograms created by ANALYZE.
                      Possible values are: SINGLE_PREC_HB - single precision
                      height-balanced, DOUBLE_PREC_HB - double precision
                      height-balanced.

The new JSON_HB value is missing from VARIABLE_COMMENT and help text.



 Comments   
Comment by Elena Stepanova [ 2021-09-30 ]

Raised priority on procedural reasons

Generated at Thu Feb 08 09:47:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.