-
Notifications
You must be signed in to change notification settings - Fork 8.2k
Closed
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official release
Description
Clickhouse version 1.1.54164.
Steps to reproduce
- Create a
MergeTreetable with Enum field in primary key:
CREATE TABLE t (d Date, e Enum8('foo'=1)) Engine = MergeTree(d, (d, e), 8192);- Insert at least one row into the table:
insert into t (d, e) values ('2017-02-20', 'foo');- Add new value to enum field:
alter table t modify column e Enum8('foo'=1, 'bar'=2);- Try to select on new enum value:
select count(*) from t where e = 'bar';Actual result:
Clickhouse returns the following error:
Primary key expression contains comparison between inconvertible types: Enum8('foo' = 1) and String inside e = 'bar'.
Expected result:
Clickhouse must return
0 rows in set.
Temporary workaround:
Use 'IN' instead of '=' in the filter on updated enum column:
select count(*) from t where e in('bar');This issue is related to #364 .
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official release