diff options
author | unknown <andrey@lmy004.> | 2006-02-28 11:43:10 +0100 |
---|---|---|
committer | unknown <andrey@lmy004.> | 2006-02-28 11:43:10 +0100 |
commit | 317c6851ba4acc75550f03e765de3a0eb1837ed0 (patch) | |
tree | 4e074ceb8afe49ab1398b1165020e45301d4282d /mysql-test/r/delete.result | |
parent | b9d41f5d1b05ee5c7b12a53e49a09b150ad45de6 (diff) | |
download | mariadb-git-317c6851ba4acc75550f03e765de3a0eb1837ed0.tar.gz |
fix for bug#16537 (Events: mysql.event.starts is null)
- now when the event is created and STARTS is omitted then STARTS is implicitly
CURRENT_TIMESTAMP
- This CS also fixed incorrect presentation of STARTS/ENDS in I_S.EVENTS
(incorporated review changes)
mysql-test/r/events.result:
results of new test cases
mysql-test/t/events.test:
new test cases for bug #16537 (Events: mysql.event.starts is null)
sql/event.cc:
- check whether event_timed::starts_null only in case
event_timed::expression is set, so for recurring events only
- disable binlogging of CREATE EVENT statement. It should not be
replicated but the result of the execution. Still the replication is
untouched topic.
sql/event.h:
- add flags whether starts, ends and execute_at are null or not
sql/event_executor.cc:
- check whether xxx_null instead of !xxxx.year
sql/event_timed.cc:
- introduce xxx_null and change the usage of xxx.year to !xxx_null
sql/sql_show.cc:
- don't show 0000-00-00 in I_S.EVENTS when the value is NULL
sql/sql_yacc.yy:
- if STARTS is omitted default to current_timestamp
Diffstat (limited to 'mysql-test/r/delete.result')
0 files changed, 0 insertions, 0 deletions