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

From:	trebitzki at gmx dot net	Date:	Mon, 29 Sep 2014 16:34:30 +0000
Subject:	Bug #61613 [Asn]: No PDO error if first SQL statement of a group is valid.
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-187756@lists.php.net to get a copy of this message

Edit report at https://bugs.php.net/bug.php?id=61613&edit=1

 ID:                 61613
 User updated by:    trebitzki at gmx dot 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:

The test script I included in my original bug report for this issue was only a simple example. I
actually had this issue with a set of SQL UPDATE statements, so showing how fetching rows and
looping through result sets obviates this is not really addressing the issue. When my first update
statement runs successfully I can't call nextrowset(); the statements just run one after the
other. The problem with not getting error info for any following statement that may fail still
stands. And I must say that I am very surprised and disappointed that noone in the php group is
willing to come to grips with this - after more than 2 1/2 years!


Previous Comments:
------------------------------------------------------------------------
[2014-09-24 16:38:09] benjamin dot morel at gmail dot com

@rquadling Genius!

Indeed, just tested it on a PDO configured to throw exceptions, and the PDOException is thrown as
soon as nextRowSet() is called!

When it's configured to *not* throw exceptions, as you guessed, the error information becomes
available with PDOStatement::getErrorInfo().

So there's no bug after all, the behaviour of PHP is perfectly fine, maybe we could just
mention this on the PDO error handling page in the docs?

http://php.net/manual/en/pdo.error-handling.php

Thanks so much.

------------------------------------------------------------------------
[2014-09-24 15:32:37] rquadling@php.net

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()?

------------------------------------------------------------------------
[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?

------------------------------------------------------------------------


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


   

Thread (26 messages)

• trebitzki at gmx dot netTue, 03 Apr 2012 22:57:20 +0000
  • johannes@php.netWed, 11 Apr 2012 15:08:20 +0000Bug #61613 [Opn->Fbk]: No PDO error if first SQL statement of a group is valid.
  • trebitzki at gmx dot netWed, 11 Apr 2012 23:27:03 +0000Bug #61613 [Fbk->Opn]: No PDO error if first SQL statement of a group is valid.
  • jonwage at gmail dot comWed, 01 Aug 2012 19:40:01 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • angel dot koilov at gmail dot comTue, 28 Aug 2012 22:09:08 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • verger dot antoine at gmail dot comMon, 29 Oct 2012 09:42:41 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • invisiblexman2010 at gmail dot comSun, 04 Nov 2012 05:19:37 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • danieldummy at hotmail dot comWed, 08 May 2013 12:50:08 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • michal dot kikta at gmail dot comTue, 31 Dec 2013 10:40:45 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • oleg dot nucer at gmail dot comMon, 31 Mar 2014 05:39:18 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • benjamin dot morel at gmail dot comWed, 16 Jul 2014 13:32:15 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • rquadling@php.netWed, 24 Sep 2014 15:32:38 +0000Bug #61613 [Asn]: No PDO error if first SQL statement of a group is valid.
  • benjamin dot morel at gmail dot comWed, 24 Sep 2014 16:38:10 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • trebitzki at gmx dot netMon, 29 Sep 2014 16:34:30 +0000Bug #61613 [Asn]: No PDO error if first SQL statement of a group is valid.
  • pesterhazy at gmail dot comMon, 13 Oct 2014 10:26:46 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • mikhail dot v dot gavrilov at gmail dot comTue, 14 Apr 2015 14:12:42 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • blaimi at blaimi dot deTue, 16 Jun 2015 15:51:22 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • fekiri_malek at hotmail dot comSun, 02 Aug 2015 09:19:14 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • col dot shrapnel at gmail dot comWed, 16 Sep 2015 10:23:43 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • tony2001@php.netWed, 16 Sep 2015 10:31:26 +0000Bug #61613 [Asn->Nab]: No PDO error if first SQL statement of a group is valid.
  • Daniel at Kraffner dot deWed, 16 Sep 2015 11:53:28 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • benjamin dot morel at gmail dot comWed, 16 Sep 2015 12:41:44 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • phpbug at braten dot beTue, 06 Mar 2018 10:45:23 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • spam2 at rhsoft dot netTue, 06 Mar 2018 10:49:36 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • phpbug at braten dot beTue, 06 Mar 2018 10:55:23 +0000Bug #61613 [Com]: No PDO error if first SQL statement of a group is valid.
  • requinix@php.netTue, 06 Mar 2018 10:59:21 +0000Bug #61613 [Nab]: No PDO error if first SQL statement of a group is valid.