You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
1064 - You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'auto_increment_cache_size = 10000 DEFAULT CHARSET=utf8mb4 COMMENT='测试自增I' at line 4
Environment
OS Version: CentOS 7.9/8.2 64bit x86_64
OB Version: OceanBase 4.2.1-HP5 社区版、OceanBase 4.2.2-HF1 社区版(都不行)。
Additional context
-- ALTER TABLE 也报错CREATETABLE `t_test` auto_increment_cache_size =10000;
-- 租户级别的全局变量设置倒是可以正常执行SET GLOBAL auto_increment_cache_size =10000;
The text was updated successfully, but these errors were encountered:
CodePlayer
changed the title
[Bug]: CREATE TABLE / ALTER TABLE 中 auto_increment_cache_size 语法报错
CREATE TABLE / ALTER TABLE 中 auto_increment_cache_size 语法报错
May 14, 2024
Describe the bug
参考 定义自增列 + CREATE TABLE 语法 + ALTER TABLE 语法 等官方文档,定义如下表结构:
得到如下报错:
Environment
OS Version: CentOS 7.9/8.2 64bit x86_64
OB Version: OceanBase 4.2.1-HP5 社区版、OceanBase 4.2.2-HF1 社区版(都不行)。
Additional context
The text was updated successfully, but these errors were encountered: