WordPress.org

Make WordPress Core

Changes between Initial Version and Version 1 of Ticket #46994


Ignore:
Timestamp:
04/19/2019 02:10:10 PM (6 months ago)
Author:
SergeyBiryukov
Comment:

Related: #8857, #26847, #41785.

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #46994 – Description

    initial v1  
    1 The conversation in #43535 seems like it should have resulted in a default like '1970-01-01 00:00:01' to match the minimal valid value of TIMESTAMP. Instead, it uses the "special zero date" 0000-00-00 00:00:00 which generates an error with the default strict modes in MySQL 5.7 and MySQL 8.0. I'd also be fine with null, but I acknowledge that tables may be set to disallow null.
     1The conversation in #43545 seems like it should have resulted in a default like '1970-01-01 00:00:01' to match the minimal valid value of TIMESTAMP. Instead, it uses the "special zero date" 0000-00-00 00:00:00 which generates an error with the default strict modes in MySQL 5.7 and MySQL 8.0. I'd also be fine with null, but I acknowledge that tables may be set to disallow null.