| Bug #83276 | P_S.replication_connection_status contains a zero datetime | ||
|---|---|---|---|
| Submitted: | 6 Oct 2016 1:03 | Modified: | 6 Oct 2016 7:29 |
| Reporter: | Justin Swanhart | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Performance Schema | Severity: | S2 (Serious) |
| Version: | 5.7,8 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[6 Oct 2016 1:06]
Justin Swanhart
update version
[6 Oct 2016 7:29]
MySQL Verification Team
Hello Justin, Thank you for the report and feedback! Thanks, Umesh
Description: The default SQL_MODE for MySQL 8 is NO_ZERO_DATE, which I assume means that you strongly discourage their use. I suggest that zero dates in P_S should be NULL instead to be compatible with the default SQL_MODE. How to repeat: select * from performance_schema.replication_connection_status\G *************************** 1. row *************************** CHANNEL_NAME: GROUP_NAME: SOURCE_UUID: 00015503-0000-0000-0000-000000000000 THREAD_ID: NULL SERVICE_STATE: OFF COUNT_RECEIVED_HEARTBEATS: 122 LAST_HEARTBEAT_TIMESTAMP: 2016-10-05 18:27:19 RECEIVED_TRANSACTION_SET: LAST_ERROR_NUMBER: 0 LAST_ERROR_MESSAGE: LAST_ERROR_TIMESTAMP: 0000-00-00 00:00:00 1 row in set (0.00 sec)