Bug #91001 Incorrect datetime value with special value such as '2018-03-11 02:23:06'

• Submitted: 24 May 2018 0:26
• Modified: 24 May 2018 0:49
• Reporter: Zhanglin He
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• OS: Ubuntu (16.04)
• CPU Architecture: x86

[24 May 2018 0:26] Zhanglin He

Description:
#mysql --version
mysql  Ver 14.14 Distrib 5.7.22, for Linux (x86_64) using  EditLine wrapper

#uname -a
Linux sanya 4.13.0-39-generic #44~16.04.1-Ubuntu SMP Thu Apr 5 16:43:10 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux

Create table:
CREATE TABLE test ( verification_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
Insert record:
INSERT INTO test (verification_time) VALUE ('2018-03-11 02:23:06');
ERROR 1292 (22007): Incorrect datetime value: '2018-03-11 02:23:06' for column 'verification_time' at row 1

INSERT INTO test (verification_time) VALUE ('2018-03-11 03:23:06');
Query OK, 1 row affected (0.04 sec)

How to repeat:
Create table:
CREATE TABLE test ( verification_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP );

Insert record:
INSERT INTO test (verification_time) VALUE ('2018-03-11 02:23:06');

ERROR 1292 (22007): Incorrect datetime value: '2018-03-11 02:23:06' for column 'verification_time' at row 1

[24 May 2018 0:49] MySQL Verification Team

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

C:\dbs>c:\dbs\5.7\bin\mysql -uroot --port=3570 -p  --prompt="mysql 5.7 > "
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.23-log Source distribution BUILD: 2018-MAY-16

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql 5.7 > USE test
Database changed
mysql 5.7 > CREATE TABLE test ( verification_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
Query OK, 0 rows affected (0.04 sec)

mysql 5.7 > INSERT INTO test (verification_time) VALUE ('2018-03-11 02:23:06');
Query OK, 1 row affected (0.01 sec)

mysql 5.7 >