I tried to check validates_uniqueness_of for a MySql enum type column
with a scope given, like this:
validates_uniqueness_of :phone_type, :scope => :user_id
And It didn’t work. When I check the SQL statement for doing this
validation, it is like this:
SELECT phone_numbers
.id FROM phone_numbers
WHERE
(phone_numbers
.phone_type
= BINARY ‘’ AND phone_numbers
.user_id
= 23) LIMIT 1
phone_type was set to be “Home”. If I try validates_uniqueness_of on
any other columns. it works fine. Could some please highlight me
what’s going on? Thanks