Re: duplicate rows in spite of multi-column unique constraint

2015-03-24 Thread Johan De Meersman
Please do select id, customer_id, concat('-', group_id, '-') from app_customergroupmembership where customer_id ='ajEiQA'; I suspect one of those group IDs has a trailing space or similar 'invible' character that makes it not identical. - Original Message - From: Chris

MySQL Connector/J 5.1.35 has been released

2015-03-24 Thread Hery Ramilison
Hello all, MySQL Connector/J 5.1.35, a maintenance release of the production 5.1 branch has been released. Connector/J is the a Type-IV pure-Java JDBC driver for MySQL. It is suitable for use with MySQL server versions 5.5 and 5.6. MySQL Connector Java is available in source and binary form

Re: duplicate rows in spite of multi-column unique constraint

2015-03-24 Thread Chris Hornung
Thanks for the suggestions regarding non-printing characters, definitely makes sense as a likely culprit! However, the data really does seem to be identical in this case: mysql select id, customer_id, concat('-', group_id, '-') from app_customergroupmembership where customer_id ='ajEiQA';

Re: duplicate rows in spite of multi-column unique constraint

2015-03-24 Thread shawn l.green
Hi Chris, On 3/24/2015 10:07 AM, Chris Hornung wrote: Thanks for the suggestions regarding non-printing characters, definitely makes sense as a likely culprit! However, the data really does seem to be identical in this case: mysql select id, customer_id, concat('-', group_id, '-') from