Bug #18887 Events: timestamp with fractional seconds is accepted
Submitted: 7 Apr 2006 14:35 Modified: 7 Apr 2006 14:46
Reporter: Peter Gulutzan Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S3 (Non-critical)
Version:5.1.9-beta-debug OS:Linux (SUSE 10.0)
Assigned to: MySQL Verification Team CPU Architecture:Any

[7 Apr 2006 14:35] Peter Gulutzan
Description:
If I enter a timestamp with fractional seconds,
e.g. '2007-04-04 23:59:59.5', I expect the '.5'
to be either truncated or rounded. That's what
happens if I assign to a TIMESTAMP column.
But if I use such a value for CREATE EVENT,
it's translated to nonsense like
'2007-04-05 05:59:59'.

How to repeat:
mysql> create event ttg on schedule at timestamp '2007-04-04 23:59:59.5' do set @a=5;
Query OK, 1 row affected (0.00 sec)

mysql> show create event ttg\G
*************************** 1. row ***************************
       Event: ttg
    sql_mode:
Create Event: CREATE EVENT `ttg` ON SCHEDULE AT '2007-04-05 05:59:59' ON COMPLETION NOT PRESERVE ENABLE DO set @a=5
1 row in set (0.00 sec)
[7 Apr 2006 14:45] MySQL Verification Team
Thank you for the bug report.
[7 Apr 2006 14:46] Peter Gulutzan
Oops.This is merely a duplicate of the UTC bug. Sorry.