Glossary view returns unexpected results.

I wrote a test to test the glossary view for drupal7, but on drupal6 the test doesn't pass. Then i looked at the records, and wow, they weren't correct.

killes suggested to add SUM(1) instead of node.nid and wow this worked. I'm not sure whether this is the way to go.

There is added the patch and the test. I suggest to run first the test, to see that it is broken.