column type LONG BYTE is not compatible with MySQL

[wd0517]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE t1 (col2 LONG BYTE) ENGINE=INNODB CHARACTER SET UTF8MB4;

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

mysql 5.7

+-------+------------+------+-----+---------+-------+
| Field | Type       | Null | Key | Default | Extra |
+-------+------------+------+-----+---------+-------+
| col2  | mediumblob | YES  |     | NULL    |       |
+-------+------------+------+-----+---------+-------+

3. What did you see instead (Required)

+-------+------------+------+------+---------+-------+
| Field | Type       | Null | Key  | Default | Extra |
+-------+------------+------+------+---------+-------+
| col2  | mediumtext | YES  |      | NULL    |       |
+-------+------------+------+------+---------+-------+

4. What is your TiDB version? (Required)

Release Version: v6.1.0
Edition: Community
Git Commit Hash: 1a89dec
Git Branch: heads/refs/tags/v6.1.0
UTC Build Time: 2022-06-05 05:09:33
GoVersion: go1.18.2
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false