← Back to team overview

maria-developers team mailing list archive

Re: unexpected "Duplicate entry" error



>>>>> "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


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


Follow ups