TalkPHP - WITH ROLLUP producing unexpected results

TalkPHP (http://www.talkphp.com/forums.php)

- MySQL & Databases (http://www.talkphp.com/mysql-databases/)

- - WITH ROLLUP producing unexpected results (http://www.talkphp.com/mysql-databases/5080-rollup-producing-unexpected-results.html)

delayedinsanity

11-01-2009 07:12 PM

WITH ROLLUP producing unexpected results

I thought I understood that ROLLUP used in conjunction with a GROUP BY clause is supposed to produce an additional row which sums up the data selected.

However, in one such instance, these are the results I'm getting;

Code:

2009-10-31   |   8   |   14

2009-11-01   |  72   |  149

NULL         |  78   |  163

The third column is totaled correctly, but the second is very obviously not. Double U Tee Eff? I think I'm missing something...

All times are GMT. The time now is 12:56 PM.