#30349 [Opn->Csd]: MySQL returning false result array when using large query

ID: 30349 User updated by: cgroen at xs4all dot nl Reported By: cgroen at xs4all dot nl -Status: Open +Status: Closed Bug Type: MySQL related Operating System: Linux (Debian Sarge) PHP Version: 5.0.2 New Comment: Guess it's not a bug.. Started thinking about it and looked up the mysql_fetch_array description.. The lower index numbers are the indexes the function adds (mysql_fetch_array returns an array with both associative and numbered keys).. What still remains is the question why PHP versions prior to 5.0.2 didn't have a problem with this ? Somehow 5.0.2 implements the mysql_fetch_array function different from it's predecessors.. Previous Comments: ------------------------------------------------------------------------ [2004-10-07 05:17:28] cgroen at xs4all dot nl 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 this bug report at http://bugs.php.net/?id=30349&edit=1