#158 Timestamp columns are updated even w/ func set to `original`

3.2.2
closed-fixed
Jakub Vrána
MySQL (65)
4
2011-06-08
2011-06-06
Anonymous
No

Editing multiple rows with columns with `timestamp NULL` that defaults to `CURRENT_TIMESTAMP` updates the timestamp while the selectbox was set to `original`.

That is understandable as the column is created as:

`create` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

The bulk edit selectbox should rather be set to `now` by default and `original` should keep the original value (thus bypassing the ON UPDATE cause).

Selectbox: http://d.pr/7kni

Discussion


  • Anonymous
    2011-06-06

    • priority: 5 --> 4
    • milestone: --> 3.2.2
     
  • Jakub Vrána
    Jakub Vrána
    2011-06-08

    • labels: 1212738 --> MySQL
    • status: open --> closed-fixed
     
  • Jakub Vrána
    Jakub Vrána
    2011-06-08

    Thank you for the report, I've fixed it in Git. You can download the "Current development version" from http://www.adminer.org/en/#download