ID,Entered,Modified,Type,Status,Severity,Version,OS,Summary
33240,2007-12-14 12:43:04,2007-12-14 17:21:41,Server: DDL,Verified,S3,"5.0.45, 5.0, 5.1, 6.0 BK","Any (Mac OS X 10.5.1, Linux)","ALTER TABLE fails for DATETIME column under certain circumstances"
40910,2008-11-20 22:34:03,2009-01-12 17:21:18,Server: General,Verified,S2,"4.1.22, 5.0.70, 5.1.22-rc, 5.1.30, 6.0.7","Any (7.0)","SELECT MAX(DATETIME) INTO @var yields LONGBLOB"
51521,2010-02-25 18:03:55,2010-02-26 08:16:23,Server: Optimizer,Verified,S2,"5.1.42, 5.1.45-bzr","Any","MERGE Algorithm in LEFT JOIN retuns 0000-00-00 instead of NULL"
64058,2012-01-18 14:14:41,2012-01-19 00:27:18,Server: Types,Verified,S2," 5.5.20","MacOS (10.7.2)","DATETIME data type botched in queries."
68072,2013-01-12 18:02:32,2013-01-13 15:02:07,Server: Optimizer,Verified,S2,"5.1, 5.5","Any (Win64, CentOS Linux)","MySQL 5.1 issue with timediff, group by on multiple columns, join, primary key"
74449,2014-10-20 09:39:09,2014-10-20 10:44:48,Server: Charsets,Verified,S3,"5.5.40, 5.6.21, 5.7.5, 5.6.22","Linux (CentOS 6.3)","Incorrect datetime casting with charcter_set_connection=sjis"
77805,2015-07-23 02:01:35,2015-07-23 04:58:40,Server: DML,Verified,S1,"5.6.25 MySQL Community Server (GPL)","Ubuntu (Ubuntu 14.04.2 LTS x86_64)","NULLIF cause wrong value with cast datetime"
84082,2016-12-06 19:01:28,2016-12-08 23:03:40,Server: JSON,Verified,S3,"5.7.14-google-log","Any","JSON_OBJECT(""k"", dateTime) adds milliseconds to time"
87288,2017-08-02 20:08:19,2017-08-03 07:00:10,MySQL Workbench: Modeling,Verified,S3,"6.3.9","Windows (Microsoft Windows 10 Pro)","Sync Model to Live - DATETIME ON UPDATE CURRENT_TIMESTAMP"
87712,2017-09-08 15:47:54,2017-09-18 10:14:43,MySQL Workbench,Verified,S3,"6.3.9","Any","Fractional DATETIME setting is not recognized as a change in the API"
87644,2017-09-01 22:19:02,2018-04-25 13:37:47,Server: Optimizer,Verified,S2,"5.7.18","CentOS (6 (x86_64))","Order by on 'datetime' column not working with LIMIT <row_count>"
118887,2025-08-25 02:49:26,2025-08-25 09:13:40,Server: Optimizer,Verified,S3,"9.4.0","CentOS","Zero '0000-00-00 00:00:00' datetime returned when SQL_BUFFER_RESULT is used"
119313,2025-11-06 03:03:59,2025-12-06 21:21:33,Server: Optimizer,Verified,S3,"8.0.41","Any","BETWEEN clause returns incorrect results when comparing numeric literal with DATETIME columns"