Req #52302 [Asn->Csd]: mysqli_fetch_all does not work with MYSQLI_USE_RESULT
Edit report at http://bugs.php.net/bug.php?id=52302&edit=1
ID: 52302
Updated by: andrey@php.net
Reported by: brianlmoon@php.net
Summary: mysqli_fetch_all does not work with
MYSQLI_USE_RESULT
-Status: Assigned
+Status: Closed
Type: Feature/Change Request
Package: MySQLi related
Operating System: Linux
PHP Version: 5.3.2
Assigned To: mysql
Block user comment: N
New Comment:
Fix will appear in 5.3.4
In any case, it is sub-optimal to use MYSQLI_USE_RESULT with fetch_all,
compared to MYSQLI_STORE_RESULT. However, fetch_all with USE_RESULT
should be faster than manually looping.
Previous Comments:
------------------------------------------------------------------------
[2010-08-09 19:29:32] andrey@php.net
Automatic comment from SVN on behalf of andrey
Revision: http://svn.php.net/viewvc/?view=revision&revision=302045
Log: Fix Request #52302 mysqli_fetch_all does not work with
MYSQLI_USE_RESULT
------------------------------------------------------------------------
[2010-08-05 14:11:27] johannes@php.net
The key point here is that the stored buffer can directly be used for
fetch_all. The fetch_all does nothing but increasing the ref counts on
the buffered values and adding them to an array. doing this with
USE_RESULT would do an implicit STORE_RESULT.
Marking this a Feature request.
------------------------------------------------------------------------
[2010-07-16 17:42:59] brianlmoon@php.net
No, it makes perfect sense. In fact, it should be the preferred way to
use fetch_all. Why store the data only to dump it into a PHP array on
the next line? That is a very inefficient use of memory and plain
careless development.
Or do you mean to say that fetch_all is fundamentally broken and will
only work with STORE_RESULT?
------------------------------------------------------------------------
[2010-07-13 10:36:22] andrey@php.net
Makes no sense to use USE_RESULT and buffer the result. Use
STORE_RESULT, it is more effective for fetch_all(). Artifically limited.
------------------------------------------------------------------------
[2010-07-12 18:16:35] brad at njoe dot com
Confirmed on Windows build as well using: PHP 5.3.2 (cli) (built: Mar 3
2010
19:40:13).
Even SELECT'ing a static string (e.g. SELECT 'This is a test.') exhibits
this
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
http://bugs.php.net/bug.php?id=52302
--
Edit this bug report at http://bugs.php.net/bug.php?id=52302&edit=1
Thread (9 messages)