Incompatibility issues in Miscellaneous Functions(`INET6_ATON`, `INET6_NTOA`, `IS_IPV4_COMPAT`)

## Bug Report

### 1. Minimal reproduce step
```sql
SELECT INET6_ATON('::00001') IS NULL;
SELECT INET6_NTOA(INET6_ATON('::C0A8:0102'));
SELECT INET6_NTOA(INET6_ATON('::01.2.3.4'));
SELECT IS_IPV4_COMPAT(INET6_ATON('::1'));
```

### 2. What did you expect to see?
```sql
mysql> SELECT INET6_ATON('::00001') IS NULL;
+-------------------------------+
| INET6_ATON('::00001') IS NULL |
+-------------------------------+
| 1 |
+-------------------------------+

mysql> SELECT INET6_NTOA(INET6_ATON('::C0A8:0102'));
+---------------------------------------+
| INET6_NTOA(INET6_ATON('::C0A8:0102')) |
+---------------------------------------+
| ::192.168.1.2 |
+---------------------------------------+

mysql> SELECT INET6_NTOA(INET6_ATON('::01.2.3.4'));
+--------------------------------------+
| INET6_NTOA(INET6_ATON('::01.2.3.4')) |
+--------------------------------------+
| ::1.2.3.4 |
+--------------------------------------+

mysql> SELECT IS_IPV4_COMPAT(INET6_ATON('::1'));
+-----------------------------------+
| IS_IPV4_COMPAT(INET6_ATON('::1')) |
+-----------------------------------+
| 0 |
+-----------------------------------+
```

### 3. What did you see instead
```sql
tidb> SELECT INET6_ATON('::00001') IS NULL;
+-------------------------------+
| INET6_ATON('::00001') IS NULL |
+-------------------------------+
| 0 |
+-------------------------------+

tidb> SELECT INET6_NTOA(INET6_ATON('::C0A8:0102'));
+---------------------------------------+
| INET6_NTOA(INET6_ATON('::C0A8:0102')) |
+---------------------------------------+
| ::c0a8:102 |
+---------------------------------------+

tidb> SELECT INET6_NTOA(INET6_ATON('::01.2.3.4'));
+--------------------------------------+
| INET6_NTOA(INET6_ATON('::01.2.3.4')) |
+--------------------------------------+
| NULL |
+--------------------------------------+

tidb> SELECT IS_IPV4_COMPAT(INET6_ATON('::1'));
+-----------------------------------+
| IS_IPV4_COMPAT(INET6_ATON('::1')) |
+-----------------------------------+
| 1 |
+-----------------------------------+
```

### 4. What is your TiDB version?
```
tidb_version(): Release Version: v5.5.0-alpha-210-g11f4ca802
Edition: Community
Git Commit Hash: 11f4ca802083ee38d5972730ba8f9b72395316fb
Git Branch: master
UTC Build Time: 2022-02-09 22:07:29
GoVersion: go1.17.2
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false
```