-----BEGIN PGP SIGNED MESSAGE-----
I don't see that behavior on Solaris 2.6 and 3.22.20a
Len
On 15-Nov-99 pandr@stripped wrote:
>>Description:
>
> The unix_timestamp is not well-defined, i.e. it may return different
> values for same argument.
>
>>How-To-Repeat:
>
> select unix_timestamp('1999-10-31 01:59:59');
> select unix_timestamp('1999-10-31 02:00:00');
> select unix_timestamp('1999-10-31 03:00:00');
> select unix_timestamp('1999-10-31 02:00:00');
>
> yields
>
> 941327999
> 941328000
> 941335200
> 941331600 !!!!!
>
> Note, this is of course only a problem because of the daylight-saving.
>
>>Fix:
>
> The problem is hard to work around because even if the third
> SELECT statement above is carried out in a different thread (connection),
> the problem persists. In other words, another thread can influence on
> how unix_timestamp() works.
>
> The problem might be completely platform related -- I am not sure if
> MySQL uses its own conversion or one from a lib.
>
> Perl's Time::Local module does not have this problem.
>
>>Submitter-Id: <submitter ID>
>>Originator:
>>Organization:
>>MySQL support: none
>>Synopsis: unix_timestamp() not well-defined. daylight-saving.
>>Severity: serious
>>Priority:
>>Category: mysql
>>Class:
>>Release: mysql-3.23.4-alpha (Source distribution)
>
>>Environment:
>
> System: Linux pandr.dk 2.0.36 #1 Tue Oct 13 22:17:11 EDT 1998 i586 unknown
> Architecture: i586
>
> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
> /usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.7.2.3/specs
> gcc version 2.7.2.3
> Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
> LIBC:
> lrwxrwxrwx 1 root root 13 Nov 4 1998 /lib/libc.so.6 ->
> libc-2.0.7.so
> -rwxr-xr-x 1 root root 3070220 Oct 13 1998 /lib/libc-2.0.7.so
> -rw-r--r-- 1 root root 7603158 Oct 13 1998 /usr/lib/libc.a
> -rw-r--r-- 1 root root 178 Oct 13 1998 /usr/lib/libc.so
> Configure command: ./configure
> Perl: This is perl, version 5.004_04 built for i386-linux
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread18693@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
len@stripped
http://www.netsys.com
-----BEGIN PGP SIGNATURE-----
Version: 2.6.1
iQCVAwUBODADlYef0OvUNu5PAQHPoAP7BLr9FOgklvyfJm2S9AZAYttKeFbxEsfQ
NemLQr+PS/IRHMutgS7LVwLzJ3MO9awwNSYwHsKsW9pOpYUQAkgZThhT1OyQi5IU
/mfEwfcHn39hLItTeToO6PUQhLiYrAORbV8wp7V4lb1gZpudtBoLLevmpwxfjifI
gnpBuJ+DjVI=
=v4Ql
-----END PGP SIGNATURE-----
