Query executed successfully in MySQL but not in TiDB

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)
```sql
INSERT INTO mysql.opt_rule_blacklist VALUES("partition_processor");
admin reload opt_rule_blacklist;
create table t0(c0 blob(425) , c1 bool , c2 double zerofill ) partition by range(c1)(partition p0 values less than(5269),partition p1 values less than(10617),partition p2 values less than(15942),partition p3 values less than(21229),partition p4 values less than(26551),partition p5 values less than(31891),partition p6 values less than(37163),partition p7 values less than(42517),partition p8 values less than(47794),partition p9 values less than(53155),partition p10 values less than(58469),partition p11 values less than maxvalue);
REPLACE INTO t0 VALUES ('0.2830944185570108', 5269, 0.2830944185570108), ('額o', 5270, 0.5837936579583201), ('', 10617, 0.1998795712565956), ('額ﾥ', 10618, 0.1813607167398651), ('', 15942, NULL), ('m~/)', 15943, -8.38008923E8), ('額ﾥ', 21229, 0.5073373067569501), ('', 21230, 0.13145569440703986), (NULL, 26551, -8.38008923E8), ('W', 26552, 0.3999827025765833), ('Y', 31891, 0.8042266097603227), ('e額\nE鬪', 31892, 7.62681421E8), ('㐼1i&o-V', 37163, NULL), ('7

### 2. What did you expect to see? (Required)
Query executed successfully

### 3. What did you see instead (Required)
```sql
mysql> select hex(rpad(c0, 5, x'e4ba8c')),hex(rpad(c2, 5, x'b6fe')) from t0;
ERROR 1105 (HY000): [components/tidb_query_executors/src/table_scan_executor.rs:425]: Data is corrupted, missing data for NOT NULL column (offset = 1)
```

### 4. What is your TiDB version? (Required)
8.0.11-TiDB-v9.0.0-beta.1.pre-640-g24903d6b24