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

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

Asked Sep 24, 2025 Modified Jan 1, 0001
Viewed 91
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 (没回帖直接加我主页微信)10495
answered Sep 24, 2025
Related Questions
SelectDB Doris 2.1.8-3 升级使用灵活部分列更新,推荐版本及升级流程咨询
1 answers
Flink Connector 26.3.0 读取 DATETIME 变成 1970 年,切换 25.0.0 后正常
1 answers
Apache Doris Dashboard未授权访问漏洞
1 answers
Apache Doris默认口令登录漏洞
max_by会不会忽略null值
1 answers
Doris2.1.6升级为Doris2.1.11后全部be节点进程频繁停止运行
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 中文技术论坛.