Bug #61613 [Asn]: No PDO error if first SQL statement of a group is valid.

Edit report at https://bugs.php.net/bug.php?id=61613&edit=1 ID: 61613 Updated by: rquadling@php.net Reported by: trebitzki at gmx dot net Summary: No PDO error if first SQL statement of a group is valid. Status: Assigned Type: Bug Package: PDO MySQL Operating System: Mac OS X PHP Version: 5.3.10 Assigned To: mysql Block user comment: N Private report: N New Comment: As the query contains multiple result sets, what is the response if you actually take a look at the next rowset using PDOStatement::nextRowSet() in conjunction with PDOStatement::errorInfo() / PDOStatement::errorCode()? Previous Comments: ------------------------------------------------------------------------ [2014-07-16 13:32:14] benjamin dot morel at gmail dot com Is anyone working on this problem? As mentioned above, it can lead to dangerous bugs as there's currently no way to know if all the queries have been successfully executed or not. ------------------------------------------------------------------------ [2014-03-31 05:39:17] oleg dot nucer at gmail dot com I have the same problem! In multiqueries PDO throws an error only for the first statement. And there is absolutely no difference what is going after... Please fix this problem, because it can lead to critical security holes or just hard-to-find bugs in web-applications. I'm using PHP 5.6 and MySQL 5.6 on Windows 8 x64. ------------------------------------------------------------------------ [2013-12-31 10:40:44] michal dot kikta at gmail dot com really annoying bug causing serious production hazards if we want to optimize by batching multiple queries is there any workaround except rewriting our database layer to mysqli or writing stored procedure on our mysql servers? ------------------------------------------------------------------------ [2013-05-08 12:50:08] danieldummy at hotmail dot com issue also happened in MSSQL(PDO DBLib) on Ubuntu with PHP 5.4.14-1~precise+1 ------------------------------------------------------------------------ [2012-11-04 05:19:37] invisiblexman2010 at gmail dot com I have the same issue, php 5.4.0, pdo_mysql 5.5.19, for Win64 (x86) ------------------------------------------------------------------------ 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=61613 -- Edit this bug report at https://bugs.php.net/bug.php?id=61613&edit=1