issue in count()

[mromid]

when i run this query every thing is ok :
$stmt = $db->table('call_history')
->select('id')
->where('caller_id', $operator_id)
->groupBy('user_id')
->get();
// result is 5 record
but
run this query :
$stmt = $db->table('call_history')
->select('id')
->where('caller_id', $operator_id)
->groupBy('user_id')
->count();
// result is number 30 (common record not grouped)

groupby not true work !

when i remove groupBy from my query every thing is ok

[eL-Prova]

@mromid Its hard to read what you are trying to say.
What do you expect? The 5 or the 30 records?
Have you tried to see the extracted sql? In this case what is your raw query output...

[catchem99]

I think I got what he means,
Steps to reproduce:
Import this really simple table
OR
make one like:
purchase_id,purchase_code
1,abc
2,def

Then use QB::table('TABLENAME')->groupBy('purchase_code')->count(); //This will return 1
while if you use a standard query SELECT * FROM TABLENAME GROUP BY purchase_code //It should return 2

EDIT: tested on MySQL

[mtarlac]

Same problem like #180