Apache Doris 中文技术论坛
Questions Tags Users Badges

修改列的默认值报错 Can not change default value,是不支持嘛?

Asked Sep 24, 2025 Modified Jan 1, 0001
Viewed 62
2.1

修改列 默认值报错:
ALTER TABLE ods.swap_info MODIFY COLUMN dur int DEFAULT '30'

SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Can not change default value

试过DUPLICATE KEY模型、UNIQUE KEY模型,都报错。

edited Jan 1, 0001
东方红17
asked Sep 24, 2025
1 Answers

不支持修改默认值

edited Jan 1, 1970
阿渊@SelectDB (没回帖直接加我主页微信)10130
answered Sep 24, 2025
Related Questions
2.1.11版本,新优化器,执行计划隐式类型转换丢失精度,导致数据不一致
1 answers
doris2.0.7集群迁移到新搭建的doris2.1.11集群
1 answers
多台BE节点异常宕机
1 answers
workload groups 设置是否合理
1 answers
doris 2.x 同步到哪个版本的doris 最稳定
1 answers
flink更新Doris数据
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2026 Apache Doris 中文技术论坛.