BUG: Multiple Result Set Reported When GROUP BY Clause Is Used

SYMPTOMS

If you use a GROUP BY clause with the bit field (this has to be converted to another datatype, such as int, char, and so forth) will cause more than one row to be returned in the result set when only one should be expected.

This problem occurs GROUP BY clause processing during query processing time especially when there are repeated records in the table.