SQL ENUM columns have noteable gotchas.
Probability: 71%
71%
Rated by:
whysage
Reasons:
Add reason
Probability
100%
Impact
+100
Info:
Cite code: 18 Created at: Aug. 24, 2022, 12:54 p.m.
Created by: whysage
Related:
SQL ENUM columns may only offer limited or negligible effects on optimization.
Probability: 100%
Probability: 100%
100%
Rated by:
whysage
Changing the member list of SQL ENUM columns is very expensive.
Probability: 100%
Probability: 100%
100%
Rated by:
whysage
You can't reuse the member-list of an SQL ENUM column in other tables.
Probability: 100%
Probability: 100%
100%
Rated by:
whysage
It's impossible to add additional attributes or related info to SQL ENUM.
Probability: 100%
Probability: 100%
100%
Rated by:
whysage