Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature]Please support the function of modify after or change the column sequence. #974

Closed
Liuhw-1025 opened this issue Jun 24, 2022 · 3 comments
Assignees
Milestone

Comments

@Liuhw-1025
Copy link

Liuhw-1025 commented Jun 24, 2022

我们在使用中发现,通过navicat直接修改一个默认为null的int类型fdz字段,修改为默认为0。
image
通过查看日志提示为[2022-06-24 13:19:03.501862] WARN [SQL] stmt_query (ob_sql.cpp:171) [21616][1208][YB427F000001-0005E1F1854B6179] [lt=10] [dc=0] fail to handle text query(stmt=ALTER TABLE wcnkafa.gj
MODIFY COLUMN fdz int(1) NULL DEFAULT 0 AFTER codeOrName, ret=-4007)
与老师沟通反馈后,希望完善功能,感谢支持。

@askdb
Copy link
Contributor

askdb commented Jun 24, 2022

在OB4.x 上会支持修改列属性的时候可以调整列的位置顺序,
如果我们没有修改列位置顺序的情况,可以考虑先在sql命令行中完成表结构的ddl变更。

@longdafeng longdafeng changed the title navicat支持调整modify after语法 [Feature]Please support the function of modify after or changing the column sequence. Jun 29, 2022
@longdafeng longdafeng added this to the 4.2 milestone Jun 29, 2022
@longdafeng longdafeng changed the title [Feature]Please support the function of modify after or changing the column sequence. [Feature]Please support the function of modify after or change the column sequence. Jun 29, 2022
@caifeizhi
Copy link
Contributor

partial supported in 4.0 version (Only syntax support, does not actually change the column order)

@hnwyllmm
Copy link
Contributor

DONE

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Status: Done
Development

No branches or pull requests

6 participants