← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/engines/funcs/t/in_multicolumn_calendar_unique_constraint_error.test
1
1
--disable_warnings
2
2
DROP TABLE IF EXISTS t1;
3
3
--enable_warnings
 
4
# Set Correct timezone to match result
 
5
SET TIME_ZONE="+03:00";
4
6
CREATE TABLE t1(c1 DATE NULL, c2 DATE NULL, c3 DATE NULL, UNIQUE(c1,c2,c3));
5
7
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
6
8
INSERT INTO t1 (c1,c2,c3) VALUES(NOW(),NOW(),NOW());
93
95
INSERT INTO t1 (c1,c2,c3) VALUES(1999,1999,2000);
94
96
SELECT * FROM t1;
95
97
DROP TABLE t1;
96
 
 
 
98
# Restore timezone to default
 
99
SET TIME_ZONE= @@global.time_zone;