Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.37, 10.0.11
-
None
-
None
-
Ubuntu Precise, also Ubuntu 14.04
Description
I got a wrong result in two different machines
I tried after uploading the prueba.sql file the following query:
SELECT * FROM agentes WHERE id in (select distinct id_agente from otra) ORDER BY nombre ASC; |
I get:
+----+--------+
|
| id | nombre |
|
+----+--------+
|
| 1 | row 1 |
|
| 1 | row 1 |
|
| 1 | row 1 |
|
| 2 | row 2 |
|
| 2 | row 2 |
|
| 3 | row 3 |
|
+----+--------+
|
but if I remove the order by clause I get:
+----+--------+
|
| id | nombre |
|
+----+--------+
|
| 1 | row 1 |
|
| 2 | row 2 |
|
| 3 | row 3 |
|
+----+--------+
|
I don't put much more information i think it's very reproductible since i got it in two different machines.