diff options
Diffstat (limited to 'mysql-test/t/timezone2.test')
| -rw-r--r-- | mysql-test/t/timezone2.test | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/t/timezone2.test b/mysql-test/t/timezone2.test index 7a38610ad95..da97ac472f1 100644 --- a/mysql-test/t/timezone2.test +++ b/mysql-test/t/timezone2.test @@ -111,21 +111,21 @@ drop table t1; # create table t1 (ts timestamp); set time_zone='UTC'; -insert into t1 values ('0000-00-00 00:00:00'),('1969-12-31 23:59:59'), +insert ignore into t1 values ('0000-00-00 00:00:00'),('1969-12-31 23:59:59'), ('1970-01-01 00:00:00'),('1970-01-01 00:00:01'), ('2038-01-19 03:14:07'),('2038-01-19 03:14:08'); select * from t1; truncate table t1; # MET time zone has range shifted by one hour set time_zone='MET'; -insert into t1 values ('0000-00-00 00:00:00'),('1970-01-01 00:30:00'), +insert ignore into t1 values ('0000-00-00 00:00:00'),('1970-01-01 00:30:00'), ('1970-01-01 01:00:00'),('1970-01-01 01:00:01'), ('2038-01-19 04:14:07'),('2038-01-19 04:14:08'); select * from t1; truncate table t1; # same for +01:30 time zone set time_zone='+01:30'; -insert into t1 values ('0000-00-00 00:00:00'),('1970-01-01 01:00:00'), +insert ignore into t1 values ('0000-00-00 00:00:00'),('1970-01-01 01:00:00'), ('1970-01-01 01:30:00'),('1970-01-01 01:30:01'), ('2038-01-19 04:44:07'),('2038-01-19 04:44:08'); select * from t1; |