Error updating table colums from changed source

[glrvrl]

Error updating table colums from source

(psycopg2.DataError) value too long for type character varying(32) [SQL: UPDATE table_columns SET changed_on=%(changed_on)s, is_active=%(is_active)s, type=%(type)s, is_dttm=%(is_dttm)s, changed_by_fk=%(changed_by_fk)s WHERE table_columns.id = %(table_columns_id)s] [parameters: ({'changed_on': datetime.datetime(2020, 3, 11, 6, 22, 30, 509794), 'is_active': None, 'type': 'TINYINT(1)', 'is_dttm': None, 'changed_by_fk': 6, 'table_columns_id': 1381}, {'changed_on': datetime.datetime(2020, 3, 11, 6, 22, 30, 509830), 'is_active': None, 'type': 'VARCHAR(4) CHARACTER SET utf8mb4', 'is_dttm': None, 'changed_by_fk': 6, 'table_columns_id': 1382}, {'changed_on': datetime.datetime(2020, 3, 11, 6, 22, 30, 509847), 'is_active': None, 'type': 'VARCHAR(12) CHARACTER SET utf8mb4', 'is_dttm': None, 'changed_by_fk': 6, 'table_columns_id': 1383})] (Background on this error at: http://sqlalche.me/e/9h9h)

Expected results

update colums

Actual results

error

Screenshots

How to reproduce the bug

1. Edit Datasource
   

2. Click 'Sync from source'
   

3. Click 'Save '
   

4. See error
   

Environment

• superset version: Superset 0.999.0dev
• python version: Python 3.6.9
• node.js version: v10.19.0
• npm version: 6.13.4

Checklist

[villebro]

What database is this? the character encoding implies MySQL, but you seem to be using Psycopg2 which implies Postgres.

[glrvrl]

What database is this? the character encoding implies MySQL, but you seem to be using Psycopg2 which implies Postgres.

superset -> postgresql
data source -> mysql

[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.