Wouter,
When I add an ORDER BY clause ( ORDER BY test.txt) the results will be as
followed:
+----+----------+--------+------------+
| id | parentid | txt | childcount |
+----+----------+--------+------------+
| 4 | 0 | Test | 0 |
| 1 | 0 | Test 1 | NULL |
+----+----------+--------+------------+
How is it possible that the childcount is different when I use the ORDER BY
clause, especially with subqueries?
This has been fixed in the upcoming 4.1.1 release (just tested it to make
sure).
Rgds,
Indrek
2 messages in com.mysql.lists.bugsRe: Problem with subqueries and order...