>Description:
Linux Alpha build. NOW() returns correct date, year 2053.
>How-To-Repeat:
rimmer:~ # mysql ufn;
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 69 to server version: 3.23.37-Max-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> select NOW();
+---------------------+
| NOW() |
+---------------------+
| 2053-05-11 17:27:40 |
+---------------------+
1 row in set (0.00 sec)
mysql>
>Fix:
>Submitter-Id: [EMAIL PROTECTED]
>Originator: root
>Organization: UserFriendly Media, Inc.
>MySQL support: none
>Synopsis: DATE for NOW() is incorrect for 64 bit compile. Breaks TIMESTAMP fields
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.37 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.19 Distrib 3.23.37, for unknown-linux-gnu on
>alphaev56
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.37-Max-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 6 hours 58 min 43 sec
Threads: 16 Questions: 106724 Slow queries: 0 Opens: 22 Flush tables: 1 Open
tables: 16 Queries per second avg: 4.248
>Environment:
System: Linux rimmer 2.2.19 #1 SMP Thu May 10 16:10:11 PDT 2001 alpha unknown
Architecture: alpha
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/alpha-suse-linux/2.96/specs
gcc version 2.96 20000731 (SuSE Linux/Alpha)
Compilation info: CC='gcc' CFLAGS=' -O3' CXX='c++' CXXFLAGS=' -O3
-felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 2469003 Feb 28 2001 /lib/libc.so.6.1
-rw-r--r-- 1 root root 6499024 Feb 28 2001 /usr/lib/libc.a
-rw-r--r-- 1 root root 180 Feb 28 2001 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --without-berkeley-db --without-innodb
--enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man
'--with-comment=Official MySQL RPM'
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
