Bug 349121 - MySQL client will display empty strings as NULL (fixed in 5.0.23)
Summary: MySQL client will display empty strings as NULL (fixed in 5.0.23)
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Linux 5
Classification: Red Hat
Component: mysql
Version: 5.0
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
: ---
Assignee: Tom Lane
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2007-10-23 17:43 UTC by Larry Low
Modified: 2013-07-03 03:15 UTC (History)
2 users (show)

Fixed In Version: RHSA-2008-0364
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2008-05-21 15:23:59 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2008:0364 0 normal SHIPPED_LIVE Low: mysql security and bug fix update 2008-05-20 12:44:41 UTC

Description Larry Low 2007-10-23 17:43:46 UTC 
Description of problem:
The mysql client will display empty string values as NULL.  This is fixed in 5.0.23

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

How reproducible:
100%

Steps to Reproduce:
1. insert empty string into a table
2. select * from table and see NULL displayed
3. select * from table matching on empty string and see entry returned
4. select * from table matching on NULL and see entry not returned
  
Additional info:
MYSQL Bug 19564 http://bugs.mysql.com/bug.php?id=19564
MYSQL Bug 20067 http://bugs.mysql.com/bug.php?id=20067
Comment 2 RHEL Program Management 2007-10-23 21:24:41 UTC 
This request was evaluated by Red Hat Product Management for inclusion in a Red
Hat Enterprise Linux maintenance release.  Product Management has requested
further review of this request by Red Hat Engineering, for potential
inclusion in a Red Hat Enterprise Linux Update release for currently deployed
products.  This request is not yet committed for inclusion in an Update
release.
Comment 3 Jay Turner 2007-11-30 07:05:07 UTC 
QE ack for RHEL5.2.  Steps to reproduce in comment 0.
Comment 7 errata-xmlrpc 2008-05-21 15:23:59 UTC 
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.

http://rhn.redhat.com/errata/RHSA-2008-0364.html
Note You need to log in before you can comment on or make changes to this bug.