Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Field table_columns.type varchar(32) is too short #18203

Closed
igor-lukyanov opened this issue Jan 27, 2022 · 1 comment
Closed

Field table_columns.type varchar(32) is too short #18203

igor-lukyanov opened this issue Jan 27, 2022 · 1 comment
Labels
#bug Bug report

Comments

@igor-lukyanov
Copy link

Superset version 1.4.0

Particularly in Clickhouse column types may be quite long:
'type': "ENUM8('V1' = 0, 'V2' = 1, 'V3' = 2, 'V4' = 3, 'V5' = 4, 'V6' = 5, 'V7' = 6, 'V8' = 7)"

which leads to (psycopg2.errors.StringDataRightTruncation) value too long for type character varying(32) error while creating a new dataset from a table with long enough enums. The solution is to ALTER TABLE superset.table_columns ALTER COLUMN type TYPE varchar.

Sorry for not submitting a patch, not quite familiar with superset internals.

@igor-lukyanov igor-lukyanov added the #bug Bug report label Jan 27, 2022
@villebro
Copy link
Member

I'm closing this as it's already been fixed on master branch here: #17360 . However, pinging @eschutho (release manager for 1.4 branch): do you consider this a viable cherry for a 1.4.x patch release, or should we wait until 1.5?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
#bug Bug report
Projects
None yet
Development

No branches or pull requests

2 participants