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

oceanbase数据库不支持扩展字段长度 #687

Open
chaigang0 opened this issue Nov 4, 2024 · 10 comments
Open

oceanbase数据库不支持扩展字段长度 #687

chaigang0 opened this issue Nov 4, 2024 · 10 comments

Comments

@chaigang0
Copy link

描述您想要的功能:

oceanbase修改 varchar 字段长度报错【Cannot change column type 'test.name' varchar(20) -> varchar(200).】

在官方文档中,不能减字段长度,但加大字段长度是支持的
https://www.oceanbase.com/knowledge-base/oceanbase-database-20000001017

希望可以支持 【 varchar 字段长度】修改功能

@zmix999
Copy link
Contributor

zmix999 commented Nov 5, 2024

enable_change_column,打开这个参数

@chaigang0
Copy link
Author

enable_change_column,打开这个参数

已经是打开状态,感觉对OB不起作用
| enable_change_column | true

@zmix999
Copy link
Contributor

zmix999 commented Nov 6, 2024

我使用中没遇到这种问题

@chaigang0
Copy link
Author

我使用中没遇到这种问题

问下,你那边用的也是OB数据库是吗,哪个版本呀

@zmix999
Copy link
Contributor

zmix999 commented Nov 6, 2024

这个版本没关系吧,OB4.2.1

@zmix999
Copy link
Contributor

zmix999 commented Nov 6, 2024

check_column_type_change 看下这个参数,

@zmix999
Copy link
Contributor

zmix999 commented Nov 6, 2024

image

@chaigang0
Copy link
Author

check_column_type_change

也是true

好奇怪,你那边是用的goInception v1.3.0-94 版本吗

mysql> \s

mysql Ver 8.0.33 for macos13 on arm64 (MySQL Community Server - GPL)

Connection id: 2
Current database:
Current user: root@127.0.0.1
SSL: Not in use
Current pager: less
Using outfile: ''
Using delimiter: ;
Server version: 5.7.10-TiDB-v1.3.0-94-g2f06c61b95 MySQL Community Server (Apache License 2.0)
Protocol version: 10
Connection: 127.0.0.1 via TCP/IP
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8mb4
Conn. characterset: utf8mb4
TCP port: 4000
Binary data as: Hexadecimal

mysql>

@chaigang0
Copy link
Author

check_column_type_change

明白了,这个改成 false后,ob加长字段工单就能审过去了,谢谢

@zmix999
Copy link
Contributor

zmix999 commented Nov 6, 2024

我是自己有fork一个分支,有时单独加自己需要的功能

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants