Subquery sometimes return incorrect results

Bug #1092955 reported by Bill Cornell
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
High
Unassigned
5.1
Invalid
Undecided
Unassigned
5.5
Fix Released
High
Unassigned
5.6
Fix Released
High
Unassigned

Bug Description

We reported a bug with 5.5.28-29.1 today to MySQL where a subquery sometimes return the wrong result. This was not the case in 5.5.25. Our hosting company (Crucial Web Host) told us that we should report the same bug to Percona.

MySQL has acknowledged this same bug here: http://bugs.mysql.com/bug.php?id=67866. There is example code of how to reproduce the bug. This is the exact same issue we are seeing with 5.5.28-29.1.

This is a serious flaw in our case because the query returns a dollar amount that is sometimes incorrect.

Tags: upstream

Related branches

Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

Upstream bug http://bugs.mysql.com/bug.php?id=67866 is verified.

Changed in percona-server:
status: New → Confirmed
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

According to upstream, fixed in 5.5.30, 5.6.11, and 5.7.1. 5.1 not affected.

tags: added: upstrream
tags: added: upstream
removed: upstrream
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-613

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.