A wrong UNIQUE violation is caused here by camparing strings
'def' and 'def ' (with space), under utf8mb4_unicode_nopad_ci collation,
which means "don't count in paddings when comparing".

Field::cmp_prefix uses a comparison through collation, so cmp_binary should
be used instead.