TiDB allows RANGE COLUMNS partitions with invalid dates

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

```
set @@sql_mode='ALLOW_INVALID_DATES';
create table t (d datetime) partition by range columns (d) (partition p1 values less than ('2022-02-31'));
set @@sql_mode='';
create table t (d datetime) partition by range columns (d) (partition p1 values less than ('2022-02-31'));
```

### 2. What did you expect to see? (Required)
```
mysql> set @@sql_mode='ALLOW_INVALID_DATES';
Query OK, 0 rows affected (0,00 sec)

mysql> create table t (d datetime) partition by range columns (d) (partition p1 values less than ('2022-02-31'));
ERROR 1654 (HY000): Partition column values of incorrect type
mysql> set @@sql_mode='';
Query OK, 0 rows affected (0,01 sec)

mysql> create table t (d datetime) partition by range columns (d) (partition p1 values less than ('2022-02-31'));
ERROR 1654 (HY000): Partition column values of incorrect type
```

### 3. What did you see instead (Required)
```
tidb> set @@sql_mode='ALLOW_INVALID_DATES';
Query OK, 0 rows affected (0,01 sec)

tidb> create table t (d datetime) partition by range columns (d) (partition p1 values less than ('2022-02-31'));
Query OK, 0 rows affected (0,00 sec)

tidb> drop table t;
Query OK, 0 rows affected (0,02 sec)

tidb> set @@sql_mode='';
Query OK, 0 rows affected (0,00 sec)

tidb> create table t (d datetime) partition by range columns (d) (partition p1 values less than ('2022-02-31'));
ERROR 1654 (HY000): Partition column values of incorrect type
```
### 4. What is your TiDB version? (Required)

```
tidb_version(): Release Version: v6.2.0-alpha-602-g8e9e839190
Edition: Community
Git Commit Hash: 8e9e8391908e4031e8391d721b893f629a2d604f
Git Branch: master
UTC Build Time: 2022-08-03 14:19:54
GoVersion: go1.18
Race Enabled: false
TiKV Min Version: 6.2.0-alpha
Check Table Before Drop: false
Store: unistore
```