From: cgroen at xs4all dot nl Operating system: Linux (Debian Sarge) PHP version: 5.0.2 PHP Bug Type: MySQL related Bug description: MySQL returning false result array when using large query
Description: ------------ Mysql version: 4.1.4-gamma-standard-log PHP version: 5.0.2 PHP config: /configure --with-apxs=/usr/bin/apxs --with-mysqli=/usr/bin/mysql_config --with-oci8=/usr/local/oracle/product/8.1.7 --with-config-file-path=/etc I have built a PHP program that automatically builds very complex queries and parses them.. Up until version 5.0.1 of PHP, everything worked fine but since I installed 5.0.2 everything falls apart.. When running a very big/complex query, somehow the result array gets mangled.. It contains index numbers that where never in the query to begin with (like in the query below, it returns indexes ranging from 1 till 565) and index numbers that should have values don't.. This is the case with both MySQL and MySQLi.. Like I said, everything worked fine with PHP 5.0.1, it's just 5.0.2 that has this problem.. When running the query in MySQL client everything goes well and the right values are assigned to the right columns.. Hope I made the problem clear.. Regards, Carlos Reproduce code: --------------- http://www.gris.nl/code.html Expected result: ---------------- An associative array with the column numbers specified in the query as index keys for the appropriate values.. Actual result: -------------- An array with non existing keys (in the query) and with keys that point to the wrong column's result.. -- Edit bug report at http://bugs.php.net/?id=30349&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30349&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30349&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30349&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=30349&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=30349&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=30349&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=30349&r=needscript Try newer version: http://bugs.php.net/fix.php?id=30349&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=30349&r=support Expected behavior: http://bugs.php.net/fix.php?id=30349&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=30349&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=30349&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=30349&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30349&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=30349&r=dst IIS Stability: http://bugs.php.net/fix.php?id=30349&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=30349&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=30349&r=float MySQL Configuration Error: http://bugs.php.net/fix.php?id=30349&r=mysqlcfg