i just got done compiling and testing 3.23.25-beta on
my alpha. unfortunately 

select now(); results in the same messed up future
date.


--- Ralph Graulich <graulich@shauny.de> wrote:
> Here are the two postings about the date bug in
> mySQL and alpha caused by
> GNU compilers and the stating of one of the mySQL's
> developers. They
> recommend using at least a 3.23.x version - 3.23.25
> is the newest at the
> moment.
> 
> Hope it helps.
> 
> 
> :wq!
> RoF
> 
> 
> Mailing-List: contact mysql-help@lists.mysql.com;
> run by ezmlm
> (http://www.ezmlm.org)
> List-ID: <mysql.mysql.com>
> Precedence: bulk
> List-Help: <mailto:mysql-help@lists.mysql.com>
> List-Unsubscribe:
>
<mailto:mysql-unsubscribe-graulich=reiff.de@lists.mysql.com>
> List-Post: <mailto:mysql@lists.mysql.com>
> List-Subscribe:
> <mailto:mysql-subscribe@lists.mysql.com>
> Delivered-To: mailing list mysql@lists.mysql.com
> Date: Mon, 25 Sep 2000 14:50:09 -0700 (PDT)
> From: <zhou@gnf.org>
> To: mysql@lists.mysql.com
> Subject: RE: datetime bug in alpha-linux?
> MIME-Version: 1.0
> 
> SEND-PR: -*- send-pr -*-
> SEND-PR: Lines starting with `SEND-PR' will be
> removed automatically, as
> SEND-PR: will all comments (text enclosed in `<' and
> `>').
> SEND-PR:
> From: zhou@gnf.org
> To: mysql@lists.mysql.com
> Subject: [50 character or so descriptive subject
> here (for reference)]
> 
> >Description:
> Problem with datetime in Linux (Alpha). When I use
> datetime, the YYYYMMDD part
> is always 0000-00-00, can't modify it. (The same is
> good for date type, and
> good for linux in PC).
> 
> Please reply to zhou@gnf.org, since I am not
> subscribe to any mailing list
> here.
> >How-To-Repeat:
> mysql> create table ttt (d datetime);
> Query OK, 0 rows affected (0.00 sec)
> 
> mysql> insert into ttt values (now());
> Query OK, 1 row affected (0.00 sec)
> 
> mysql> select * from ttt;
> +---------------------+
> | d                   |
> +---------------------+
> | 0000-00-00 00:01:09 |
> +---------------------+
> 1 row in set (0.00 sec)
> 
> >Fix:
> none.
> 
> >Submitter-Id:	<submitter ID>
> >Originator:
> >Organization:
>  <organization of PR author (multiple lines)>
> >MySQL support: [none | licence | email support |
> extended email support ]
> >Synopsis:	<synopsis of the problem (one line)>
> >Severity:	<[ non-critical | serious | critical ]
> (one line)>
> >Priority:	<[ low | medium | high ] (one line)>
> >Category:	mysql
> >Class:		<[ sw-bug | doc-bug | change-request |
> support ] (one line)>
> >Release:	mysql-3.22.30 (Source distribution)
> >Server: /usr/local/bin/mysqladmin  Ver 7.15 Distrib
> 3.22.30, for
> >unknown-linux-gnu on alphaev6
> TCX Datakonsult AB, by Monty
> 
> Server version		3.22.30
> Protocol version	10
> Connection		Localhost via UNIX socket
> UNIX socket		/tmp/mysql.sock
> Uptime:			6 days 19 hours 44 min 58 sec
> 
> Threads: 1  Questions: 2266  Slow queries: 13 
> Opens: 77  Flush tables: 2
> Open tables: 17
> >Environment:
> 	<machine, os, target, libraries (multiple lines)>
> System: Linux master.gnf.org 2.2.17pre13 #2 SMP Fri
> Jul 21 07:16:54 PDT
> 2000 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-redhat-linux/egcs-2.91.66/specs
> gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2
> release)
> Compilation info: CC='gcc'  CFLAGS=''  CXX='c++' 
> CXXFLAGS=''  LDFLAGS=''
> Configure command: ./configure
> Perl: This is perl, version 5.005_03 built for
> alpha-linux
> 
> 
> --
>
---------------------------------------------------------------------
> Please check
> "http://www.mysql.com/documentation/manual.php"
> before
> posting. To request this thread, e-mail
> mysql-thread51628@lists.mysql.com
> 
> To unsubscribe, send a message to:
>    
>
<mysql-unsubscribe-graulich=reiff.de@lists.mysql.com>
> 
> If you have a broken mail client that cannot send a
> message to
> the above address (Microsoft Outlook), you can use:
>     http://lists.mysql.com/php/unsubscribe.php
> 
> 
> Mailing-List: contact mysql-help@lists.mysql.com;
> run by ezmlm
> (http://www.ezmlm.org)
> List-ID: <mysql.mysql.com>
> Precedence: bulk
> List-Help: <mailto:mysql-help@lists.mysql.com>
> List-Unsubscribe:
>
<mailto:mysql-unsubscribe-graulich=reiff.de@lists.mysql.com>
> List-Post: <mailto:mysql@lists.mysql.com>
> List-Subscribe:
> <mailto:mysql-subscribe@lists.mysql.com>
> Delivered-To: mailing list mysql@lists.mysql.com
> From: <sinisa@mysql.com>
> MIME-Version: 1.0
> Date: Tue, 26 Sep 2000 15:41:40 +0300 (EEST)
> To: zhou@gnf.org
> Cc: mysql@lists.mysql.com
> Subject: RE: datetime bug in alpha-linux?
> Status: RO
> X-Status:
> X-Keywords:
> X-UID: 9168
> 
> zhou@gnf.org writes:
>  > SEND-PR: -*- send-pr -*-
>  > SEND-PR: Lines starting with `SEND-PR' will be
> removed automatically, as
>  > SEND-PR: will all comments (text enclosed in `<'
> and `>').
>  > SEND-PR:
>  > From: zhou@gnf.org
>  > To: mysql@lists.mysql.com
>  > Subject: [50 character or so descriptive subject
> here (for reference)]
>  >
>  > >Description:
>  > Problem with datetime in Linux (Alpha). When I
> use datetime, the
> YYYYMMDD part
>  > is always 0000-00-00, can't modify it. (The same
> is good for date type,
> and good for linux in PC).
>  >
>  > Please reply to zhou@gnf.org, since I am not
> subscribe to any mailing
> list here.
>  > >How-To-Repeat:
>  > mysql> create table ttt (d datetime);
>  > Query OK, 0 rows affected (0.00 sec)
>  >
>  > mysql> insert into ttt values (now());
>  > Query OK, 1 row affected (0.00 sec)
>  >
>  > mysql> select * from ttt;
>  > +---------------------+
>  > | d                   |
>  > +---------------------+
>  > | 0000-00-00 00:01:09 |
>  > +---------------------+
>  > 1 row in set (0.00 sec)
>  >
>  > >Fix:
> 
=== message truncated ===


__________________________________________________
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/