Bug 152911 - mysql v4.1.10 has serious UNION/DATETIME crash bug
mysql v4.1.10 has serious UNION/DATETIME crash bug
Product: Red Hat Enterprise Linux 4
Classification: Red Hat
Component: mysql (Show other bugs)
All Linux
medium Severity medium
: ---
: ---
Assigned To: Tom Lane
David Lawrence
: Regression
Depends On:
Blocks: 137160
  Show dependency treegraph
Reported: 2005-03-30 18:31 EST by Michael Pearson
Modified: 2013-07-02 23:04 EDT (History)
2 users (show)

See Also:
Fixed In Version: RHBA-2005-471
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2005-06-09 07:42:49 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Michael Pearson 2005-03-30 18:31:47 EST
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20041107 Firefox/1.0

Description of problem:
The recent errata release of mysql-server contains MySQL bug 8660. In short, this bug causes the mysql server to SIGSEGV whenever two UNION'd queries contain a DATE() cast.

Please note that I have reproduced this bug on a i386 machine as well as the x86_64 machine.

More information can be found at:

Version-Release number of selected component (if applicable):

How reproducible:

Steps to Reproduce:
1. Update a RHES4 system's mysql-server package to 4.1.10a as per errata
2. Run the following queries in mysql:
create table a ( f datetime);
create table b ( f datetime);
select DATE(f) from a UNION select DATE(f) from b;

Actual Results:  mysql client software reported that the connection went away before the query was complete. The mysql-server error log reported a SIGSEGV and reload.

Expected Results:  Query should have completed successfully.

Additional info:

This is a very serious, open and recognized bug in the upstream mysql project and I expect better release engineering from an enterprise level product. What I installed as a trusted and essential security fix resulted in nearly two hours of downtime as we diagnosed the problem and implimented a workaround.
Comment 6 Tom Lane 2005-05-13 12:17:52 EDT
A fix for this is pending for RHEL4 QU1.
Comment 7 Tim Powers 2005-06-09 07:42:50 EDT
An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on the solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.


Note You need to log in before you can comment on or make changes to this bug.