Bug #66621 [Fbk]: PDO::commit() bug

Edit report at https://bugs.php.net/bug.php?id=66621&edit=1 ID: 66621 Updated by: ab@php.net Reported by: enrico_kaelert at kabelmail dot de Summary: PDO::commit() bug Status: Feedback Type: Bug Package: PDO MySQL Operating System: Windows 7 64bit PHP Version: Irrelevant Assigned To: ab Block user comment: N Private report: N New Comment: Enrico, don't get me wrong, but brevity is wit. The script is still too excessive, but the explanation in your latest pastebin is much better, even for such a dull person like me. Lets see. Thanks Previous Comments: ------------------------------------------------------------------------ [2014-04-24 12:25:49] enrico_kaelert at kabelmail dot de Sorry, but i cant reduce that test script to 20 lines. I dont wanna wast your or my time. But i wrote it again as simple as possible: explanation and script at once. http://pastebin.com/wt2DiNNB If you dont understand what im doing there .. well, then sorry, i wont do more. What you do if somebody wants to report a huge security bug? In 20 lines? Well, ... . Please dont get me wrong, but you need to spend a bit time to bug reports. ------------------------------------------------------------------------ [2014-04-24 06:25:36] ab@php.net Hi, I very appreciate your willingness to help, but still the script is not "10-20 lines long". Please reduce it as much as possible, it is really hard to understand now what is your issue and it would take to much time to debug such a big piece of code. Many thanks. ------------------------------------------------------------------------ [2014-04-23 15:27:41] enrico_kaelert at kabelmail dot de I changed the test script so the database and the table will be created. I cant make it easier for you ;) here is the script: http://pastebin.com/LyK5FUbN ------------------------------------------------------------------------ [2014-04-23 14:37:28] ab@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2014-02-25 18:20:58] enrico_kaelert at kabelmail dot de Forget about the part: " Weird: If you look at the SELECT (# 4.) you can see that we get "fake"(?)-results back. On every run the AUTO_INCREMENT counts up which is real - so those ids get lost. " Of curse the queries was sent to the sql server, auto_increment counted up (see docu dev.mysql.com). The INSERTS/UPDATES/.. are not committed, so i guess we are getting the data out of temp tbls. ------------------------------------------------------------------------ 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=66621 -- Edit this bug report at https://bugs.php.net/bug.php?id=66621&edit=1