Bug 470036
| Summary: | Got query result when using ORDER BY ASC, but empty result when using DESC | ||
|---|---|---|---|
| Product: | Red Hat Enterprise Linux 5 | Reporter: | Adam Stokes <astokes> |
| Component: | mysql | Assignee: | Tom Lane <tgl> |
| Status: | CLOSED ERRATA | QA Contact: | BaseOS QE <qe-baseos-auto> |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | 5.3 | CC: | byte, hhorak, kvolny, patrickm, sghosh, syeghiay, tao |
| Target Milestone: | rc | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2009-09-02 09:46:00 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
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 therefore 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-2009-1289.html |
Description of problem: Got query result when using ORDER BY ASC, but empty result when using DESC Version-Release number of selected component (if applicable): 5.0.x How reproducible: No simple test case Steps to Reproduce: 1. 2. 3. Actual results: From mysql bug report mysql> select fr.md5key from fm_faxrec fr, fm_faxfile ff where fr.md5key=ff.md5key and -> ff.md5key='1a70b58e0cd94dfced359d270e12387c' and viewable='Y' order by rev desc; Empty set (0.03 sec) mysql> select fr.md5key from fm_faxrec fr, fm_faxfile ff where fr.md5key=ff.md5key and -> ff.md5key='1a70b58e0cd94dfced359d270e12387c' and viewable='Y' order by rev asc; +----------------------------------+ | md5key | +----------------------------------+ | 1a70b58e0cd94dfced359d270e12387c | +----------------------------------+ 1 row in set (0.00 sec) Expected results: No empty result set Additional info: http://bugs.mysql.com/bug.php?id=33758 http://lists.mysql.com/commits/42099