← 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_calendar_pk_constraint_duplicate_update.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_calendar_pk_constraint_duplicate_update.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 NOT NULL PRIMARY KEY);
5
7
SET TIMESTAMP=1171346973; # 2007-02-13 15:09:33
6
8
INSERT INTO t1 (c1) VALUES(NOW());
61
63
--sorted_result
62
64
SELECT * FROM t1;
63
65
DROP TABLE t1;
64
 
 
 
66
# Restore timezone to default
 
67
SET TIME_ZONE= @@global.time_zone;