doesn't handle collate for min/max(enum/set column)

[wjhuang2016]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table tt(a char(10), b enum('a', 'B', 'c'), c set('a', 'B', 'c'), d json) collate utf8mb4_general_ci;
insert into tt values ("a", "a", "a", JSON_OBJECT("a", "a"));
insert into tt values ("A", "A", "A", JSON_OBJECT("A", "A"));
insert into tt values ("b", "b", "b", JSON_OBJECT("b", "b"));
insert into tt values ("B", "B", "B", JSON_OBJECT("B", "B"));
insert into tt values ("c", "c", "c", JSON_OBJECT("c", "c"));
insert into tt values ("C", "C", "C", JSON_OBJECT("C", "C"));
split table tt by (0), (1), (2), (3), (4), (5);
select min(b) from tt;
select max(b) from tt;
select min(c) from tt;
select max(c) from tt;

2. What did you expect to see? (Required)

mysql> select min(b) from tt;
+--------+
| min(b) |
+--------+
| a      |
+--------+
1 row in set (0.00 sec)

mysql> select max(b) from tt;
+--------+
| max(b) |
+--------+
| c      |
+--------+
1 row in set (0.00 sec)

mysql> select min(c) from tt;
+--------+
| min(c) |
+--------+
| a      |
+--------+
1 row in set (0.00 sec)

mysql> select max(c) from tt;
+--------+
| max(c) |
+--------+
| c      |
+--------+
1 row in set (0.00 sec)

3. What did you see instead (Required)

mysql> select min(b) from tt;
+--------+
| min(b) |
+--------+
| B      |
+--------+
1 row in set (0.02 sec)

mysql> select max(b) from tt;
+--------+
| max(b) |
+--------+
| c      |
+--------+
1 row in set (0.00 sec)

mysql> select min(c) from tt;
+--------+
| min(c) |
+--------+
| B      |
+--------+
1 row in set (0.00 sec)

mysql> select max(c) from tt;
+--------+
| max(c) |
+--------+
| c      |
+--------+
1 row in set (0.00 sec)

4. What is your TiDB version? (Required)

master

[github-actions]

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.