>Description:
We just upgraded our Sun Ultra 60's to Solaris 8, and in so doing,
We upgraded MySQL from 3.22.32 to 3.23.36 (installed from source package).
The new version of the server quits with status 1, and no error log
output, when we do the following query:
select * from foo where fooDate = '2001/1/2'
(or any date). It also happens with "... >= '2001/1/2'", ie., any query
on a date.
Here's a dump of the simple table:
# MySQL dump 8.13
#
# Host: localhost Database: allenhdb
#--------------------------------------------------------
# Server version 3.23.36-log
#
# Table structure for table 'foo'
#
CREATE TABLE foo (
fooDate date default NULL
) TYPE=MyISAM;
#
# Dumping data for table 'foo'
#
INSERT INTO foo VALUES ('2001-01-02');
We re-installed 3.22.32, and it works fine. This problem also existed
with 3.23.35 when I tried that.
It's hard to believe that this is a bug in MySQL, more likely some
configuration problem or OS compatibility issue (?). Either way, it's
pretty serious for us. Maybe we just did something wrong.
>How-To-Repeat:
The Description section pretty well describes how to duplicate the
problem, at least on our machines. Hopefully you'll see the same thing.
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Allen Hopkins
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: server quits on date query
>Severity: serious
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.36 (Source distribution)
>Server: mysqladmin Ver 8.18 Distrib 3.23.36, for sun-solaris2.8 on sparc
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.36-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 2 min 51 sec
Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0
Queries per second avg: 0.006
>Environment:
System: SunOS markov 5.8 Generic_108528-06 sun4u sparc SUNW,Ultra-60
Architecture: sun4
Some paths: /bin/perl /home/allenh/bin/make /usr/sww/bin/gmake /usr/local/bin/gcc
/usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc' CFLAGS='-O1' CXX='gcc' CXXFLAGS='-O1
-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
-rw-r--r-- 1 root 1749356 Jul 20 2000 /lib/libc.a
lrwxrwxrwx 1 root 11 Mar 26 20:32 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root 1135056 Jul 20 2000 /lib/libc.so.1
-rw-r--r-- 1 root 1749356 Jul 20 2000 /usr/lib/libc.a
lrwxrwxrwx 1 root 11 Mar 26 20:32 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root 1135056 Jul 20 2000 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql-3.23.36
--localstatedir=/home/www/mysql
Perl: This is perl, version 5.005_03 built for sun4-solaris
---------------------------------------------------------------------
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
