ID:               39618
 Updated by:       tony2001@[...].net
 Reported By:      randy at rcs-comp dot com
 Status:           Open
-Bug Type:         PDO related
+Bug Type:         Documentation problem
 Operating System: Windows XP
 PHP Version:      5.2.0
 New Comment:

> It may be true that SQLite works this way, but if that is 
> the case, then PHP should work around this for the SQLite2 
> driver so that the PDO interface is consistant. 

.. or document it.
Please let developers to decide what to do with such kind of problems.


Previous Comments:
------------------------------------------------------------------------

[2006-11-28 14:44:50] randy at rcs-comp dot com

"Since this is the way SQLite works, we can't fix it in PHP and this
should be documented."

It may be true that SQLite works this way, but if that is the case,
then PHP should work around this for the SQLite2 driver so that the PDO
interface is consistant.  The PHP developer should not have to be
concerned with driver specific details like this.

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

[2006-11-28 14:42:34] randy at rcs-comp dot com

Tony,

Sorry, I am not going to let this one drop unless someone else chimes
in.  I have been around bugs.php.net to know that you are reluctant to
fix bugs that are truly bugs.  Case in point:

http://bugs.php.net/bug.php?id=37846

This is a bug and not a documentation problem!

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

[2006-11-28 14:39:00] randy at rcs-comp dot com

Another reason it is a bug is because the PDO SQLite2 driver is
inconsistent itself!

Notice that the bug only appears after a prepared statement is
requested.  If this is not a bug, then under "Actual Results" I should
have:

> php simple_pdo_test3.php
rows updated w/ exec() (some): 2 2
rows updated w/ exec() (all): 3 3 //<-- if truly not a bug, then this
should say "3 5"
statement preped and all records retrieved
rows updated w/ exec() (some): 2 2
rows updated w/ exec() (all): 3 5 
rows updated w/ exec() (some): 2 7
rows updated w/ prep & execute() (all): 3 3

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

[2006-11-28 14:36:08] tony2001@[...].net

The very same issue in SQLite bug db
(http://www.sqlite.org/cvstrac/tktview?tn=383) has beem resolved by
adding it to the docs.
If you think it's wrong, then you can report it to SQLite developers
and persuade them to fix it in SQLite.

Since this is the way SQLite works, we can't fix it in PHP and this
should be documented.

> If you insist that this is a documentation problem
Yes, I do.

> will you please have another PHP developer chime in and agree with
you.
No, thank you.

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

[2006-11-28 14:26:33] randy at rcs-comp dot com

THIS IS NOT A DOCUMENTATION PROBLEM!!!  The documentation describes the
best way for the function to work.

It is a problem with a PDO driver not working like every other PDO
driver!  What is the point of a database abstraction layer if you can't
rely upon it to be consistent across drivers!!!!

If you insist that this is a documentation problem, will you please
have another PHP developer chime in and agree with you.  If so, I will
leave the bug report alone.

Thank you.

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

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
    http://bugs.php.net/39618

-- 
Edit this bug report at http://bugs.php.net/?id=39618&edit=1