Add support for MySQL's SET type

[lukaseder]

MySQL knows a useful, vendor-specific SET type, which works like ENUM but allows for maintaining multiple enum literals within a set (without duplicates). We should support this type and map it to java.util.EnumSet<GeneratedEnum>.

More information:

• https://dev.mysql.com/doc/refman/5.7/en/set.html

---

See also:
http://stackoverflow.com/q/33277111/521799

[javapowered]

Should we address in this issue bitwise updates?
If jooq start using EnumSet instead of String for MySQL Set how will we do bitwise updates?
Strings can be updated this way https://stackoverflow.com/a/17089677/93647

[lukaseder]

@javapowered Thanks for your question. I see your point.

Since we're not in a hurry to implement this feature, we can still think about this later. It will always be possible to:

• Undo this improvement in the code generator by adding a forced type that pretends the SET type is a TEXT column
• Create plain SQL templating support for such features (https://www.jooq.org/doc/latest/manual/sql-building/plain-sql-templating/), regardless of how the type is implemented in jOOQ

[javapowered]

Got it, thanks!