search

vieten / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

Unique index generation #1221

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. create unique index on multiple fields

What is the expected output? What do you see instead?
There should be a unique index on 2 fields, but it's not, I can enter multiple 
records with same values. When I added index manualy with:  ALTER TABLE cart 
ADD UNIQUE idx_user_product(user_id,product_id);
Now it works, but setting index with SequelPro doesn't work

What version of Sequel Pro are you using? What version of MySQL are you
connecting to on the server?
SequelPro 3450, MySQL is 5.0.51a

Please provide any additional information below.

Original issue reported on code.google.com by marko.br...@gmail.com on 28 Oct 2011 at 10:16

GoogleCodeExporter commented 9 years ago 
Unable to reproduce using the last trunk code. I consistently receive an error 
when attempting to add multiple records with the same values in fields included 
in the unique index.

Original comment by stuart02 on 5 Nov 2011 at 9:45

GoogleCodeExporter commented 9 years ago 
Closing after no further feedback.

Original comment by stuart02 on 2 Jan 2012 at 3:59