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/5054 #5054: Bug comparing date and datetime with 'between' http://bugs.mysql.com/bug.php?id=5054 Submitted by: Robert Nice
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Linux (Linux FedCore 2)
Version: 4.1.2
]]> Sat, 14 Aug 2004 02:49:38 +0000 Server: Types http://bugs.mysql.com/21677 #21677: Change in results with "now() BETWEEN date_field1 AND date_field2" http://bugs.mysql.com/bug.php?id=21677 Submitted by: Benjamin Morin
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Linux (Linux)
Version: 4.1.21, 5.0.23
]]> Wed, 16 Aug 2006 18:48:48 +0000 Server: Types http://bugs.mysql.com/25223 #25223: LOAD DATA INFILE -- problems with varchar field http://bugs.mysql.com/bug.php?id=25223 Submitted by: Maciej Pilichowski
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Linux (opensuse 10.0)
Version: 5.0.27
]]> Wed, 20 Dec 2006 19:45:27 +0000 Server: Types http://bugs.mysql.com/26626 #26626: mysql Error: "Warning | 1265 | Data truncated for column '" http://bugs.mysql.com/bug.php?id=26626 Submitted by: dennismoore@dodgeit.com dennismoore@dodgeit.com
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Linux (Linux, Gentoo)
Version: 5.0.26, 5.0.44
]]> Sun, 25 Feb 2007 23:03:57 +0000 Server: Types http://bugs.mysql.com/28157 #28157: CHAR(0) displays NULL http://bugs.mysql.com/bug.php?id=28157 Submitted by: Mike Painter
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.0.22
]]> Mon, 30 Apr 2007 03:44:46 +0000 Server: Types http://bugs.mysql.com/28632 #28632: Comparison of DATE columns - difference between 4.1 and 5.0 http://bugs.mysql.com/bug.php?id=28632 Submitted by: Nicolas Moldavsky
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Linux
Version: 5.0.41
]]> Wed, 23 May 2007 21:36:45 +0000 Server: Types http://bugs.mysql.com/28888 #28888: CAST on TEXT field returns BLOB when ORDERED BY http://bugs.mysql.com/bug.php?id=28888 Submitted by: Jim Palmer
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Any
Version: 4.0.25
]]> Tue, 05 Jun 2007 01:25:07 +0000 Server: Types http://bugs.mysql.com/29084 #29084: Incorrect data conversion by unhex http://bugs.mysql.com/bug.php?id=29084 Submitted by: Sergey Serov
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Linux (Debian 2.6.18-3-amd64)
Version: 5.1.19-beta-log
]]> Wed, 13 Jun 2007 18:03:40 +0000 Server: Types http://bugs.mysql.com/29655 #29655: GREATEST()/LEAST() functions drop date results in between join http://bugs.mysql.com/bug.php?id=29655 Submitted by: John Miller
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Linux (gentoo amd64)
Version: 5.0.42
]]> Mon, 09 Jul 2007 18:24:56 +0000 Server: Types http://bugs.mysql.com/29860 #29860: DELETE query fails on tables with a CHAR type column as a primary key. http://bugs.mysql.com/bug.php?id=29860 Submitted by: Charles Taylor
Category: Server: Types
Status: Can't repeat
Severity: 1
OS: Linux (Gentoo Linux)
Version: 5.0.42, 6.0-Falcon
]]> Wed, 18 Jul 2007 00:22:06 +0000 Server: Types http://bugs.mysql.com/30361 #30361: Incorrect datetime value '2003-03-09 02:33:07' http://bugs.mysql.com/bug.php?id=30361 Submitted by: Richard Ayotte
Category: Server: Types
Status: Can't repeat
Severity: 2
OS: Windows (2003 SP2)
Version: 5.0.45 community
]]> Fri, 10 Aug 2007 16:32:00 +0000 Server: Types http://bugs.mysql.com/30987 #30987: mysql Error: Warning | 1366 | Incorrect string value: '\xB4 FFFF...' for column http://bugs.mysql.com/bug.php?id=30987 Submitted by: klx out
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.0.44
]]> Wed, 12 Sep 2007 17:46:09 +0000 Server: Types http://bugs.mysql.com/31195 #31195: Unable to query certain DECIMAL data type values on 64-bit linux http://bugs.mysql.com/bug.php?id=31195 Submitted by: Jay Rossiter
Category: Server: Types
Status: Can't repeat
Severity: 2
OS: Linux (Ubuntu Dapper Drake (6.06.1))
Version: 5.0.22-Debian_0ubuntu6.06.3
]]> Tue, 25 Sep 2007 23:01:47 +0000 Server: Types http://bugs.mysql.com/31710 #31710: date type problems with using index http://bugs.mysql.com/bug.php?id=31710 Submitted by: Tom OYA
Category: Server: Types
Status: Can't repeat
Severity: 1
OS: Any
Version: 5.0.45
]]> Fri, 19 Oct 2007 09:33:53 +0000 Server: Types http://bugs.mysql.com/33772 #33772: Monthname (string) comparison with Month (integer) succeeds where it shouldn't http://bugs.mysql.com/bug.php?id=33772 Submitted by: Vares Pierre-Olivier
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.0-bk, 5.1-bk
]]> Wed, 09 Jan 2008 14:58:49 +0000 Server: Types http://bugs.mysql.com/34029 #34029: Time data types are not reported as correct type when used in a sub query http://bugs.mysql.com/bug.php?id=34029 Submitted by: Malcolm Sharman
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Linux (Fedora Core 5 + 6)
Version: 5.0.x
]]> Thu, 24 Jan 2008 05:39:49 +0000 Server: Types http://bugs.mysql.com/34385 #34385: IFNULL change result DataType http://bugs.mysql.com/bug.php?id=34385 Submitted by: Mathieu Tremblay
Category: Server: Types
Status: Can't repeat
Severity: 2
OS: Any (Linux, Windows XP)
Version: 5.0.45, 5.0, 5.1, 6.0 BK
]]> Thu, 07 Feb 2008 17:40:47 +0000 Server: Types http://bugs.mysql.com/34776 #34776: Assertion failed:scale >=0 && precision>0&& scale<=precisiondecimal.c line 1462 http://bugs.mysql.com/bug.php?id=34776 Submitted by: Shane Bester
Category: Server: Types
Status: Can't repeat
Severity: 2
OS: Any
Version: 5.0.62-debug, 5.0.66a-debug,5.1.23-debug
]]> Sat, 23 Feb 2008 11:47:00 +0000 Server: Types http://bugs.mysql.com/35288 #35288: SEC_TO_TIME Does'nt return large hour format http://bugs.mysql.com/bug.php?id=35288 Submitted by: Alexander Wahl
Category: Server: Types
Status: Can't repeat
Severity: 2
OS: Linux (Debian 2.6.18-6-686)
Version: 5.0.32-Debian_7etch5-log
]]> Fri, 14 Mar 2008 11:47:00 +0000 Server: Types http://bugs.mysql.com/36615 #36615: Floating point number incorrectly stored in 64 bit integer if it has 20+ digits http://bugs.mysql.com/bug.php?id=36615 Submitted by: Stephan Austermühle
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: HP/UX (11iV1 64bit)
Version: 5.0.51b
]]> Fri, 09 May 2008 07:27:06 +0000 Server: Types http://bugs.mysql.com/38219 #38219: Database Related Issue http://bugs.mysql.com/bug.php?id=38219 Submitted by: Jayant Patil
Category: Server: Types
Status: Can't repeat
Severity: 1
OS: Linux
Version: 4.1.22
]]> Fri, 18 Jul 2008 06:24:05 +0000 Server: Types http://bugs.mysql.com/38915 #38915: LIKE query on DATETIME raises warning http://bugs.mysql.com/bug.php?id=38915 Submitted by: Martin Kanerva
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Linux
Version: 5.0.45, 5.0.67, 5.1.26
]]> Wed, 20 Aug 2008 13:30:55 +0000 Server: Types http://bugs.mysql.com/45004 #45004: Date Value http://bugs.mysql.com/bug.php?id=45004 Submitted by: Fiala Vjero
Category: Server: Types
Status: Can't repeat
Severity: 2
OS: Any
Version: 5.0.81, 5.0.83-bzr
]]> Thu, 21 May 2009 08:46:43 +0000 Server: Types http://bugs.mysql.com/47089 #47089: DATETIME comparison in CASE statement with fractional seconds fails http://bugs.mysql.com/bug.php?id=47089 Submitted by: Vladimir Strugatsky
Category: Server: Types
Status: Can't repeat
Severity: 2
OS: Any
Version: 5.0.45
]]> Thu, 03 Sep 2009 09:44:07 +0000 Server: Types http://bugs.mysql.com/50231 #50231: Select shows different outputs for 'bigint' column containing 'null' values http://bugs.mysql.com/bug.php?id=50231 Submitted by: Nirbhay Choubey
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.1-bugteam
]]> Mon, 11 Jan 2010 13:10:27 +0000 Server: Types http://bugs.mysql.com/57298 #57298: ENUMs do not obey strict sql_mode and empty string can insert when not specified http://bugs.mysql.com/bug.php?id=57298 Submitted by: Peter Laursen
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.1.51
]]> Thu, 07 Oct 2010 08:23:47 +0000 Server: Types http://bugs.mysql.com/58065 #58065: join condition handles date columns differently if there's a unique key http://bugs.mysql.com/bug.php?id=58065 Submitted by: Balint Toth
Category: Server: Types
Status: Can't repeat
Severity: 2
OS: Linux (x64, 2.6.32)
Version: 5.1.51, 5.1.52, 5.0, 5.1, 5.6.99 bzr
]]> Mon, 08 Nov 2010 21:31:16 +0000 Server: Types http://bugs.mysql.com/60274 #60274: Won't take phone numbers http://bugs.mysql.com/bug.php?id=60274 Submitted by: Joshua Lombardi
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Any
]]> Mon, 28 Feb 2011 00:00:54 +0000 Server: Types http://bugs.mysql.com/60990 #60990: incorrect date comparison http://bugs.mysql.com/bug.php?id=60990 Submitted by: Sergey L
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.5, 5.1.56
]]> Thu, 28 Apr 2011 10:48:32 +0000 Server: Types http://bugs.mysql.com/61193 #61193: incorrect rounding of date DECIMAL(17,3) http://bugs.mysql.com/bug.php?id=61193 Submitted by: leo strashnoy
Category: Server: Types
Status: Can't repeat
Severity: 3
OS: Any
Version: 5.1.58, 5.5
]]> Mon, 16 May 2011 22:49:55 +0000 Server: Types