Feeling Lucky
bug
v1.0
[#158] - CURRENT_TIMESTAMP
- Closed
- 20 Oct 2013
- Medium
- Build: master
- # 158
I am manually creating the database via phpMyAdmin and ran into a problem where two DATETIME fields are defined with DEFAULT CURRENT_TIMESTAMP.
Not sure if the DB package converts that, or not, based on the database? But, MySQL only uses that default with the timestamp datatype. It fails with the datatime.
Maybe not something concerning for now, but thought I'd throw that out there.
Thanks!
-
Confirmed.
CURRENT_TIMESTAMP is only acceptable on TIMESTAMP fields.
As of mysql 5.6.5, you can use CURRENT_TIMESTAMP with DATETIME fields.
Reference
BTW here is the commit that changed the behaviour - 5775f38