ID,Entered,Modified,Type,Status,Severity,Version,OS,Summary 5054,2004-08-14 02:49:38,2014-01-08 13:17:35,Server: Types,Can't repeat,S3,"4.1.2","Linux (Linux FedCore 2)","Bug comparing date and datetime with 'between'" 21677,2006-08-16 18:48:48,2025-12-13 15:36:11,Server: Types,Can't repeat,S3,"4.1.21, 5.0.23","Linux (Linux)","Change in results with ""now() BETWEEN date_field1 AND date_field2""" 25223,2006-12-20 19:45:27,2007-02-20 18:13:29,Server: Types,Can't repeat,S3,"5.0.27","Linux (opensuse 10.0)","LOAD DATA INFILE -- problems with varchar field" 26626,2007-02-25 23:03:57,2008-04-27 07:29:49,Server: Types,Can't repeat,S3,"5.0.26, 5.0.44","Linux (Linux, Gentoo)","mysql Error: ""Warning | 1265 | Data truncated for column '""" 28157,2007-04-30 03:44:46,2007-04-30 05:10:28,Server: Types,Can't repeat,S3,"5.0.22","Any","CHAR(0) displays NULL" 28632,2007-05-23 21:36:45,2007-05-24 08:59:16,Server: Types,Can't repeat,S3,"5.0.41","Linux","Comparison of DATE columns - difference between 4.1 and 5.0" 28888,2007-06-05 01:25:07,2007-06-05 10:21:06,Server: Types,Can't repeat,S3,"4.0.25","Any","CAST on TEXT field returns BLOB when ORDERED BY" 29084,2007-06-13 18:03:40,2007-08-01 20:36:56,Server: Types,Can't repeat,S3,"5.1.19-beta-log","Linux (Debian 2.6.18-3-amd64)","Incorrect data conversion by unhex" 29655,2007-07-09 18:24:56,2007-07-13 17:24:34,Server: Types,Can't repeat,S3,"5.0.42","Linux (gentoo amd64)","GREATEST()/LEAST() functions drop date results in between join" 29860,2007-07-18 00:22:06,2007-07-24 12:13:30,Server: Types,Can't repeat,S1,"5.0.42, 6.0-Falcon","Linux (Gentoo Linux)","DELETE query fails on tables with a CHAR type column as a primary key." 30361,2007-08-10 16:32:00,2007-08-14 18:40:23,Server: Types,Can't repeat,S2,"5.0.45 community","Windows (2003 SP2)","Incorrect datetime value '2003-03-09 02:33:07'" 30987,2007-09-12 17:46:09,2007-10-31 19:31:37,Server: Types,Can't repeat,S3,"5.0.44","Any","mysql Error: Warning | 1366 | Incorrect string value: '\xB4 FFFF...' for column " 31195,2007-09-25 23:01:47,2007-09-25 23:35:41,Server: Types,Can't repeat,S2,"5.0.22-Debian_0ubuntu6.06.3","Linux (Ubuntu Dapper Drake (6.06.1))","Unable to query certain DECIMAL data type values on 64-bit linux" 31710,2007-10-19 09:33:53,2007-10-19 09:51:31,Server: Types,Can't repeat,S1,"5.0.45","Any","date type problems with using index" 33772,2008-01-09 14:58:49,2026-03-24 20:50:05,Server: Types,Can't repeat,S3,"5.0-bk, 5.1-bk","Any","Monthname (string) comparison with Month (integer) succeeds where it shouldn't" 34029,2008-01-24 05:39:49,2008-01-24 07:15:05,Server: Types,Can't repeat,S3,"5.0.x","Linux (Fedora Core 5 + 6)","Time data types are not reported as correct type when used in a sub query" 34385,2008-02-07 17:40:47,2021-02-23 08:10:07,Server: Types,Can't repeat,S2,"5.0.45, 5.0, 5.1, 6.0 BK","Any (Linux, Windows XP)","IFNULL change result DataType" 34776,2008-02-23 11:47:00,2010-03-18 10:01:20,Server: Types,Can't repeat,S2,"5.0.62-debug, 5.0.66a-debug,5.1.23-debug","Any","Assertion failed:scale >=0 && precision>0&& scale<=precisiondecimal.c line 1462 " 35288,2008-03-14 11:47:00,2008-03-14 15:17:42,Server: Types,Can't repeat,S2,"5.0.32-Debian_7etch5-log","Linux (Debian 2.6.18-6-686)","SEC_TO_TIME Does'nt return large hour format" 36615,2008-05-09 07:27:06,2008-05-14 20:50:14,Server: Types,Can't repeat,S3,"5.0.51b","HP/UX (11iV1 64bit)","Floating point number incorrectly stored in 64 bit integer if it has 20+ digits" 38219,2008-07-18 06:24:05,2008-08-04 13:54:53,Server: Types,Can't repeat,S1,"4.1.22","Linux","Database Related Issue" 38915,2008-08-20 13:30:55,2025-12-26 22:41:04,Server: Types,Can't repeat,S3,"5.0.45, 5.0.67, 5.1.26","Linux","LIKE query on DATETIME raises warning" 45004,2009-05-21 08:46:43,2025-12-13 15:46:58,Server: Types,Can't repeat,S2,"5.0.81, 5.0.83-bzr","Any","Date Value" 47089,2009-09-03 09:44:07,2009-09-05 16:58:19,Server: Types,Can't repeat,S2,"5.0.45","Any","DATETIME comparison in CASE statement with fractional seconds fails" 50231,2010-01-11 13:10:27,2010-01-15 07:51:43,Server: Types,Can't repeat,S3,"5.1-bugteam","Any","Select shows different outputs for 'bigint' column containing 'null' values" 57298,2010-10-07 08:23:47,2010-10-07 16:46:55,Server: Types,Can't repeat,S3,"5.1.51","Any","ENUMs do not obey strict sql_mode and empty string can insert when not specified" 58065,2010-11-08 21:31:16,2025-12-13 16:08:26,Server: Types,Can't repeat,S2,"5.1.51, 5.1.52, 5.0, 5.1, 5.6.99 bzr","Linux (x64, 2.6.32)","join condition handles date columns differently if there's a unique key" 60274,2011-02-28 00:00:54,2011-02-28 00:26:24,Server: Types,Can't repeat,S3,"","Any","Won't take phone numbers" 60990,2011-04-28 10:48:32,2025-12-14 17:47:29,Server: Types,Can't repeat,S3,"5.5, 5.1.56","Any","incorrect date comparison" 61193,2011-05-16 22:49:55,2025-12-14 17:57:58,Server: Types,Can't repeat,S3,"5.1.58, 5.5","Any","incorrect rounding of date DECIMAL(17,3) " 66034,2012-07-26 19:01:17,2025-12-11 21:56:43,Server: Types,Can't repeat,S3,"5.1, 5.5, 5.6","Any","Inconsistent results while comparing time fields with string and number literals" 66480,2012-08-21 09:04:06,2025-12-11 21:59:54,Server: Types,Can't repeat,S3,"5.5.27, 5.5.28","Any (Squeeze)","Myql comparison of curtime() with a constant in utf8" 72958,2014-06-11 11:51:11,2014-06-11 16:55:08,Server: Types,Can't repeat,S2,"5.5.32-cll-lve","Linux (Shared hoster custom build)","ENUM with default value set generates Errno=1067" 77968,2015-08-06 21:59:38,2015-08-17 11:10:29,Server: Types,Can't repeat,S1,"5.0.15 Standard Log","Linux","In TIME type values like ""10:98:72"", are getting inserted" 85463,2017-03-15 11:29:06,2017-03-16 01:27:05,Server: Types,Can't repeat,S2,"5.7","Windows","varchar(64) varchar(255) lead to bug" 93072,2018-11-04 10:39:17,2018-11-04 16:52:48,Server: Types,Can't repeat,S3,"5.7.20","Linux (Centos)","ENUM Datatype storing undefined value in column which is not in list" 96585,2019-08-19 14:21:18,2019-08-19 23:03:43,Server: Types,Can't repeat,S3,"8.0.17","Debian (10)","Error Code: 1292. Incorrect datetimevalue for correct dates?" 96620,2019-08-22 13:14:17,2019-09-24 11:41:26,Server: Types,Can't repeat,S2,"5.6.10","Any","The CONVERT_TZ function fetches wrong value for ""Asia/Irkutsk"" timezone" 105517,2021-11-10 13:36:10,2026-04-25 13:02:38,Server: Types,Can't repeat,S2,"8.0","Any (20.0.4.1)","INSERT of CURRENT_TIMESTAMP() vs. DEFAULT differs for TIMESTAMP field" 111971,2023-08-04 10:54:06,2023-08-07 07:00:06,Server: Types,Can't repeat,S3,"MySQL Community Server 8.1.0 ","Windows (Python MySQl connector V8)","Data format changed during Select/Insert query" 112103,2023-08-18 02:02:16,2023-08-18 13:03:42,Server: Types,Can't repeat,S3,"","Any","The query takes too long to execute with no results" 113463,2023-12-19 16:07:59,2023-12-20 11:54:18,Server: Types,Can't repeat,S3,"8.0","Any","bigint、int、tinyint数据类型bug 8.0版本"