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

MPP query failed if the return column has Enum type #1489

Closed
windtalker opened this issue Feb 26, 2021 · 0 comments · Fixed by #1534
Closed

MPP query failed if the return column has Enum type #1489

windtalker opened this issue Feb 26, 2021 · 0 comments · Fixed by #1534
Labels
severity/critical type/bug The issue is confirmed as a bug.

Comments

@windtalker
Copy link
Contributor

mysql> desc test_enum;
+-------+-------------------+------+------+---------+-------+
| Field | Type              | Null | Key  | Default | Extra |
+-------+-------------------+------+------+---------+-------+
| id    | int(11)           | YES  |      | NULL    |       |
| value | enum('a','b','c') | YES  |      | NULL    |       |
+-------+-------------------+------+------+---------+-------+
2 rows in set (0.00 sec)

mysql> select * from test_enum;
+------+-------+
| id   | value |
+------+-------+
|    1 | a     |
|    2 | b     |
+------+-------+
2 rows in set (0.01 sec)

mysql>  select * from test_enum a join test_enum b on a.id = b.id;
ERROR 1105 (HY000): DB::Exception: DataTypeEnum enumeration cannot be empty
@windtalker windtalker added the type/bug The issue is confirmed as a bug. label Feb 26, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/critical type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants