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

Enum fileds are not supported by create table #154

Open
lelvisl opened this issue Jun 21, 2019 · 1 comment
Open

Enum fileds are not supported by create table #154

lelvisl opened this issue Jun 21, 2019 · 1 comment

Comments

@lelvisl
Copy link

lelvisl commented Jun 21, 2019

2019-06-21 14:57:36,391/1561129056.391024:DEBUG:Query: CREATE TABLE IF NOT EXISTS DEV.candidates (
id String,
created_at DateTime,
updated_at Nullable(DateTime),
last_name String,
first_name String,
other_name Nullable(String),
gender Enum16,
nationality Enum16,
date_born Date,
address String,
phone String,
other_phone String,
email Nullable(String),
education_id String,
user_id String,
search_full_name String,
by_robot Nullable(Int8)
)

2019-06-21 14:57:36,391/1561129056.391306:DEBUG:Block send time: 0.000087
2019-06-21 14:57:36,392/1561129056.392637:CRITICAL:Code: 92.
DB::Exception: Enum data type cannot be empty. Stack trace:

script don't get enum values from mysql

@goodFancier
Copy link

goodFancier commented Jan 31, 2020

As a solution you can change nationality Enum16 to nationality Enum16('Russian' = 1, 'English' = 2, 'American' = 3) - for example

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

No branches or pull requests

3 participants