summaryrefslogtreecommitdiff
path: root/mysql-test/t/timezone.test
diff options
context:
space:
mode:
authormonty@mysql.com <>2003-12-12 22:26:58 +0200
committermonty@mysql.com <>2003-12-12 22:26:58 +0200
commitf995a5f4aa919d6d229d29fb652a263d8c816430 (patch)
tree771f288d33d415cb8e3d292f33e46fdb512d9dff /mysql-test/t/timezone.test
parentfddab846d4f3658b3488cbec43c7d16f07f14594 (diff)
downloadmariadb-git-f995a5f4aa919d6d229d29fb652a263d8c816430.tar.gz
Fix autoincrement for signed columns (Bug #1366)
Fixed problem with char > 128 in QUOTE() function. (Bug #1868) Disable creation of symlinks if my_disable_symlink is set Fixed searching of TEXT with end space. (Bug #1651) Fixed caching bug in multi-table-update where same table was used twice. (Bug #1711) Fixed problem with UNIX_TIMESTAMP() for timestamps close to 0. (Bug #1998) Fixed timestamp.test
Diffstat (limited to 'mysql-test/t/timezone.test')
-rw-r--r--mysql-test/t/timezone.test10
1 files changed, 8 insertions, 2 deletions
diff --git a/mysql-test/t/timezone.test b/mysql-test/t/timezone.test
index 14facc0374a..d9603c51766 100644
--- a/mysql-test/t/timezone.test
+++ b/mysql-test/t/timezone.test
@@ -1,7 +1,7 @@
#
-# Test of timezone handling. This script must be run with TZ=MEST
+# Test of timezone handling. This script must be run with TZ=MET
--- require r/have_mest_timezone.require
+-- require r/have_met_timezone.require
disable_query_log;
show variables like "timezone";
enable_query_log;
@@ -26,3 +26,9 @@ INSERT INTO t1 (ts) VALUES (Unix_timestamp('2003-03-30 04:00:01'));
SELECT ts,from_unixtime(ts) FROM t1;
DROP TABLE t1;
+
+#
+# Test unix timestamp
+#
+select @a:=FROM_UNIXTIME(1);
+select unix_timestamp(@a);