Re: Problem with subqueries and order by clause
Indrek Siitan <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <BBC48613.35570%[email protected]> |
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 -- | Indrek Siitan, MySQL AB, Support Engineer & Bugmaster | Uuemõisa, Haapsalu, Estonia +- | Are you MySQL Certified? http://www.mysql.com/certification/ -- -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]