| Showing all 14 (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 (5525 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 |
| 38915 | 2008-08-20 13:30 | 2020-05-03 20:45 | MySQL Server: Data Types | Verified (5275 days) | S3 | 5.0.45, 5.0.67, 5.1.26 | Linux | Any | LIKE query on DATETIME raises warning |
| 40910 | 2008-11-20 22:34 | 2011-02-16 23:43 | MySQL Server: General | Verified (5130 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 (4720 days) | S2 | 5.1.42, 5.1.45-bzr | Any | Any | MERGE Algorithm in LEFT JOIN retuns 0000-00-00 instead of NULL |
| 57018 | 2010-09-25 15:32 | 2018-09-09 20:45 | MySQL Server: Data Types | Verified (4509 days) | S3 | 5.1.49, 5.1.52-bzr | Any | Any | Incorrect result when using BETWEEN comparison on an indexed DATETIME column. |
| 60724 | 2011-04-01 16:19 | 2011-04-05 14:50 | MySQL Server: DML | Verified (4321 days) | S2 | 5.5.11, 5.5.10-log, 5.1.57, 5.0.93 | Any | Any | Unquoted date literal in comparison yields incorrect implicit conversion |
| 64058 | 2012-01-18 14:14 | 2012-01-19 14:05 | MySQL Server: Data Types | Verified (4028 days) | S2 | 5.5.20 | MacOS (10.7.2) | Any | DATETIME data type botched in queries. |
| 68072 | 2013-01-12 18:02 | 2013-01-13 15:08 | MySQL Server: Optimizer | Verified (3668 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 |
| 74449 | 2014-10-20 9:39 | 2014-10-20 10:44 | MySQL Server: Charsets | Verified (3023 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 |
| 77805 | 2015-07-23 2:01 | 2015-07-23 5:01 | MySQL Server: DML | Verified (2747 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 |
| 84082 | 2016-12-06 19:01 | 2016-12-08 23:04 | MySQL Server: JSON | Verified (2243 days) | S3 | 5.7.14-google-log | Any | Any | JSON_OBJECT("k", dateTime) adds milliseconds to time |
| 87288 | 2017-08-02 20:08 | 2017-08-03 7:00 | MySQL Workbench: Modeling | Verified (2005 days) | S3 | 6.3.9 | Windows (Microsoft Windows 10 Pro) | Any | Sync Model to Live - DATETIME ON UPDATE CURRENT_TIMESTAMP |
| 87712 | 2017-09-08 15:47 | 2017-09-18 10:16 | MySQL Workbench | Verified (1959 days) | S3 | 6.3.9 | Any | Any | Fractional DATETIME setting is not recognized as a change in the API |
| 87644 | 2017-09-01 22:19 | 2022-09-06 8:01 | MySQL Server: Optimizer | Verified (1740 days) | S2 | 5.7.18 | CentOS (6 (x86_64)) | Any | Order by on 'datetime' column not working with LIMIT <row_count> |
| Showing all 14 (Edit, Save, CSV, Feed) |
