List:General Discussion« Previous MessageNext Message »
From:Len Rose Date:November 15 1999 12:59pm
Subject:RE: Bug in unix_timestamp()
View as plain text  
-----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-----
Thread
Bug in unix_timestamp()pandr15 Nov
  • RE: Bug in unix_timestamp()Len Rose15 Nov
    • RE: Bug in unix_timestamp()Bob Kline15 Nov
      • Re: Bug in unix_timestamp()Gisle Aas15 Nov
        • Re: Bug in unix_timestamp()sinisa15 Nov
        • Re: Bug in unix_timestamp()Vivek Khera15 Nov
  • Re: Bug in unix_timestamp()Jay J15 Nov
  • Re: Bug in unix_timestamp()Jacob Joseph17 Nov
  • Re: Bug in unix_timestamp()Jacob Joseph17 Nov
Re: Bug in unix_timestamp()Gisle Aas15 Nov
  • Re: Bug in unix_timestamp()sinisa16 Nov
    • Re: Bug in unix_timestamp()Peter Andreasen16 Nov