[Rails] Rails Bug? create_association delete existing record if duplicate exist

I am so frustrating by Rails!

I have two very simple models:

User
has_one :profile, :dependent => :destroy

Profile
belongs_to :user, :conditions => { :registered => true }
validates :user_id, :uniqueness => { :on => :create, :message =>
"can only have one profile!" }

I am trying to create Profile table without the default 'id' primary
key. I want to use user_id to find profile instead (not necessary to be
the primary key, I can use Profile.find_by_user_id.). But there are
issues with or without the default 'id' PK.

Issue #1: (profile with default "id" PK)
If a user has a profile already, and I run build_profile from the user
again, it will report a validation error and DELETE my exist profile
record (What the hell?):

ruby-1.9.2-p290 :037 > User.find(15).create_profile!
User Load (1.0ms) SELECT `users`.* FROM `users` WHERE `users`.`id`
= 15 LIMIT 1
(0.1ms) SAVEPOINT active_record_1
(0.3ms) SELECT 1 FROM `profiles` WHERE `profiles`.`user_id` =
BINARY 15 LIMIT 1
(0.2ms) ROLLBACK TO SAVEPOINT active_record_1
Profile Load (0.3ms) SELECT `profiles`.* FROM `profiles` WHERE
`profiles`.`user_id` = 15 LIMIT 1
(0.1ms) SAVEPOINT active_record_1
SQL (0.2ms) DELETE FROM `profiles` WHERE `profiles`.`id` = 5
(0.1ms) RELEASE SAVEPOINT active_record_1
ActiveRecord::RecordInvalid: Validation failed: User can only have
one profile!

Issue #2: (Profile with ":id => false" set in migration)
With or without a exist profile, every time create_profile is called, it
try to delete something with the non-exist 'id' field, which in turn
cause a error:

ruby-1.9.2-p290 :035 > User.find(15).create_profile!
User Load (0.7ms) SELECT `users`.* FROM `users` WHERE `users`.`id`
= 15 LIMIT 1
(0.1ms) SAVEPOINT active_record_1
SQL (0.2ms) INSERT INTO `profiles` (`created_at`, `updated_at`,
`user_id`) VALUES ('2011-11-03 03:49:35', '2011-11-03 03:49:35', 15)
(0.1ms) RELEASE SAVEPOINT active_record_1
Profile Load (0.3ms) SELECT `profiles`.* FROM `profiles` WHERE
`profiles`.`user_id` = 15 LIMIT 1
(0.1ms) SAVEPOINT active_record_1
SQL (0.5ms) DELETE FROM `profiles` WHERE `profiles`.`` = NULL
(0.1ms) ROLLBACK TO SAVEPOINT active_record_1
ActiveRecord::StatementInvalid: Mysql2::Error: Unknown column
'profiles.' in 'where clause': DELETE FROM `profiles` WHERE
`profiles`.`` = NULL

I am so confused with this call, what does it trying to delete?

SQL (0.5ms) DELETE FROM `profiles` WHERE `profiles`.`` = NULL

--
Posted via http://www.ruby-forum.com/.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.