Bug #9436 timestamp-related server crash on 64-bit platforms
Submitted: 28 Mar 2005 19:48 Modified: 28 Mar 2005 20:13
Reporter: Jim Winstead Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.11-bk OS:Linux (Linux)
Assigned to: Assigned Account CPU Architecture:Any

[28 Mar 2005 19:48] Jim Winstead
On 64-bit platforms, the func_date_add and type_timestamp test fail when doing max(timestamp_column) with a group by. See simple test case in 'How to repeat' section.

How to repeat:
create table t1 (a char(2), t timestamp);
insert into t1 values ('a', '2004-01-01 00:00:00'),
                             ('a', '2004-01-01 01:00:00');
select max(t) from t1 group by a;
drop table t1;
[28 Mar 2005 20:13] Jim Winstead
This is a duplicate of Bug #9401.