1#
2# Test of SYSTEM time zone handling ( for my_system_gmt_sec()).
3# This script must be run with TZ=MET
4
5-- require include/have_met_timezone.require
6disable_query_log;
7select FROM_UNIXTIME(24*3600);
8enable_query_log;
9
10# Initialization
11--disable_warnings
12DROP TABLE IF EXISTS t1;
13--enable_warnings
14
15# The following is because of daylight saving time
16--replace_result MEST MET
17show variables like "system_time_zone";
18
19#
20# Test unix timestamp
21#
22select @a:=FROM_UNIXTIME(1);
23select unix_timestamp(@a);
24
25#
26# Test of some values, including some with daylight saving time
27#
28
29CREATE TABLE t1 (ts int);
30INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 01:00'));
31INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00'));
32INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 03:00'));
33INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00'));
34INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 01:00'));
35INSERT INTO t1 (ts) VALUES (Unix_timestamp('2002-10-27 02:00'));
36INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 02:59:59'));
37INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 03:00:00'));
38INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 03:59:59'));
39INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 04:00:01'));
40
41SELECT ts,from_unixtime(ts) FROM t1;
42DROP TABLE t1;
43
44
45#
46# Test of warning for spring time-gap values for system time zone
47#
48CREATE TABLE t1 (ts timestamp);
49INSERT INTO t1 (ts) VALUES ('2003-03-30 01:59:59'),
50                           ('2003-03-30 02:59:59'),
51                           ('2003-03-30 03:00:00');
52DROP TABLE t1;
53
54#
55# Test for fix for Bug#2523 Check that boundary dates are processed
56# correctly.
57#
58select unix_timestamp('1970-01-01 01:00:00'),
59       unix_timestamp('1970-01-01 01:00:01'),
60       unix_timestamp('2038-01-19 04:14:07'),
61       unix_timestamp('2038-01-19 04:14:08');
62
63select unix_timestamp('1969-12-31 23:59:59'), unix_timestamp('1970-01-01 00:00:00'), unix_timestamp('1970-01-01 00:59:59');
64
65# End of 4.1 tests
66