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

From:	phpbug at braten dot be	Date:	Tue, 06 Mar 2018 10:55:23 +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-214221@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:         phpbug at braten dot be
 Reported by:        trebitzki at gmx dot net
 Summary:            No PDO error if first SQL statement of a group is
                     valid.
 Status:             Not a bug
 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:

I had to abandon using the "feature" of multiple sql statements in one query because of
this.

So yes, because the feature is buggy, the "simple" solution is not to use it.

But I think it is wrong to leave this as a buggy feature that can't be really used.


Previous Comments:
------------------------------------------------------------------------
[2018-03-06 10:49:36] spam2 at rhsoft dot net

just don't place multiple statements in a single query and then wonder why debug it don't
work that well - it's that easy

------------------------------------------------------------------------
[2018-03-06 10:45:19] phpbug at braten dot be

This bug should be reopened.

It really is a problem when you have several DELETE statements and/or UPDATE statments. It happend
to me yesterday that the 3rd DELETE statment had a bug, and I could not figure out why the records
where still there in my database. No exceptions where thrown.

Does using nextRowset() even work when you are using multiple DELETE statements?

------------------------------------------------------------------------
[2015-09-16 12:41:43] benjamin dot morel at gmail dot com

I don't think the current implementation is really a problem. But the documentation has to be
clear about that, and the fact is, it isn't at the moment.

------------------------------------------------------------------------
[2015-09-16 11:53:26] Daniel at Kraffner dot de

Even if this is considered "by design", the issue should be addressed in someway.
The current situation is inconsistent and quite a lot developers stumble across it, leading to the
visible feedback within this bug report.

Why is an exception thrown right away, if a single statement is executed WITHOUT accessing the
result set? Why does the result set needs to be accessed when multiple queries are executed? 

imho, the implementation should 

- either never throw an exception if the result set is NOT accessed, even if it is a single query.
- or always throw an exception without accessing the result set even for multiple queries.

------------------------------------------------------------------------
[2015-09-16 10:31:26] tony2001@php.net

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to
report
a bug at http://bugs.php.net/how-to-report.php

Since there are two statements and the first one is valid, you have to use nextRowset() and this is
expected behavior.

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


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.