Subject: Re: mysql NOW() bug on Alpha? - updated
To: None <thorpej@zembu.com>
From: Ralph Graulich <graulich@shauny.de>
List: port-alpha
Date: 10/06/2000 09:19:58
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>
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>
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>
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>
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?
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:
> 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
>
>
Hi!
This is practically a known problem with Alpha and 3.22 version.
There are many bugs in GNU compilers for Alpha, and they have been
circumvented in MySQL 3.23.
Regards,
Sinisa
+----------------------------------------------------------------------+
| ____ __ _____ _____ ___ == MySQL AB |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@mysql.com |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
--
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php" before
posting. To request this thread, e-mail mysql-thread51667@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