Bug #10108 | Server crashes using Select from view with sec_to_time function | ||
---|---|---|---|
Submitted: | 23 Apr 2005 3:10 | Modified: | 23 Apr 2005 3:24 |
Reporter: | Jochen Wartenberg | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.3-beta-standard | OS: | Linux (SuSE Linux 9.2) |
Assigned to: | CPU Architecture: | Any |
[23 Apr 2005 3:10]
Jochen Wartenberg
[23 Apr 2005 3:24]
Jorge del Conde
I was unable to reproduce this bug w/5.0.5 from bk: mysql> create table po_jogging(datum date, exe_time time); Query OK, 0 rows affected (0.00 sec) mysql> create view test06 as select year(datum), month(datum), sec_to_time(sum((exe_time))), exe_time -> FROM `po_jogging` -> group by year(datum), month(datum); Query OK, 0 rows affected (0.01 sec) mysql> select * from test06; Empty set (0.00 sec) mysql> insert into po_jogging values(now(), now()); Query OK, 1 row affected (0.01 sec) mysql> select * from test06; +-------------+--------------+------------------------------+----------+ | year(datum) | month(datum) | sec_to_time(sum((exe_time))) | exe_time | +-------------+--------------+------------------------------+----------+ | 2005 | 4 | 62:33:58 | 22:52:38 | +-------------+--------------+------------------------------+----------+ 1 row in set (0.00 sec) mysql>
[23 Apr 2005 6:04]
Jochen Wartenberg
I just have installed 5.0.4. The bug does no longer appear. Thanks Jochen