View Issue Details

IDProjectCategoryView StatusLast Update
0007333VALENTINA SERVEREvent Shcedulerpublic2019-06-12 07:22
ReporterSergey Pashkov Assigned ToIvan Smahin  
PrioritynormalSeverityminorReproducibilityalways
Status assignedResolutionopen 
Product Version6.1 
Target Version12.5.x 
Summary0007333: CREATE EVENT and SHOW EVENTS use different TIMESTAMP format
Description1) Create event, "master" database has "/" as a date separator:

USE master;
CREATE EVENT "event1"
    FOR DATABASE "valentina_sakila"
    ON SCHEDULE AT TIMESTAMP '12/12/2016 12:26:31'
    ON COMPLETION NOT PRESERVE
    DISABLED
    DO SELECT 1;

2) Change separator of "valentina_sakila":
SET PROPERTY "DateSeparator" OF DATABASE TO '*';

3) Show events:
USE master;
show EVENTS FROM "valentina_sakila"

fld_execute_at = "2016*12*12 12:26:31:000"

Should be single format - either "master" or "valentina_sakila".

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2015-11-15 10:56 Sergey Pashkov New Issue
2019-06-11 11:39 Ruslan Zasukhin Assigned To => Ivan Smahin
2019-06-11 11:39 Ruslan Zasukhin Status new => assigned