Bug #9548 MAX function returns smallest value
Submitted: 1 Apr 2005 0:59 Modified: 1 Apr 2005 3:33
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.6 OS:Windows (XP Prof)
Assigned to: CPU Architecture:Any

[1 Apr 2005 0:59] [ name withheld ] 
Description:
I must be seeing things... the following statement returns 8 instead of 20.
No word of a lie.

SELECT member_id, MAX(final_score)
FROM atutor.at_tests_results
group by member_id

Table contents:
member_id  final_score
1              20
1               8

This is no prank.
What am I missing?

Thanks

How to repeat:
Execute button

Suggested fix:
No idea.
[1 Apr 2005 1:42] [ name withheld ] 
Too embarrassed.  
Column is of type string. Enough said.