diff options
| author | monty@narttu.mysql.fi <> | 2003-05-27 16:40:14 +0300 |
|---|---|---|
| committer | monty@narttu.mysql.fi <> | 2003-05-27 16:40:14 +0300 |
| commit | 381492093e6ec8d8afc0432347a890cdf452bf50 (patch) | |
| tree | 3dbb25b0c8865f6a219078ba4e0aa4d829addb42 /mysql-test/t/timezone.test | |
| parent | 553637cbc48e0126997a44ab34463d8deabb1f1c (diff) | |
| download | mariadb-git-381492093e6ec8d8afc0432347a890cdf452bf50.tar.gz | |
Fixed problem with mysql prompt when server disconnect. (Bug 356)
Fixed problem with localtime -> gmt where some times resulted in
different (but correct) timestamps. Now MySQL should use the smallest
possible timestamp value in this case. (Bug 316)
Diffstat (limited to 'mysql-test/t/timezone.test')
| -rw-r--r-- | mysql-test/t/timezone.test | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/t/timezone.test b/mysql-test/t/timezone.test new file mode 100644 index 00000000000..14facc0374a --- /dev/null +++ b/mysql-test/t/timezone.test @@ -0,0 +1,28 @@ +# +# Test of timezone handling. This script must be run with TZ=MEST + +-- require r/have_mest_timezone.require +disable_query_log; +show variables like "timezone"; +enable_query_log; + +# Initialization +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings + + +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; |