diff options
Diffstat (limited to 'mysql-test/t/timezone.test')
-rw-r--r-- | mysql-test/t/timezone.test | 65 |
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 |