#28307 [NEW]: Data returned malformed/irratic with mysql 4.1.1-alpha

From: nick at careercast dot com Operating system: Linux PHP version: 4.3.6 PHP Bug Type: MySQL related Bug description: Data returned malformed/irratic with mysql 4.1.1-alpha Description: ------------ We recently recompiled php to upgrade the mysql client to what the same version as our mysql server (4.1.1-alpha-max-log) When we did, mysql_fetch_assoc started producing irratic characters for the column names (like "#B"). Problem is not limited to mysql_fetch_assoc, we also saw issues with mysql_fetch_object. Mysql via command line produces perfect results, it was only when the content was produced via php that there was a problem. We were running php 4.3.3, so we tried upgrading php to 4.3.6 and found that there was no difference. We were forced to revert back to compiling php with mysql client 4.0.13. Configure: ./configure' '--with-xmlrpc' '--enable-xslt' '--with-xslt-sablot=/usr/local/Sablot-1.0' '--with-zlib-dir=/usr/local/zlib-1.1.4/include' '--with-expat-dir=/usr/local/expat-1.95.5' '--with-iconv-dir=/usr/local/iconv-1.9.1' '--with-apxs=/usr/local/apache-1.3.27/bin/apxs' '--with-curl' '--with-mysql=/usr/local/mysql-max-4.1.1-alpha-pc-linux-i686' '--with-gd=/usr/local/gd-2.0.11' '--with-png' '--with-jpeg' '--with-ttf' '--enable-gd-native-ttf' '--with-freetype-dir=/usr/local/freetype-2.1.3' '--with-gettext' Reproduce code: --------------- Specific code is difficult to produce, but it affected multiple applications, so I assume it will be easy to duplicate. For clarity of the problem, I'll provide untested sample code that should reproduce the issue. $dblink=mysql_connect('localhost', 'user', 'pass'); $result=mysql_query("select * from table limit 1", $dblink); $row=mysql_fetch_assoc($result); print_r($row); Expected result: ---------------- Array ( 'column1' => 'value1' 'column2' => 'value2' ... ) Actual result: -------------- Array ( '#B' => 'value1' ' ' => 'value1' ... ) -- Edit bug report at http://bugs.php.net/?id=28307&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=28307&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=28307&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=28307&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=28307&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=28307&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=28307&r=needscript Try newer version: http://bugs.php.net/fix.php?id=28307&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=28307&r=support Expected behavior: http://bugs.php.net/fix.php?id=28307&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=28307&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=28307&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=28307&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=28307&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=28307&r=dst IIS Stability: http://bugs.php.net/fix.php?id=28307&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=28307&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=28307&r=float