← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-201203300109

« back to all changes in this revision

Viewing changes to mysql-test/suite/engines/funcs/t/de_calendar_range.test

  • Committer: Clint Byrum
  • Date: 2012-02-15 01:24:19 UTC
  • mto: This revision was merged to the branch mainline in revision 10.
  • Revision ID: clint@ubuntu.com-20120215012419-upaezkp5ynk787ki
Import upstream version 5.5.20

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/engines/funcs/t/de_calendar_range.test
1
1
--disable_warnings
2
2
DROP TABLE IF EXISTS t1,t2,t3;
3
3
--enable_warnings
 
4
# Set Correct timezone to match result
 
5
SET TIME_ZONE="+03:00";
4
6
CREATE TABLE t1(c1 DATE NOT NULL PRIMARY KEY);
5
7
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
6
8
INSERT INTO t1 (c1) VALUES(NOW());
45
47
DELETE FROM t1 WHERE c1 <= ADDTIME(NOW(),'2 02:01:01');
46
48
SELECT * FROM t1 ORDER BY c1;
47
49
DROP TABLE t1;
48
 
 
 
50
# Restore timezone to default
 
51
SET TIME_ZONE= @@global.time_zone;