./mysql-test-run --start-and-exit

mysql -uroot -A --socket=/data0/psergey/dev2/maria-10.0-mwl253/mysql-test/var/tmp/mysqld.1.sock

MariaDB [(none)]> use test;

Database changed

MariaDB [test]> create table t1 (a int);

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> insert into t1 values (1),(2),(3);

Query OK, 3 rows affected (0.01 sec)

Records: 3  Duplicates: 0  Warnings: 0

MariaDB [test]>  set histogram_size=100;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> analyze table t1  persistent for all;

+---------+---------+----------+----------+

| Table   | Op      | Msg_type | Msg_text |

+---------+---------+----------+----------+

| test.t1 | analyze | status   | OK       |

+---------+---------+----------+----------+

1 row in set (0.00 sec)

MariaDB [test]> select * from mysql.column_stats\G

*************************** 1. row ***************************

      db_name: test

   table_name: t1

  column_name: a

    min_value: 1

    max_value: 3

  nulls_ratio: 0.0000

   avg_length: 4.0000

avg_frequency: 1.0000

    hist_size: 100

    hist_type: 

    histogram:                                  ���������������������������������

1 row in set (0.00 sec)

MariaDB [test]> select length(hist_type) from mysql.column_stats;

+-------------------+

| length(hist_type) |

+-------------------+

|                 0 |

+-------------------+

1 row in set (0.00 sec)

MariaDB [test]>  select @@histogram_type;

+------------------+

| @@histogram_type |

+------------------+

| SINGLE_PREC_HB   |

+------------------+

1 row in set (0.00 sec)