Mysql 时间戳未设置精度引发的血案

使用mysql少不了日期类型 平时直接用缺省的配置 没想到出现了修改完一条记录后记录数少一的情况....

客户端操作：修改一条数据结果：原来有三条数据，修改一条变成了两条，点击搜索按钮 恢复三条原因如下：首先看日志：

Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@69be8ad6]Creating a new SqlSessionSqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6c075c12] was not registered for synchronization because synchronization is not activeJDBC Connection [HikariProxyConnection@878728374 wrapping com.mysql.cj.jdbc.ConnectionImpl@2ba1987c] will not be managed by Spring==>  Preparing: UPDATE door_ctrl_dev SET acsdevindexcode=?, acsdevname=?, acsdevtypedesc=?, acsdevtypecode=?, acsdevtypename=?, acsdevip=?, acsdevport=?, updatetime=?, dev_username=?, dev_password=?, remark=?, project_id=?, area_id=? WHERE deleted=0 AND acsdevindexcode = ? ==> Parameters: 12w(String), 12wws122212(String), 12(String), 201926912(String), 门禁一体机(String), 21(String), 1(String), 2019-09-29 14:05:10.614(Timestamp), (String), (String), (String), a5a35309a4fc7445bfb6b687556c1943(String), 3022f53d6d81564919f2cf21d9a78778(String), 12w(String)  Preparing: SELECT COUNT(1) FROM door_ctrl_dev WHERE deleted = 0 AND project_id = ? AND area_id = ? AND updatetime BETWEEN ? AND ? AND createtime BETWEEN ? AND ? ==> Parameters: a5a35309a4fc7445bfb6b687556c1943(String), 3022f53d6d81564919f2cf21d9a78778(String), 1970-01-01 08:00:00.0(Timestamp), 2019-09-29 14:05:10.749(Timestamp), 1970-01-01 08:00:00.0(Timestamp), 2019-09-29 14:05:10.749(Timestamp) Parameters: a5a35309a4fc7445bfb6b687556c1943(String), 3022f53d6d81564919f2cf21d9a78778(String), 1970-01-01 08:00:00.0(Timestamp), 2019-09-29 14:05:10.749(Timestamp), 1970-01-01 08:00:00.0(Timestamp), 2019-09-29 14:05:10.749(Timestamp), 0(Long), 10(Long)