> From: h...@tbbs.net > > 2013/11/04 09:32 -0800, Jan Steinman >> I noticed that I have similar queries that work as expected. The difference >> appears to be that every query that is broken uses " WITH ROLLUP", and >> removing this makes them behave as expected. >> >> Is this a known bug? Should I submit it as such? > > There is a bug that I about a half year ago reported, > http://bugs.mysql.com/bug.php?id=68564, that the NULL one expects with "WITH > ROLLUP" is not always NULL, but is instead the foregoing string in the same > field.
Okay, I think I found it: http://bugs.mysql.com/bug.php?id=47713 I added a comment with a link to a page I set up to show the behaviour on my system. http://www.ecoreality.org/wiki/WITH_ROLLUP_problem It was submitted in 2009, severity "Critical," triaged "Serious," and still not fixed! :::: The raw milk movement provides a real solution to the problem of food-borne illness -- because raw milk consumers make sure their milk comes from small, pasture-based farms and healthy animals unlikely to harbor pathogens and unlikely to contribute to water pollution, and because raw milk builds immunity to disease-causing organisms that are simply a natural part of the world in which we live. -- Ron Schmid :::: Jan Steinman, EcoReality Co-op :::: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql