yangzhg opened a new issue #4276:
URL: https://github.com/apache/incubator-doris/issues/4276
**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:
1. 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");`
2. import some data to this table
3. add a boolean column like `alter table table1 add column v1 boolean null
default "false";`
4. exec `select v1 from table1;`
5. see the error: `ERROR 1064 (HY000): errCode = 2, detailMessage = there is
no scanNode Backend`
**Expected behavior**
exec success
**Screenshots**
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
