Bug #74565 MAKE_SET s type is really string, not SET
Submitted: 25 Oct 2014 15:18
Reporter: Programmer Old Email Updates:
Status: Open Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:any OS:Any
Assigned to: CPU Architecture:Any

[25 Oct 2014 15:18] Programmer Old
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.