Description:
In the HTML help it is said that MAKE_SET yields a set, but, really, it yields a character string.
How to repeat:
select make_set(1,'a','b') | 2, make_set(1,'a','b')
which yields 2 and 'a'. From the former it is clear that MySQL takes it for a string.
Suggested fix:
It would be great if, when this can be, then MAKE_SET yielded a real SET (something that is character string amongst character strings, and bitstring amongst bitstrings). It is enough, I believe, if the character arguments were constants. Then MySQL would have something like a SET constant.
It would be really wonderful if it would also be allowed that instead of the character arguments a SET variable from a table is an argument, making up a new value just like the SET in the table, with no need to first somehow set the field.