This is working as intended. CB isn't stopping the password change, but Joomla is. Joomla 2.5 does not allow Super Users to reset their password. However, the error should output instead of just displaying "SQL error:". I've created the below bug ticket to fix the output to display the error properly.