Support changing the AUTO_INCREMENT attribute to the AUTO_RANDOM attribute. However, if the maximum value of the column data with AUTO_INCREMENT is close to the maximum value of the BIGINT type, the modification may fail

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 支持将 AUTO_INCREMENT 属性改为 AUTO_RANDOM 属性。但在 AUTO_INCREMENT 的列数据最大值已接近 BIGINT 类型最大值的情况下,修改可能会失败。

| username: tidb狂热爱好者

【TiDB Environment】
【TiDB Version】
【Encountered Issue】
【Reproduction Path】
【Problem Phenomenon and Impact】
How should this sentence be understood? Does it mean that autoincrement can fix hotspots? How is it fixed?
【Attachment】

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

| username: tidb狂热爱好者 | Original post link

Can you help me revise the sentence?

| username: tidb狂热爱好者 | Original post link

Is it correct to write alter table t modify a bigint auto_random (5) like this?

| username: system | Original post link

This topic was automatically closed 1 minute after the last reply. No new replies are allowed.