Decimal type fields cannot be resized or precision improved within the partition table #54441
Labels
component/ddl
This issue is related to DDL of TiDB.
may-affects-5.4
This bug maybe affects 5.4.x versions.
may-affects-6.1
may-affects-6.5
may-affects-7.1
may-affects-7.5
may-affects-8.1
report/community
The community has encountered this bug.
severity/major
type/bug
The issue is confirmed as a bug.
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
create table test(
id int not null primary key auto_increment,
cost decimal(10,0) default 0 not null
)engine = innodb
partition by hash(id)
PARTITIONS 4 ;
alter table test modify column cost decimal(20,4) default 0 not null;
2. What did you expect to see? (Required)
sql error : Unsupported modify column: table is partition table
3. What did you see instead (Required)
Change fields to decimal(20,4)
4. What is your TiDB version? (Required)
6.5.0 +
The text was updated successfully, but these errors were encountered: