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