When I use an
ENUM column in a table the
ORDER BY uses the ordinal of the
ENUM not its value. I wasn't aware of that.
So my question is what are the subtle issues when an
ENUM is part of an index definition? Is it an antipattern or bad idea?
|show 2 more comments|