Edit report at http://bugs.php.net/bug.php?id=36144&edit=1
ID: 36144 Updated by: [email protected] Reported by: php at kanariepiet dot com Summary: only one row when using persistent connections and unbuffered queries -Status: No Feedback +Status: Feedback Type: Bug Package: MySQL related Operating System: Linux PHP Version: 5.1.2 Assigned To: mysql Block user comment: N New Comment: Please try using this snapshot: http://snaps.php.net/php5.3-latest.tar.gz For Windows: http://windows.php.net/snapshots/ Previous Comments: ------------------------------------------------------------------------ [2007-01-04 01:00:00] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2006-12-27 23:43:33] [email protected] Do you still experience this behavior? ------------------------------------------------------------------------ [2006-01-25 10:57:24] [email protected] Assigned to the MySQL support. ------------------------------------------------------------------------ [2006-01-24 15:30:13] php at kanariepiet dot com Description: ------------ Assume you have a webserver serving two PHP scripts. Both PHP scripts use persistent MySQL database connections. Script one uses normal mysql_query calls, script two uses mysql_unbuffered_query calls. Also, script one is doing additional mysql_query calls while retrieving the records of the first mysql_query (yes, an sql join would be better). When script two (the one with mysql_unbuffered_query) finishes, and script one reuses the persistent database connection of script two, the resource identifier in script one gets lost after the first loop, resulting in only one returned row. get_resource_type($res) should return 'mysql result', but will return 'Unknown' Reproduce code: --------------- Script1.html: $db = mysql_pconnect ('host', 'user', 'pass'); print ('We are using MySQL thread: '. mysql_thread_id() .'<br />'); $res = mysql_query ("SELECT * FROM temp.documents"); // table with 1200 records print ('mysql_num_rows() returned '. mysql_num_rows($res) .'<br />'); while ($row = mysql_fetch_assoc ($res)) { $res2 = mysql_query ("SELECT * FROM temp.attachments WHERE document = ". $row['id']); while ($row2 = mysql_fetch_assoc ($res2)) $row['attachments'][] = $row2; $documents[] = $row; } print ('number of documents: '. count ($documents)); Script2.html: $db = mysql_pconnect ('host', 'user', 'pass'); print ('We are using MySQL thread: '. mysql_thread_id() .'<br />'); $res = mysql_unbuffered_query ("SELECT * FROM temp.documents"); while ($row = mysql_fetch_assoc ($res)) { } Expected result: ---------------- Open script2.html and note the thread id. Keep opening script1.html until the thread id is the same as the one script2 used. You should see this: (script2.html) We are using MySQL thread: 1439 (script1.html) We are using MySQL thread: 1439 mysql_num_rows() returned 1200 number of documents: 1200 Actual result: -------------- However, the output will be: (script2.html) We are using MySQL thread: 1439 (script1.html) We are using MySQL thread: 1439 mysql_num_rows() returned 1200 number of documents: 1 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=36144&edit=1
