Runtime error occurs when analyzing table

[apollodafoni]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE `IDT_25727` (
  `COL102` float DEFAULT NULL,
  `COL103` float DEFAULT NULL,
  `COL1` float GENERATED ALWAYS AS (`COL102` % 10) STORED,
  `COL2` varchar(20) DEFAULT NULL,
  `COL4` datetime DEFAULT NULL,
  `COL3` bigint DEFAULT NULL,
  `COL5` float DEFAULT NULL,
  KEY `UK_COL1` (`COL1`) /*!80000 INVISIBLE */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin

insert some values as follows:
test_data.csv

analyze table IDT_25727;

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

analyse success

3. What did you see instead (Required)

ERROR 1105 (HY000): runtime error: slice bounds out of range [11:10]

[2024/11/18 03:16:55.452 +00:00] [ERROR] [analyze_col_v2.go:679] ["analyze worker panicked"] [recover="runtime error: slice bounds out of range [11:10]"] [stack="github.com/pingcap/tidb/pkg/executor.(*AnalyzeColumnsExecV2).subBuildWorker.func1\n\t/workspace/source/tidb/pkg/executor/analyze_col_v2.go:679\nruntime.gopanic\n\t/usr/local/go/src/runtime/panic.go:785\nruntime.goPanicSliceBU\n\t/usr/local/go/src/runtime/panic.go:161\ngithub.com/pingcap/tidb/pkg/statistics.BuildHistAndTopN\n\t/workspace/source/tidb/pkg/statistics/builder.go:461\ngithub.com/pingcap/tidb/pkg/executor.(*AnalyzeColumnsExecV2).subBuildWorker\n\t/workspace/source/tidb/pkg/executor/analyze_col_v2.go:818\ngithub.com/pingcap/tidb/pkg/executor.(*AnalyzeColumnsExecV2).buildSamplingStats.func6\n\t/workspace/source/tidb/pkg/executor/analyze_col_v2.go:363\ngithub.com/pingcap/tidb/pkg/executor.(*notifyErrorWaitGroupWrapper).Run.func1\n\t/workspace/source/tidb/pkg/executor/analyze_utils.go:172"]
[2024/11/18 03:16:55.452 +00:00] [ERROR] [analyze.go:455] ["receive error when saving analyze results"] [error="runtime error: slice bounds out of range [11:10]"]

4. What is your TiDB version? (Required)

Release Version: v8.5.0-alpha-134-g4a6bf46a5f
Edition: Community
Git Commit Hash: 4a6bf46
Git Branch: HEAD
UTC Build Time: 2024-11-16 07:53:03
GoVersion: go1.23.3
Race Enabled: false
Check Table Before Drop: false
Store: tikv

[apollodafoni]

/severity critical

[apollodafoni]

/assign @hawkingrei

[hawkingrei]

It is the same as #35948.