Bug: Updating company columns when time field exists
Daniel Mulroy last edited by
When adding a column to a table with a time field that has an existing default value, the alteration fails.
It should work
When rendering the default value for the time field, the number is formatted for humans. I.e. 110000 becomes 11:00:00 in the UI.
However, when altering the table, your code is performing an UPDATE query that tries to set 11:00:00 as the default value for a TIME type column, which fails.
Manually editing 11:00:00 to 110000 before saving your changes to the table causes the update to succeed.