Edit report at http://bugs.php.net/bug.php?id=52090&edit=1
ID: 52090
Updated by: rasmus@php.net
Reported by: gsx1022 at gmail dot com
Summary: mysql_fetch_assoc returns infinite number of records
Status: Feedback
Type: Bug
Package: MySQL related
Operating System: Linux x86
PHP Version: 5.3.2
New Comment:
Can't afford? As in financially? There are multiple free
virtualization
mechanisms out there and the OS images are free. Setting up a clean vm
on your
existing machine is trivial and takes about 30 minutes, tops.
Previous Comments:
------------------------------------------------------------------------
[2010-07-06 16:20:28] gsx1022 at gmail dot com
In my current situation I cannot afford to set up a test box and try to
compile
the snapshot from php.net. However, I will do so as soon as I can. In
the
meantime here is the source-archive with all patches that I use, from
the Ubuntu
Repositories:
http://archive.ubuntu.com/ubuntu/pool/main/p/php5/php5_5.3.2.orig.tar.gz
Also, I can confirm that the same problem exists on an x64 box with the
same
software versions too. All other requested information (schema,
versions) are
provided in detail on the link in the description.
------------------------------------------------------------------------
[2010-06-23 01:44:41] johannes@php.net
Please use a recent snapshot from our site, we don't know what kind of
patches Ubuntu applies. Please provide the table schema and data you are
querying. Whcih MySQL server version?
------------------------------------------------------------------------
[2010-06-16 13:19:23] gsx1022 at gmail dot com
I am using the php5 package from the Ubuntu Linux APT repository. It
seems to use
libmysql. And yes, mysqli is also affected.
------------------------------------------------------------------------
[2010-06-16 03:51:33] kalle@php.net
Do you use mysqlnd with ext/mysql or libmysql, in either case does it
solve switching the lib?
Is mysqli affected by this issue too on your machine?
------------------------------------------------------------------------
[2010-06-15 21:35:55] gsx1022 at gmail dot com
Description:
------------
A MySQL query that should return 5 records returns an infinite number of
records.
It returns the 5 five records correctly, but then it returns them again,
and
again, and again... Other SELECT statements are fine, this is the only
problematic one. Also, this query works from the MySQL console just
fine. At
first I thought it is an issue with Zend Framework but it turned out it
is
probably not. See this url for (much) more info (also detailed
information to
reproduce): http://framework.zend.com/issues/browse/ZF-9982
Test script:
---------------
$c = mysql_connect('host', 'user', 'pass');
mysql_select_db('db', $c);
$raw = mysql_query('SELECT name, level, parent FROM
allresources_view ORDER BY level ASC');
while ($r = mysql_fetch_assoc($raw)) {
var_dump($r);
echo '<br /><br />';
}
mysql_close($c);
Expected result:
----------------
5 records should have been returned from the database.
Actual result:
--------------
An infinite number of records are returned from the database.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/bug.php?id=52090&edit=1