summaryrefslogtreecommitdiff
path: root/mysql-test/std_data
diff options
context:
space:
mode:
authorGeorgi Kodinov <kgeorge@mysql.com>2008-12-01 16:18:35 +0200
committerGeorgi Kodinov <kgeorge@mysql.com>2008-12-01 16:18:35 +0200
commit8f36a23c0012d0ac6c369b858d232f26322e2693 (patch)
tree93de2370363802838016898bcf9c0c2941dfb252 /mysql-test/std_data
parentb82094a0f801cd90b1954322c5e33915b362af22 (diff)
downloadmariadb-git-8f36a23c0012d0ac6c369b858d232f26322e2693.tar.gz
Bug #39920: MySQL cannot deal with Leap Second expression in string literal.
Updated MySQL time handling code to react correctly on UTC leap second additions. MySQL functions that return the OS current time, like e.g. CURDATE(), NOW() etc will return :59:59 instead of :59:60 or 59:61. As a result the reader will receive :59:59 for 2 or 3 consecutive seconds during the leap second. This fix will not affect the values returned by UNIX_TIMESTAMP() for leap seconds. But note that when converting the value returned by UNIX_TIMESTAMP() to broken down time the correction of leap seconds will still be applied. Note that this fix will make a difference *only* if the OS is specially configured to return leap seconds from the OS time calls or when using a MySQL time zone defintion that has leap seconds. Even after this change date/time literals (or other broken down time representations) with leap seconds (ending on :59:60 or 59:61) will still be considered illegal and discarded by the server with an error or a warning depending on the sql mode. Added a test case to demonstrate the effect of the fix.
Diffstat (limited to 'mysql-test/std_data')
-rw-r--r--mysql-test/std_data/Moscow_leapbin991 -> 2674 bytes
1 files changed, 0 insertions, 0 deletions
diff --git a/mysql-test/std_data/Moscow_leap b/mysql-test/std_data/Moscow_leap
index 4994c005595..3e73923cfb3 100644
--- a/mysql-test/std_data/Moscow_leap
+++ b/mysql-test/std_data/Moscow_leap
Binary files differ