Issue with id when creating a new object using MySql

[kuldeepaggarwal]

class User < ActiveRecord::Base
end

when I am creating an user, like

>> u = User.create(id: 'test', name: 'KD')
SQL (16.9ms)  INSERT INTO `users` (`created_at`, `id`, `name`, `updated_at`) VALUES ('2013-11-26 12:57:51', 0, '\nKD', '2013-11-26 12:57:51')
=> #<User id: 0, name: "KD", created_at: "2013-11-26 12:57:51", updated_at: "2013-11-26 12:57:51">

It is initializing the object with id = 0(because id was set to 'test'), but actual id stored in DB is '1'.

>> User.last
=> #<User id: 1, name: "KD", created_at: "2013-11-26 12:57:51", updated_at: "2013-11-26 12:57:51">

So is this correct or a bug? Shouldn't the id be last generated id, i.e. 1

[dmathieu]

You shouldn't define primary keys yourself. Just let your database define it.
Also, most database engines are optimized for integer primary keys. You shouldn't use strings.

If what you're looking to do is add slugs to models, take a look at friendly_id.

[arunagw]

True. Why you want to assign a primary_key which is auto incremented anyway

Closing this.