WingsGo opened a new issue #4007:
URL: https://github.com/apache/incubator-doris/issues/4007
**Describe the bug**
Schema Change from int type to varchar failed because miss some logic check
**To Reproduce**
Steps to reproduce the behavior:
1. create a table with int type
```
CREATE TABLE `table2` (
`siteid` int(11) NULL DEFAULT "10" COMMENT "",
`k` smallint(6) NULL COMMENT "",
`v` int NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`siteid`, `k`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`siteid`) BUCKETS 2
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "DEFAULT"
);
```
2. do schema change `alter table table2 modify column v varchar(32);
The reason why schema change failed is because in following judgement, we
forget to add supported convert type in if statement.
https://github.com/apache/incubator-doris/blob/5ade21b55d773b4160dfc0070f14bdc31a44981f/be/src/olap/schema_change.cpp#L340-L373
**Expected behavior**
schema change to varchar type success.
----------------------------------------------------------------
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
