Well,
This email also broke KDE Mail (note the date in the quotation).
This would be my first UT (Unix timestamp) glitch. Congratulations!!
You're about 20 years ahead of what I expected :O)
GB
On Wednesday 31 December 1969 04:00 pm, I thought root said:
> >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
---------------------------------------------------------------------
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
