index duplication?
Reported by Dae San Hwang | January 2nd, 2008 @ 01:44 PM
When unique index is defined inline, two indices are created. (one unique, and one non-unique)
class User < DataMapper::Base
property :login, :string, :nullable => false, :index => :unique
end
mysql> show create table users;
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`login` varchar(50) NOT NULL,
UNIQUE KEY `login` (`login`),
KEY `users_login_index` (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=ucs2
Comments and changes to this ticket
-
Sam Smoot January 2nd, 2008 @ 04:09 PM
- Milestone cleared.
- State changed from “new” to “open”
-
Bernerd Schaefer January 6th, 2008 @ 09:33 AM
- Assigned user set to “Bernerd Schaefer”
-
Bernerd Schaefer January 6th, 2008 @ 10:11 AM
- State changed from “open” to “resolved”
This is fixed in r684
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
Rick