summaryrefslogtreecommitdiff
path: root/mysql-test/t/timezone.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/timezone.test')
-rw-r--r--mysql-test/t/timezone.test65
1 files changed, 0 insertions, 65 deletions
diff --git a/mysql-test/t/timezone.test b/mysql-test/t/timezone.test
deleted file mode 100644
index a41e806a40e..00000000000
--- a/mysql-test/t/timezone.test
+++ /dev/null
@@ -1,65 +0,0 @@
-#
-# Test of SYSTEM time zone handling ( for my_system_gmt_sec()).
-# This script must be run with TZ=MET
-
--- require r/have_met_timezone.require
-disable_query_log;
-select FROM_UNIXTIME(24*3600);
-enable_query_log;
-
-# Initialization
---disable_warnings
-DROP TABLE IF EXISTS t1;
---enable_warnings
-
-# The following is because of daylight saving time
---replace_result MEST MET
-show variables like "system_time_zone";
-
-#
-# Test unix timestamp
-#
-select @a:=FROM_UNIXTIME(1);
-select unix_timestamp(@a);
-
-#
-# Test of some values, including some with daylight saving time
-#
-
-CREATE TABLE t1 (ts int);
-INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 01:00'));
-INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00'));
-INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 03:00'));
-INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00'));
-INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 01:00'));
-INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00'));
-INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 02:59:59'));
-INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 03:00:00'));
-INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 03:59:59'));
-INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 04:00:01'));
-
-SELECT ts,from_unixtime(ts) FROM t1;
-DROP TABLE t1;
-
-
-#
-# Test of warning for spring time-gap values for system time zone
-#
-CREATE TABLE t1 (ts timestamp);
-INSERT INTO t1 (ts) VALUES ('2003-03-30 01:59:59'),
- ('2003-03-30 02:59:59'),
- ('2003-03-30 03:00:00');
-DROP TABLE t1;
-
-#
-# Test for fix for Bug#2523 Check that boundary dates are processed
-# correctly.
-#
-select unix_timestamp('1970-01-01 01:00:00'),
- unix_timestamp('1970-01-01 01:00:01'),
- unix_timestamp('2038-01-19 04:14:07'),
- unix_timestamp('2038-01-19 04:14:08');
-
-select unix_timestamp('1969-12-31 23:59:59'), unix_timestamp('1970-01-01 00:00:00'), unix_timestamp('1970-01-01 00:59:59');
-
-# End of 4.1 tests