>Description:
CURDATE() in string-context gives wrong year.
>How-To-Repeat:
SELECT SYSDATE(); => 1999-03-19 14:37:58 => OK
SELECT CURDATE()+0; => 19990319 => OK
SELECT CURDATE(); => 6703-03-19 => WRONG
>Originator: Horst-W. Radners
>Organization:
IWiS GmbH, Markgrafenstr. 11, D-10969 Berlin
Tel.: +49 30 253769-12, Fax.: -77, e-mail: h.radners@stripped
>MySQL support: none
>Synopsis: CURDATE() in string-context gives wrong year.
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.22.20a (Source distribution)
>Environment:
System: IRIX 6.2 IP22
Some paths: /bin/perl /bin/make /usr/local/bin/gcc /bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/mips-sgi-irix6.2/2.8.0/specs
gcc version 2.8.0
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='-O3' LDFLAGS=''
Configure command: ./configure --prefix=/usr/local/mysql
Perl: This is perl, version 5.004_03
Hi, folks!
After upgrading from mysql-3.21 CURDATE() gives a wrong yearnumber when
evaluated in string-context.
Any idea what's going wrong here?!
Thanx
___________________________________________________________________________
Horst-W. Radners
IWiS GmbH, Markgrafenstr. 11, D-10969 Berlin
Tel.: +49 30 253769-12, Fax.: -77, e-mail: h.radners@stripped
PGPkeyID 0CBD1549(RSA), 1401C833(DSS)
