View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007333 | VALENTINA SERVER | Event Shceduler | public | 2015-11-15 10:56 | 2019-06-12 07:22 |
| Reporter | Sergey Pashkov | Assigned To | Ivan Smahin | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | assigned | Resolution | open | ||
| Product Version | 6.1 | ||||
| Target Version | 12.3.x | ||||
| Summary | 0007333: CREATE EVENT and SHOW EVENTS use different TIMESTAMP format | ||||
| Description | 1) 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". | ||||
| Tags | No tags attached. | ||||
| 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 |
