MySQL
if the datatype is date, time, timestamp, datetime and the default value is one of [current_date, current_time, current_timestamp, current_curtime, current_sysdate, current_unix_timestamp, current_row] it does not put a quote.
Can we add now() to the list as well ? Currently if we try to alter the table and add now() ADS adds a quote around 'now()' which on execution gives incorrect syntax
|
250 KB
|
290 KB
|
25 KB
now() will no longer be quoted for default value in mysql when date type datatypes used.
Issue #13317 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v17.0.0-alpha-9 |
No time estimate |
now() will no longer be quoted for default value in mysql when date type datatypes used.