| 2016-05-26 18:08:02 |
Justin Gronfur |
bug |
|
|
added bug |
| 2016-05-26 18:08:02 |
Justin Gronfur |
attachment added |
|
bug.txt https://bugs.launchpad.net/bugs/1586122/+attachment/4670872/+files/bug.txt |
|
| 2016-05-26 18:12:01 |
Justin Gronfur |
summary |
ON DUPLICATE KEY UPDATE causes foreign key errors to be reported as duplicate key entry error |
ON DUPLICATE KEY UPDATE causes foreign key errors to be reported as duplicate entry error |
|
| 2016-05-26 18:12:41 |
Justin Gronfur |
description |
I recently updated a system to Percona Server 5.6.30-76.3 and had some code that relied on the incorrect behavior fixed by http://bugs.mysql.com/bug.php?id=78853
While updating that code to use INSERT ... ON DUPLICATE KEY UPDATE instead of INSERT IGNORE I noticed that foreign key constraint failures (ERROR 1452) are being incorrectly returned as duplicate entry (ERROR 1062). Please see the attached bug.txt that walks through a simple reproduction of the bug.
The seems to have been introduced in 5.6.30-76.3 as I have not be able to reproduce it in any other version. |
I recently updated a system to Percona Server 5.6.30-76.3 and had some code that relied on the incorrect behavior fixed by http://bugs.mysql.com/bug.php?id=78853
While updating that code to use INSERT ... ON DUPLICATE KEY UPDATE instead of INSERT IGNORE I noticed that foreign key constraint failures (ERROR 1452) are being incorrectly returned as duplicate entry (ERROR 1062) when an ON DUPLICATE KEY UPDATE clause is present. Please see the attached bug.txt that walks through a simple reproduction of the bug.
The seems to have been introduced in 5.6.30-76.3 as I have not be able to reproduce it in any other version. |
|
| 2016-09-12 20:26:14 |
Justin Gronfur |
percona-server: status |
New |
Fix Released |
|
| 2016-09-13 13:02:01 |
Laurynas Biveinis |
tags |
|
upstream |
|
| 2016-09-13 13:02:08 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.5 |
|
| 2016-09-13 13:02:08 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.5 |
|
| 2016-09-13 13:02:08 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.6 |
|
| 2016-09-13 13:02:08 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.6 |
|
| 2016-09-13 13:02:08 |
Laurynas Biveinis |
nominated for series |
|
percona-server/5.7 |
|
| 2016-09-13 13:02:08 |
Laurynas Biveinis |
bug task added |
|
percona-server/5.7 |
|
| 2016-09-13 13:02:16 |
Laurynas Biveinis |
percona-server/5.6: status |
New |
Fix Released |
|
| 2016-09-13 13:02:18 |
Laurynas Biveinis |
percona-server/5.5: status |
New |
Fix Released |
|
| 2016-09-13 13:02:33 |
Laurynas Biveinis |
bug watch added |
|
http://bugs.mysql.com/bug.php?id=78853 |
|
| 2016-09-13 13:02:33 |
Laurynas Biveinis |
bug task added |
|
mysql-server |
|
| 2016-09-13 13:04:27 |
Laurynas Biveinis |
percona-server/5.5: milestone |
|
5.5.49-37.9 |
|
| 2016-09-13 13:04:31 |
Laurynas Biveinis |
percona-server/5.6: milestone |
|
5.6.30-76.3 |
|
| 2016-09-13 13:04:35 |
Laurynas Biveinis |
percona-server/5.7: milestone |
|
5.7.12-5 |
|
