I'm going to wait to fix this until after HHH-8737, otherwise the code would be throwaway.
Until then, workaround: create a new UniqueDelegate by extending DefaultUniqueDelegate and overriding #getAlterTableToDropUniqueKeyCommand. Create a custom Dialect (extend any of the MySQL5 Dialects) and provide that delegate through #getUniqueDelegate.
|