[GitHub] [incubator-doris] yangzhg opened a new issue #4276: [BUG] be will be core dump when add a boolen colum to unique table

[GitBox]

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**
   
![image](https://user-images.githubusercontent.com/9098473/89600326-591c2e80-d894-11ea-937d-465ed07b962e.png)
   
   


----------------------------------------------------------------
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:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org