Describe the bug
Add a boolean column to a unique table that already has some data, then select this column be will coredump
To Reproduce
Steps to reproduce the behavior:
- create a unique table like
CREATE TABLE table1 ( siteid INT DEFAULT '10', citycode SMALLINT, username VARCHAR(32) DEFAULT '', pv BIGINT SUM DEFAULT '0' ) AGGREGATE KEY(siteid, citycode, username) DISTRIBUTED BY HASH(siteid) BUCKETS 10 PROPERTIES("replication_num" = "1");
- import some data to this table
- add a boolean column like
alter table table1 add column v1 boolean null default "false";
- exec
select v1 from table1;
- see the error:
ERROR 1064 (HY000): errCode = 2, detailMessage = there is no scanNode Backend
Expected behavior
exec success
Screenshots
暂无答案!
目前还没有任何答案,快来回答吧!