#32405 [Bgs->Csd]: mysqli->fetch() is returning bad data
ID: 32405
Updated by: andrey@php.net
Reported By: paul at thehedron dot com
-Status: Bogus
+Status: Closed
Bug Type: MySQLi related
Operating System: Linux (fedora core 3)
PHP Version: 5CVS-STABLE-2005-03-24
Assigned To: georg
New Comment:
This bug has been fixed in CVS.
Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
Thank you for the report, and for helping us make PHP better.
Thanks for support for fixing this bug on 64 bit platform. It is also
fixed in the 5_0 branch.
Previous Comments:
------------------------------------------------------------------------
[2005-03-30 09:32:18] georg@php.net
Update: The bug only occurs when connecting via TCP/IP - it's a
protocol problem in MySQL (but not a PHP problem).
I will analyze it and file a bug report on bugs.mysql.com
------------------------------------------------------------------------
[2005-03-29 11:47:01] georg@php.net
Can't repeat (user gave me access on this machine):
mysql> use test;
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql> CREATE TABLE users (
-> user_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
-> lastname VARCHAR(50) NOT NULL,
-> PRIMARY KEY(user_id));
Query OK, 0 rows affected (0.02 sec)
mysql> insert into users value (0, 'Paul'), (0, 'Georg');
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> quit
[georg@ascdev ~]$ cat 32405.php
<?php
$mysqli = new mysqli('localhost', 'georg', '', 'test');
if ($stmt = $mysqli->prepare("SELECT user_id, lastname FROM users")) {
$stmt->execute();
$stmt->bind_result($col1, $col2);
while ($stmt->fetch()) {
printf("%s %s\n", $col1, $col2);
}
$stmt->close();
}
$mysqli->close();
?>
[georg@ascdev ~]$ php -f 32405.php
1 Paul
2 Georg
------------------------------------------------------------------------
[2005-03-23 23:48:48] sniper@php.net
Georg, there are several reports open on mysqli already..can you
finally fix the stuff or move the whole thing to sibe..PECL?
------------------------------------------------------------------------
[2005-03-22 20:20:48] paul at thehedron dot com
Pulled down the recommended CVS snapshot, compiled and installed. Info
shows PHP Version 5.0.4RC2-dev.
Ran the same code and got the same result.
------------------------------------------------------------------------
[2005-03-22 00:10:41] tony2001@php.net
Please try using this CVS snapshot:
http://snaps.php.net/php5-STABLE-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.0-win32-latest.zip
------------------------------------------------------------------------
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/32405
--
Edit this bug report at http://bugs.php.net/?id=32405&edit=1
Thread (7 messages)