MySQL Bugs MySQL AB Bugs Database http://bugs.mysql.com/ MySQL Bugs http://bugs.mysql.com/images/mysql_100x52-64.gif http://bugs.mysql.com/ http://bugs.mysql.com/33240 #33240: ALTER TABLE fails for DATETIME column under certain circumstances http://bugs.mysql.com/bug.php?id=33240 Submitted by: Per Hallström
Category: Server: DDL
Status: Verified
Severity: 3
OS: Any (Mac OS X 10.5.1, Linux)
Version: 5.0.45, 5.0, 5.1, 6.0 BK
]]> Fri, 14 Dec 2007 12:43:04 +0000 Server: DDL http://bugs.mysql.com/40910 #40910: SELECT MAX(DATETIME) INTO @var yields LONGBLOB http://bugs.mysql.com/bug.php?id=40910 Submitted by: Yvan Rodrigues
Category: Server: General
Status: Verified
Severity: 2
OS: Any (7.0)
Version: 4.1.22, 5.0.70, 5.1.22-rc, 5.1.30, 6.0.7
]]> Thu, 20 Nov 2008 22:34:03 +0000 Server: General http://bugs.mysql.com/51521 #51521: MERGE Algorithm in LEFT JOIN retuns 0000-00-00 instead of NULL http://bugs.mysql.com/bug.php?id=51521 Submitted by: Drew Vogel
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any
Version: 5.1.42, 5.1.45-bzr
]]> Thu, 25 Feb 2010 18:03:55 +0000 Server: Optimizer http://bugs.mysql.com/64058 #64058: DATETIME data type botched in queries. http://bugs.mysql.com/bug.php?id=64058 Submitted by: Laurent Michel
Category: Server: Types
Status: Verified
Severity: 2
OS: MacOS (10.7.2)
Version: 5.5.20
]]> Wed, 18 Jan 2012 14:14:41 +0000 Server: Types http://bugs.mysql.com/68072 #68072: MySQL 5.1 issue with timediff, group by on multiple columns, join, primary key http://bugs.mysql.com/bug.php?id=68072 Submitted by: Gergely Kutenics
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: Any (Win64, CentOS Linux)
Version: 5.1, 5.5
]]> Sat, 12 Jan 2013 18:02:32 +0000 Server: Optimizer http://bugs.mysql.com/74449 #74449: Incorrect datetime casting with charcter_set_connection=sjis http://bugs.mysql.com/bug.php?id=74449 Submitted by: Tsubasa Tanaka
Category: Server: Charsets
Status: Verified
Severity: 3
OS: Linux (CentOS 6.3)
Version: 5.5.40, 5.6.21, 5.7.5, 5.6.22
]]> Mon, 20 Oct 2014 09:39:09 +0000 Server: Charsets http://bugs.mysql.com/77805 #77805: NULLIF cause wrong value with cast datetime http://bugs.mysql.com/bug.php?id=77805 Submitted by: James Fan
Category: Server: DML
Status: Verified
Severity: 1
OS: Ubuntu (Ubuntu 14.04.2 LTS x86_64)
Version: 5.6.25 MySQL Community Server (GPL)
]]> Thu, 23 Jul 2015 02:01:35 +0000 Server: DML http://bugs.mysql.com/84082 #84082: JSON_OBJECT("k", dateTime) adds milliseconds to time http://bugs.mysql.com/bug.php?id=84082 Submitted by: enzo mdd
Category: Server: JSON
Status: Verified
Severity: 3
OS: Any
Version: 5.7.14-google-log
]]> Tue, 06 Dec 2016 19:01:28 +0000 Server: JSON http://bugs.mysql.com/87288 #87288: Sync Model to Live - DATETIME ON UPDATE CURRENT_TIMESTAMP http://bugs.mysql.com/bug.php?id=87288 Submitted by: Will Baumbach
Category: MySQL Workbench: Modeling
Status: Verified
Severity: 3
OS: Windows (Microsoft Windows 10 Pro)
Version: 6.3.9
]]> Wed, 02 Aug 2017 20:08:19 +0000 MySQL Workbench: Modeling http://bugs.mysql.com/87712 #87712: Fractional DATETIME setting is not recognized as a change in the API http://bugs.mysql.com/bug.php?id=87712 Submitted by: Andy Schmidt
Category: MySQL Workbench
Status: Verified
Severity: 3
OS: Any
Version: 6.3.9
]]> Fri, 08 Sep 2017 15:47:54 +0000 MySQL Workbench http://bugs.mysql.com/87644 #87644: Order by on 'datetime' column not working with LIMIT <row_count> http://bugs.mysql.com/bug.php?id=87644 Submitted by: KORBULY Francois
Category: Server: Optimizer
Status: Verified
Severity: 2
OS: CentOS (6 (x86_64))
Version: 5.7.18
]]> Fri, 01 Sep 2017 22:19:02 +0000 Server: Optimizer http://bugs.mysql.com/118887 #118887: Zero '0000-00-00 00:00:00' datetime returned when SQL_BUFFER_RESULT is used http://bugs.mysql.com/bug.php?id=118887 Submitted by: Kliar Ma
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: CentOS
Version: 9.4.0
]]> Mon, 25 Aug 2025 02:49:26 +0000 Server: Optimizer http://bugs.mysql.com/119313 #119313: BETWEEN clause returns incorrect results when comparing numeric literal with DATETIME columns http://bugs.mysql.com/bug.php?id=119313 Submitted by: Alice Alice
Category: Server: Optimizer
Status: Verified
Severity: 3
OS: Any
Version: 8.0.41
]]> Thu, 06 Nov 2025 03:03:59 +0000 Server: Optimizer