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]: 【MySQL兼容】【8.0】【obmysql_table】创建分区表,更改分区表分区段列名,ob正常修改,mysql8.0报错不支持更改 #1950

Open
lyukun opened this issue May 7, 2024 · 0 comments

Comments

@lyukun
Copy link

lyukun commented May 7, 2024

【OB版本】
observer (OceanBase 4.0.0.0)
REVISION: 1-1eb57bdee7e35d439dc12c24971dd43f11dd2246
BUILD_BRANCH: HEAD
BUILD_TIME: Aug 17 2022 19:56:25
BUILD_FLAGS: RelWithDebInfo
BUILD_INFO: jenkins-oceanbase_build_master_7u-B13240
【前置条件】
【复现步骤】
CREATE TABLE t1(a bigint, b date)partition by range columns(b)
(
partition part_1 values less than ('2016-09-01'),
partition part_2 values less than ('2020-09-01')
);
INSERT INTO t1 VALUES(1,'2010-11-21');
INSERT INTO t1 VALUES(2,'2011-12-23');
INSERT INTO t1 VALUES(3,'2018-12-23');
ALTER TABLE t1 CHANGE COLUMN b bb VARCHAR(50) AFTER a;
【实际结果】
ob4.0
image

mysql8.0 正常查询
image

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

No branches or pull requests

2 participants