Showing all 10 (Edit, Save, CSV, Feed)
ID# Date Updated Type Status Sev Version OS CPU Summary
356622008-03-28
22:44
2008-03-31
17:41
MySQL Server: Data TypesClosed
(5841 days)
S25.0Windows (XP 32bit (tested))Any5.0 coalesce returns varbinary for dates on Windows
392832008-09-05
20:41
2008-11-10
19:09
MySQL ServerClosed
(5617 days)
S25.0.67-community, 4.1, 5.0, 5.1, 6.0 bzrLinux (CentOS 5.2)AnyDate returned as VARBINARY to client for queries with COALESCE and JOIN
601012011-02-10
19:12
2013-05-15
16:29
MySQL Server: CharsetsClosed
(3970 days)
S25.5.8, 5.5.9AnyAnyCOALESCE with cp1251 tables causes [Err] 1267 - Illegal mix of collations
315572007-10-12
8:43
2007-11-15
11:44
MySQL Server: GeneralNo Feedback
(5978 days)
S34.0.21Linux (COALESCE bug)AnyCOALESCE sometimes returns zero yet first non-null is a string
394542008-09-15
13:07
2011-02-16
23:43
MySQL Server: GeneralCan't repeat
(4928 days)
S35.0.51a-commmunity-ntWindows (XP)AnyCOALESCE with Longtext field only returns the first line
515982010-03-01
9:09
2011-02-16
23:44
MySQL Server: DMLClosed
(5032 days)
S35.0.91, 5.1.37, 5.1.45AnyAnyInconsistent behaviour with a COALESCE statement inside an IN comparison
603242011-03-03
21:01
2011-03-04
7:23
MySQL Server: GeneralVerified
(4773 days)
S35.1.55, 5.1.57AnyAnyCOALESCE makes a partial date not match a full date
657632012-06-28
15:16
2018-02-12
22:20
MySQL Server: DMLNot a Bug
(2236 days)
S35.1.64, 5.5AnyAnyCOALESCE(), UNION truncates padding on zero-filled values
1011752020-10-14
18:12
2021-02-17
11:11
MySQL Server: DMLClosed
(1135 days)
S38.0.21Ubuntu (Ver 8.0.21-0ubuntu0.20.04.4)AnyCOALESCE and IFNULL do not work as expected in WITH ROLLUP queries
234982006-10-20
12:46
2006-11-25
7:13
MySQL ServerNot a Bug
(6333 days)
S55.0.26Windows (Windows XP)Anycall to coalesce is not nedded in join statements
Showing all 10 (Edit, Save, CSV, Feed)