query result doesn't same with mysql

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

```sql
create table t (a time);
insert into t values ("09:00:00"), ("23:00:00");
select * from t where not(a between null and '09:33:49.00');
```

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

MySQL 8.0.26 result is:

```sql
test2> select * from t where not(a between null and '09:33:49.00');
+---+
| a |
+---+
0 rows in set
Time: 0.005s
test2> select version();
+-----------+
| version() |
+-----------+
| 8.0.26 |
+-----------+
```

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

TiDB result is:
```sql
> select * from t where not(a between null and '09:33:49.00');
+----------+
| a |
+----------+
| 23:00:00 |
+----------+
```

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

```sql
***************************[ 1. row ]***************************
tidb_version() | Release Version: v6.1.0-alpha-432-gd75b06ec97
Edition: Community
Git Commit Hash: d75b06ec97e54ef9f5a15630e7dfee30d22f047e
Git Branch: master
UTC Build Time: 2022-05-17 07:29:42
GoVersion: go1.18
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false

```