You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org> on 2023/06/08 14:14:45 UTC

[GitHub] [doris] SWJTU-ZhangLei opened a new issue, #20614: [Bug] unique key table alter table modify column from varchar(100) to varchar(500) failed

SWJTU-ZhangLei opened a new issue, #20614:
URL: https://github.com/apache/doris/issues/20614

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   2.3.1(AVX2) cloud mode RELEASE (build git://VM-10-7-centos@c7713b4f4b2cfc3f5737c97091ded109f81769e6)
   Built on Wed, 07 Jun 2023 13:02:10 CST by VM-10-7-centos
   
   ### What's Wrong?
   
   1、alter table xxx MODIFY COLUMN  `column1` varchar(500) NULL COMMENT "xxxx"; 
   2、 got exception "Can not change aggregation type"
   
   ### What You Expected?
   
   successfully
   
   ### How to Reproduce?
   
   condition:
   1、unique key model table
   2、alter key column from varchar(100) to varchar(500)
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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

[GitHub] [doris] nextdreamblue commented on issue #20614: [Bug] unique key table alter table modify column from varchar(100) to varchar(500) failed

Posted by "nextdreamblue (via GitHub)" <gi...@apache.org>.
nextdreamblue commented on issue #20614:
URL: https://github.com/apache/doris/issues/20614#issuecomment-1583927274

   alter table xxx MODIFY COLUMN column1 varchar(500) **KEY** NULL COMMENT "xxxx";
   
   do you want to change key column to value column?


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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

[GitHub] [doris] SWJTU-ZhangLei commented on issue #20614: [Bug] unique key table alter table modify column from varchar(100) to varchar(500) failed

Posted by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org>.
SWJTU-ZhangLei commented on issue #20614:
URL: https://github.com/apache/doris/issues/20614#issuecomment-1584047026

   > alter table xxx MODIFY COLUMN column1 varchar(500) **KEY** NULL COMMENT "xxxx"; if you alter key column, you need add **key** in sql
   > 
   > or do you want to change key column to value column? can not change key column to value column
   
   I just want to change varchar length, is there any problem in my stmt?


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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

[GitHub] [doris] nextdreamblue commented on issue #20614: [Bug] unique key table alter table modify column from varchar(100) to varchar(500) failed

Posted by "nextdreamblue (via GitHub)" <gi...@apache.org>.
nextdreamblue commented on issue #20614:
URL: https://github.com/apache/doris/issues/20614#issuecomment-1584087532

   > alter table xxx MODIFY COLUMN `column1` varchar(500) NULL COMMENT "xxxx";
   
   use can alter key column length like 
   
   alter table xxx MODIFY COLUMN column1 varchar(500)  key NULL COMMENT "xxxx";
   
   not 
   
   alter table xxx MODIFY COLUMN column1 varchar(500) NULL COMMENT "xxxx";


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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