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

From:	benjamin dot morel at gmail dot com	Date:	Wed, 16 Jul 2014 13:32:15 +0000
Subject:	Bug #61613 [Com]: 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-186665@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
 Comment by:         benjamin dot morel at gmail dot com
 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:

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.


Previous Comments:
------------------------------------------------------------------------
[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)

------------------------------------------------------------------------
[2012-10-29 09:42:41] verger dot antoine at gmail dot com

Hi, 

I have the same issue on 5.4.6 on Ubuntu 12.04 and PDO_MYSQL 5.5.24.

Di you have any idea where it comes from ? I had a look at the source from PDO 
and also from MySQL C API but no clue and above all too hard to find the origin.

I saw that the issue has been assigned to mysql by aharvey@php.net but I don't 
why exactly. Could you explain me ?

Antoine

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


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.