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

From:	jonwage at gmail dot com	Date:	Wed, 01 Aug 2012 19:40:01 +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-172376@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:         jonwage 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:             Open
 Type:               Bug
 Package:            PDO related
 Operating System:   Mac OS X
 PHP Version:        5.3.10
 Block user comment: N
 Private report:     N

 New Comment:

I am experiencing the same issue. Tested on 5.3.5 and 5.3.10 currently.


Previous Comments:
------------------------------------------------------------------------
[2012-04-11 23:27:03] trebitzki at gmx dot net

I'm working on 1and1 server with PDO Driver for MySQL, client library version	5.1.49; locally
on Mac with PDO Driver for MySQL Client API version mysqlnd 5.0.7-dev - 091210 - $Revision: 304625
$. Both environments show this issue.

------------------------------------------------------------------------
[2012-04-11 15:08:20] johannes@php.net

Which PDO driver are you using?

------------------------------------------------------------------------
[2012-04-03 22:57:20] trebitzki at gmx dot net

Description:
------------
I am submitting a group of two SQL statements to PDO. The first is valid, the second has a syntax
error. PDO should throw an exception but doesn't. It only throws an exception when the first
statement is invalid.

Test script:
---------------
//[symfony 1.4 environment]
$conn = Propel::getConnection();
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo_statement = $conn->prepare('SELECT 1; invalidstatement');
$pdo_statement->execute();


Expected result:
----------------
I expect to have an error thrown since the group of statements has a syntax error.

Actual result:
--------------
No error is thrown.


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



-- 
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.