UPDATE: DATETIME fields incorrect on alpha

[<ppetrakis firestorm tzo org>]

First let me apoligize for the cross-posting.

Picking up where this gentleman left off...
http://www.geocrawler.com/search/?config=8&words=Alpha+DATETIME

I'm experencing the same problem with both the stable and 'alpha' versions
of MySQL. I tried the suggestion of upgrading to glibc-2.1.2-17 (obtained
from redhat's rawhide dist) with no change. I then tried compiling the
stable and 'alpha' versions against the newer glibc. Now mysqld SEGV's at
startup. 

This SEGV is accomplished by using the 'alpha' SRPM with it's default
flags. gdb output of the core dump with a back trace is below:

[root@voodoo:/usr/src/redhat/RPMS/alpha]$ gdb mysqld core
GNU gdb 4.17.0.11 with Linux support
Copyright 1998 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you
are
welcome to change it and/or distribute copies of it under certain
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for
details.
This GDB was configured as "alpha-redhat-linux"...
Core was generated by `mysqld core'.
Program terminated with signal 11, Segmentation fault.
#0  0x120119ae8 in pthread_setcanceltype (type=1, oldtype=0x11ffffa70)
    at cancel.c:42
42        if (oldtype != NULL) *oldtype = THREAD_GETMEM(self,
p_canceltype);
(gdb) bt
#0  0x120119ae8 in pthread_setcanceltype (type=1, oldtype=0x11ffffa70)
    at cancel.c:42
#1  0x120118c48 in fcntl (fd=0, cmd=1) at wrapsyscall.c:77
#2  0x120123624 in check_standard_fds () at
../sysdeps/generic/libc-start.c:99
#3  0x120123810 in __libc_start_main (main=0x12004bfa0 <main>, argc=2,
    argv=0x11ffffb58, init=0x120000120 <_init>, fini=0x120183c40 <_fini>,
    rtld_fini=0, stack_end=0x11ffffb40) at
../sysdeps/generic/libc-start.c:60
Current language:  auto; currently c

If I try to compile the 'alpha' version according to the alpha-linux
compile time flags specified at
http://www.mysql.com/Manual_chapter/manual_Installing.html#Linux-Alpha .
It will fail at compiling. To reiterate  the flags i used where: 

(syntax is from modified spec file in the 'alpha' SRPM)

	CC=\"${MYSQL_BUILD_CC:-gcc}\" \
	CFLAGS=\"${MYSQL_BUILD_CFLAGS:- -Dalpha_linux_port }\" \
	CXX=\"${MYSQL_BUILD_CXX:-gcc}\" \
	CXXFLAGS=\"${MYSQL_BUILD_CXXFLAGS:- -O3 -Dalpha_linux_port
-felide-constructors -fno-exceptions -fno-rtti  }\" \

The error message is:

egcs -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I..
-D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -O6
-DDBUG_OFF -O3 -Dalpha_linux_port -DDONT_USE_THR_ALARM -c  -fPIC -DPIC
net.c -o .libs/net.lo
net.c: In function `my_net_init':
net.c:150: `TCP_NODELAY' undeclared (first use in this function)
net.c:150: (Each undeclared identifier is reported only once
net.c:150: for each function it appears in.)
make[2]: *** [net.lo] Error 1
make[2]: Leaving directory
`/usr/src/redhat/BUILD/mysql-3.23.7-alpha/client'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.7-alpha'
make: *** [all-recursive-am] Error 2
Bad exit status from /var/tmp/rpm-tmp.2003 (%build)
[1]+  Done                    emacs mysql-3.23.7-alpha.spec

Any ideas? Thank you.

Peter
--
www.alphalinux.org
Peter Petrakis         Warrior/Engineer        ppetrakis@alphalinux.org
"Oh my God! They killed Xena! You bastards!!"
"<BLAM!!> Who the hell are you!? Name's Ash <click clock> Housewares..."