Table options & Auto increment

[OlafvdSpek]

1. Open Table Operations - Table options in two tabs
2. Update the Auto increment value in the first tab to simulate some inserts.
3. Update the Table comment in the second tab
4. Note the Auto increment value has been reset to the original value.

I'm not sure about the consequences but I don't think the reset is desirable.

[Tithugues]

Sorry, but I don't see the issue here.

You have two forms, each one specifies an AUTO_INCREMENT value. Don't you expect it to be used when you submit the form?

[OlafvdSpek]

I don't expect / want auto-increment to be updated when I only want to update the table comment or another option.

One solution would be to only set auto-increment if the user actually changed it (store the old value in a hidden field).

Note that auto-increment could easily be updated by some other concurrent process that's using the DB.

[williamdes]

@OlafvdSpek do you mean for example you open the page, someone increments the value and you save the comment. The good value would be lost.
Let me know if I am right.
In that case it is a bug.

[OlafvdSpek]

You're right ;)

[yashrajbothra]

Can anyone elaborate this issue?

What i understood is for example:
I have 2 tabs for editing same row which has 251 as its primary index.
In first tab we increment primary index
then in second one we change another column

So the change in 2nd tab will be lost?
Am i right?

[williamdes]

then in second one we change another column

Changing the table description for example

So the change in 2nd tab will be lost?

The incrementation from first tab will be lost and replace by the value of the 2nd tab (bug !)

[yashrajbothra]

Hey @williamdes I think the better solution would be to give a warning if the auto_increment value has diffrence.

What do you think?

[williamdes]

Hey @yashrajbothra I do not agree
Having a hidden field to detect if the value was changed by the user is the right solution :)

Ex:
AI value
AI initial value

If (AI value! = AI initial value)
//User changed the value
Update the AI value ()

[yashrajbothra]

Okay this also seems good solution i will try to implement this 👍