Uniqueness validation does not work since the beginning of Ruby on Rails

Check out my recent article about the uniqueness validation problem and how to solve it. Spoiler: unique index is not enough!
https://evgeniydemin.medium.com/uniqueness-validation-does-not-work-since-the-beginning-of-ruby-on-rails-57f129c58576