liangcd opened a new issue #2389: sharding-proxy fail to handle '0000-00-00 00:00:00' Timestamp result URL: https://github.com/apache/incubator-shardingsphere/issues/2389 Title: sharding-proxy fail to handle '0000-00-00 00:00:00' Timestamp result Env: sharding-proxy-4.0.0-RC1 Problem: mysql> mysql> * from tb_user_info limit 1; ERROR: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp Other Info: Create table sql: CREATE TABLE `tb_user_info` ( `USER_CODE` varchar(50) NOT NULL, `CREATE_TIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `UPDATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `USER_NAME` varchar(200) DEFAULT NULL, PRIMARY KEY (`USER_CODE`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
