254288935 commented on issue #8073:
URL:
https://github.com/apache/incubator-doris/issues/8073#issuecomment-1042525539
> > alter table时，目前不支持BIGINT到CHAR的转换， 是否需要支持BIGINT到VARCHAR的转换呢？
>
> I think we do support convert BIGINT to CHAR. Why you say it not support?
mysql> create table t(a int, b bigint) duplicate key(a) distributed by
hash(a) buckets 5 PROPERTIES ("replication_num" = "1");
Query OK, 0 rows affected (0.01 sec)
mysql> insert into t values(1,111111111);
Query OK, 1 row affected (0.04 sec)
{'label':'insert_37ddf33352aa45e2-be78d5486b802511', 'status':'VISIBLE',
'txnId':'23'}
mysql> select * from t;
+------+-----------+
| a | b |
+------+-----------+
| 1 | 111111111 |
+------+-----------+
1 row in set (0.01 sec)
mysql> alter table t modify column b char(10);
ERROR 1105 (HY000): errCode = 2, detailMessage = Can not change BIGINT to
CHAR
----
master分支上，我是这样操作的
--
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.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
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
