← Back to team overview

maria-developers team mailing list archive

Re: unexpected "Duplicate entry" error

 

Hi!

>>>>> "Vincent" == Vincent Pelletier <vincent@xxxxxxxxxx> writes:

Vincent> Hi.
Vincent> Bumping this thread with a slightly different finding which may help
Vincent> understanding the issue.

Vincent> I'll use two command lines for this test, "MariaDB 1" and "MariaDB 2",
Vincent> also distinguished by indentation level for readability.
Vincent> Server version: 5.5.30-MariaDB-log MariaDB Server

<cut>

Vincent> So far, all good.

Vincent>   MariaDB 1> delete from tst;
Vincent>   Query OK, 3 rows affected (0.00 sec)

Vincent> Why "3 rows affected" ?

This is because in InnoDB, delete is run under the READ COMMITTED
isolation level, not REPETABLE READ as SELECT.

This is an optimization that Heikki did a long time ago that has this
strange side effect.

See the comment posted by Radek on
http://dev.mysql.com/doc/refman/5.5/en/delete.html

Regards,
Monty


Follow ups

References