[Improvement] add auto_increment field in AddColumn

[yuqi1129]

What would you like to be improved?

As we have supported column auto_increment property, we need to add field auto_increment in the AddColumn class.

How should we improve?

No response

[SteNicholas]

@yuqi1129, could this ticket also introduce UpdateColumnAutoIncrement to support auto_increment?
BTW, AddColumn should not only add auto_increment, but also support add index, otherwise the AddColumn could not add auto_increment.

[yuqi1129]

@yuqi1129, could this ticket also introduce UpdateColumnAutoIncrement to support auto_increment? BTW, AddColumn should not only add auto_increment, but also support add index, otherwise the AddColumn could not add auto_increment.

I'm sorry for not getting back to you earlier, Nicholas. The scenarios you mentioned should also be taken into consideration.

@Clearvive, as you are knowledgeable and responsible for this point, can you follow up on this issue and its aftermath?

[SteNicholas]

@Clearvive, any input for above comment?

[Clearvive]

@SteNicholas The logic regarding this area is already under development, and PR will be proposed in the future. You can review it together

[jerryshao]

Fixed.