Bug #119491 Incorrect results for make_set operation against longtext column

• Submitted: 2 Dec 8:21
• Reporter: John Jove
• Status: Open
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 8.4.7
• OS: Any
• CPU Architecture: Any

[2 Dec 8:21] John Jove

Description:
I run the following case, which is expected to return the full content of c1, instead of a truncated value.

How to repeat:
DROP TABLE t1;
CREATE TABLE t1 (c1 LONGTEXT);
INSERT INTO t1 VALUES ('hEGqztW6lIRzG');
SELECT (MIN((MAKE_SET((CAST(1 AS CHAR)), c1, NULL, (IF((ABS(-1)), 1, 0)))))) FROM t1 GROUP BY c1; -- acutal: {hEG}, expected: {hEGqztW6lIRzG}