TRUNCATE precision differs in TiDB / MySQL 9 compared to MySQL 8

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

SELECT
TRUNCATE(1 * 0.025/365 * 146, 4) AS trunc_result1,
1 * 0.025/365 * 146 AS normal_result1,
1 * 0.025 * 146/365 AS normal_result2;

### 2. What did you expect to see? (Required)
SELECT
TRUNCATE(1 * 0.025/365 * 146, 4)

The result should be 0.0100

### 3. What did you see instead (Required)

0.0099

### 4. What is your TiDB version? (Required)

v8.5.3