Bug #227 MAX(), MIN() with strings
Submitted: 4 Apr 2003 5:53 Modified: 4 Apr 2003 7:21
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:3.23.56 OS:Microsoft Windows (Windows XP)
Assigned to: CPU Architecture:Any

[4 Apr 2003 5:53] [ name withheld ]
Description:
A sample query: 

select max(string_fielt1), min(string_fielt1) from some_table;

result:

max            min
abc            abcdefj
3>7 !???

How to repeat:
[4 Apr 2003 7:21] Miguel Solorzano
Testinf it has worked as expected:

mysql> select min(u), max(u) from m;
+--------+---------+
| min(u) | max(u)  |
+--------+---------+
| abc    | abcdefj |
+--------+---------+
1 row in set (0.00 sec)