Bug #74912 [Com]: PDO errorInfo 1062 Duplicate entry

Edit report at https://bugs.php.net/bug.php?id=74912&edit=1 ID: 74912 Comment by: vlobovikov at gmail dot com Reported by: marc dot w dot hagen at gmail dot com Summary: PDO errorInfo 1062 Duplicate entry Status: Verified Type: Bug Package: PDO related Operating System: Debian 3.2.86-1 x86_64 PHP Version: 5.6.31 Block user comment: N Private report: N New Comment: $stmt->execute() === false AND erroInfo: Array ( [0] => 00000 [1] => [2] => ) Previous Comments: ------------------------------------------------------------------------ [2020-11-05 12:11:38] vlobovikov at gmail dot com I have same problem with "INSERT ... ON DUPLICATE KEY UPDATE ...". My PHP have v7.4.11 ------------------------------------------------------------------------ [2020-04-07 12:37:46] marc dot w dot hagen at gmail dot com Running this code on PHP (7.3.16 / 7.4.2 / 7.4.4) still results in same behaviour. I do not know nor test it on sqlite. ------------------------------------------------------------------------ [2020-04-07 12:23:29] cmb@php.net > Interestingly, pdo_sqlite3 also repeats the driver specific > error code and message, but has the SQLSTATE error reset to zero. Oops, this is exactly the same as with pdo_mysql. ------------------------------------------------------------------------ [2020-04-07 12:19:31] cmb@php.net I can confirm the broken behavior. Interestingly, pdo_sqlite3 also repeats the driver specific error code and message, but has the SQLSTATE error reset to zero. ------------------------------------------------------------------------ [2017-09-21 14:35:07] marc dot w dot hagen at gmail dot com Guys it's not a SQL BUG, it's the error code that not being reset. Please READ the description and look at the results. Please look at array(3) of both the Expected result and Actual result ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=74912 -- Edit this bug report at https://bugs.php.net/bug.php?id=74912&edit=1