the "type" field in the "table_columns" table was too short

[bm8836900]

There is an enum in my table. When creating a data set, the creation failed because the "type" field in the "table_columns" table was too short

DataBase：mysql 5.7.33

Superset Error Message：(MySQLdb._exceptions.DataError) (1406, "Data too long for column 'type' at row 1")
[SQL: INSERT INTO table_columns (uuid, created_on, changed_on, column_name, verbose_name, is_active, type, groupby, filterable, description, table_id, is_dttm, expression, python_date_format, created_by_fk, changed_by_fk) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)]
[parameters: (b'#\xe8J\xd1\xa9\xeaOg\xaaI\x12\x1c\x7fR\xfd\x82', datetime.datetime(2021, 3, 18, 17, 30, 17, 894672), datetime.datetime(2021, 3, 18, 17, 30, 17, 894672), 'Continent', None, 1, "ENUM('ASIA','EUROPE','NORTH AMERICA','AFRICA','OCEANIA','ANTARCTICA','SOUTH AMERICA')", 1, 1, None, 6, 0, None, None, 1, 1)]

Superset Source Code:

[bm8836900]

superset version：1.0.1
mysql databse：test
mysql table name：country
在mysql自带测试库test中的country表中，有一个字段“Continent”是用enum类型创建的。在superset创建数据集时，superset会将源表的表结构保存在“table”表中。其中“type”字段是将源表字段数据类型以字符串的形式保存的。所以在遇到较长字符串时，因为“type”字段长度的限制，导致无法保存源表数据结构，导致superset创建数据集失败。例如：
field name：Continent
field data type：ENUM('ASIA','EUROPE','NORTH AMERICA','AFRICA','OCEANIA','ANTARCTICA','SOUTH AMERICA')

[ganczarek]

#13572 is the same issue.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[rusackas]

Closed by #17360