Menu

#862 timestamp set to current_timestamp CANNOT BE UN-DONE

4.8.1
closed-rejected
nobody
None
1
2025-02-19
2023-06-12
No

Create a table with this

CREATE TABLE bug (
id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
currentTimeStampBug timestamp NULL ON UPDATE CURRENT_TIMESTAMP
);

And then, using the UI, try to REMOVE the "ON UPDATE CURRENT_TIMESTAMP".
It will ALWAYS be set, regardless of what you click / try to do.

If the field is 'datetime' though, all seems working fine

Discussion

  • Peter Knut

    Peter Knut - 2024-10-04

    I can not reproduce this problem with MariaDB 11.5.2 and latest Adminer.

     
  • Jakub Vrána

    Jakub Vrána - 2025-02-19
    • status: open --> closed-rejected
     
  • Jakub Vrána

    Jakub Vrána - 2025-02-19

    It's the default behavior of this type.

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.