diff options
| author | jimw@mysql.com <> | 2005-07-18 16:12:44 -0700 |
|---|---|---|
| committer | jimw@mysql.com <> | 2005-07-18 16:12:44 -0700 |
| commit | dd2f631ec45b955af458f8a3b1f9d7d7d0a4fa73 (patch) | |
| tree | 84495874ff2aa17253ec5fef315c2538a1c75871 /mysql-test/t/timezone2.test | |
| parent | a25c4ead106bf36d0c9a5f18f9477bf238bcc05d (diff) | |
| download | mariadb-git-dd2f631ec45b955af458f8a3b1f9d7d7d0a4fa73.tar.gz | |
Fix number to date conversion so it always honors the NO_ZERO_DATE,
NO_ZERO_IN_DATE, and INVALID_DATES bits of SQL_MODE. (Bug #5906)
Diffstat (limited to 'mysql-test/t/timezone2.test')
| -rw-r--r-- | mysql-test/t/timezone2.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/timezone2.test b/mysql-test/t/timezone2.test index 0b5aaed5d30..40fcd153877 100644 --- a/mysql-test/t/timezone2.test +++ b/mysql-test/t/timezone2.test @@ -48,6 +48,11 @@ insert into t1 (i, ts) values (unix_timestamp('2003-03-30 01:59:59'),'2003-03-30 01:59:59'), (unix_timestamp('2003-03-30 02:30:00'),'2003-03-30 02:30:00'), (unix_timestamp('2003-03-30 03:00:00'),'2003-03-30 03:00:00'); +# Values around and in spring time-gap +insert into t1 (i, ts) values + (unix_timestamp(20030330015959),20030330015959), + (unix_timestamp(20030330023000),20030330023000), + (unix_timestamp(20030330030000),20030330030000); # Normal value with DST insert into t1 (i, ts) values (unix_timestamp('2003-05-01 00:00:00'),'2003-05-01 00:00:00'); |