"Extra" column definition not editable

[Simbiat]

Describe the bug

When editing a column "extra" definitions are not editable and not visible. Only AUTO_INCREMENT is visible and editable as a separate option, but, for example, ON UPDATE CURRENT_TIMESTAMP is not visible or editable. Furthermore, when you try to edit such a column, such extra definition will be lost. It is retained however when exporting the table with such column.

To Reproduce

Steps to reproduce the behavior:

1. Add column with ON UPDATE CURRENT_TIMESTAMP (will require manually running an SQL) clause in its definition
2. Attempt to edit it through UI (say, add a comment)
3. Save changes
4. Check current definition of the column and see, that it's missing ON UPDATE CURRENT_TIMESTAMP

Expected behavior

At least it should show extra definitions and preserve them when changing column through UI. Ideally - also allow to edit them.

Screenshots

N/A

Server configuration

• Operating system: Win10
• Web server: Apache 2.4
• Database version: 10.2.31-MariaDB
• PHP version: 7.4.3
• phpMyAdmin version: 5.0.1

Client configuration

• Browser: MS Edge
• Operating system: Win10

Additional context

N/A

[williamdes]

Hi @Simbiat

Thank you for the report, I would say the bug is that it is not selected in the Extra selector automatically when editing the column ?

[Simbiat]

Did not even notice it was there in the field even :D But, yes, this seems to be the case. Although, I am not sure it's correct to have "on update CURRENT_TIMESTAMP" in the "Attributes" field, because you may need both, say, UNSIGNED and "on update". I am also not sure, whether "CURRENT_TIMESTAMP" is the only possible clause for "on update", although was not able to google anything proving that.

[williamdes]

Except the bug do you have comments on the previous message @OlafvdSpek?

[OlafvdSpek]

on update current_timestamp is available for datetime and timestamp columns (and maybe others) but not for columns where binary or unsigned are available.

As far as I know current_timestamp is the only option available for on update.

[iifawzi]

is this bug still exists? seems like it's already fixed. as i'm not able to re-produce the bug with the current version.

[Simbiat]

@iifawzi this is replicable in 5.1.0-rc2, at least. Just follow the steps described in original post. The issue here is that "EXTRA" is not showed by "Edit Column" UI at all (yet, AUTO_INCREMENT is preserved somehow).