If I remember correctly, 8.0 has them finally. 8.0 seems to have fixed a lot of the weird legacy eccentricities of MySQL