column stats don't follow the lazy-load behavior after analyzing the table twice

[xuyifangreeneyes]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

use test;
create table t(a int, b int);
insert into t values (1,2), (3,4), (5,6), (7,8);
analyze table t;
show stats_histograms;
analyze table t;
show stats_histograms;

2. What did you expect to see? (Required)

Stats of a and b are all evicted since the optimizer doesn't use stats of a or b(column stats are laze-load).

3. What did you see instead (Required)

After the second analyze, stats of a and b are all loaded, which doesn't follow the stats lazy-load behavior.

mysql> analyze table t;
Query OK, 0 rows affected, 1 warning (0.03 sec)

mysql> show stats_histograms;
+---------+------------+----------------+-------------+----------+---------------------+----------------+------------+--------------+-------------+-------------+-----------------+----------------+----------------+---------------+
| Db_name | Table_name | Partition_name | Column_name | Is_index | Update_time         | Distinct_count | Null_count | Avg_col_size | Correlation | Load_status | Total_mem_usage | Hist_mem_usage | Topn_mem_usage | Cms_mem_usage |
+---------+------------+----------------+-------------+----------+---------------------+----------------+------------+--------------+-------------+-------------+-----------------+----------------+----------------+---------------+
| test    | t          |                | a           |        0 | 2023-03-09 19:50:11 |              4 |          0 |            1 |           1 | allEvicted  |               0 |              0 |              0 |             0 |
| test    | t          |                | b           |        0 | 2023-03-09 19:50:11 |              4 |          0 |            1 |           1 | allEvicted  |               0 |              0 |              0 |             0 |
+---------+------------+----------------+-------------+----------+---------------------+----------------+------------+--------------+-------------+-------------+-----------------+----------------+----------------+---------------+
2 rows in set (0.03 sec)

mysql> analyze table t;
Query OK, 0 rows affected, 1 warning (0.04 sec)

mysql> show stats_histograms;
+---------+------------+----------------+-------------+----------+---------------------+----------------+------------+--------------+-------------+-------------+-----------------+----------------+----------------+---------------+
| Db_name | Table_name | Partition_name | Column_name | Is_index | Update_time         | Distinct_count | Null_count | Avg_col_size | Correlation | Load_status | Total_mem_usage | Hist_mem_usage | Topn_mem_usage | Cms_mem_usage |
+---------+------------+----------------+-------------+----------+---------------------+----------------+------------+--------------+-------------+-------------+-----------------+----------------+----------------+---------------+
| test    | t          |                | a           |        0 | 2023-03-09 19:50:22 |              4 |          0 |            1 |           1 | allLoaded   |             196 |              0 |            196 |             0 |
| test    | t          |                | b           |        0 | 2023-03-09 19:50:22 |              4 |          0 |            1 |           1 | allLoaded   |             196 |              0 |            196 |             0 |
+---------+------------+----------------+-------------+----------+---------------------+----------------+------------+--------------+-------------+-------------+-----------------+----------------+----------------+---------------+
2 rows in set (0.00 sec)

4. What is your TiDB version? (Required)

master