← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/r/events_scheduling.result

  • Committer: Bazaar Package Importer
  • Author(s): Chuck Short
  • Date: 2010-06-21 15:31:05 UTC
  • mfrom: (1.1.3 upstream)
  • mto: This revision was merged to the branch mainline in revision 6.
  • Revision ID: james.westby@ubuntu.com-20100621153105-pbbz3t6nyrf9t2zq
Tags: upstream-5.1.48
Import upstream version 5.1.48

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/events_scheduling.result
82
82
DROP TABLE table_2;
83
83
DROP TABLE table_3;
84
84
DROP TABLE table_4;
 
85
 
 
86
Bug #50087 Interval arithmetic for Event_queue_element is not portable.
 
87
 
 
88
CREATE TABLE t1(a int);
 
89
CREATE EVENT e1 ON SCHEDULE EVERY 1 MONTH
 
90
STARTS NOW() - INTERVAL 1 MONTH
 
91
ENDS NOW() + INTERVAL 2 MONTH
 
92
ON COMPLETION PRESERVE
 
93
DO
 
94
INSERT INTO t1 VALUES (1);
 
95
CREATE EVENT e2 ON SCHEDULE EVERY 1 MONTH
 
96
STARTS NOW()
 
97
ENDS NOW() + INTERVAL 11 MONTH
 
98
ON COMPLETION PRESERVE
 
99
DO
 
100
INSERT INTO t1 VALUES (1);
 
101
DROP TABLE t1;
 
102
DROP EVENT e1;
 
103
DROP EVENT e2;
85
104
DROP DATABASE events_test;
86
105
SET GLOBAL event_scheduler=@event_scheduler;