#42378 [Asn]: bind_result memory exhaustion

ID: 42378 User updated by: jullrich at sans dot org Reported By: jullrich at sans dot org Status: Assigned Bug Type: MySQLi related Operating System: Linux (CentOS 4.5) PHP Version: 5.2.3 Assigned To: andrey New Comment: mysql version: 5.0.26-max-log mysql is running on a SUSE Enterprise server Version 10 (x86_64). Previous Comments: ------------------------------------------------------------------------ [2007-09-04 18:22:08] uwendel at mysql dot com Bug is verified. I can reproduce it on a box with PHP5.2.4RC1-dev and MySQL 5.1.20-beta. ------------------------------------------------------------------------ [2007-09-04 16:50:12] uwendel at mysql dot com Thanks! May I also ask you for the MySQL Server version? I've written a test which reads 100 rows from a table which has a column that I use FORMAT() on. The test checks all *INT* types, FLOAT and DECIMAL. So far I have not been able to reproduce your problem with PHP 5_2 CVS and PHP 6. I'll give it another try with your table definition... ------------------------------------------------------------------------ [2007-09-03 18:55:58] jullrich at sans dot org as requested, the table definition: CREATE TABLE trends ( targetport int(11) NOT NULL default '0', sources double(17,4) default NULL, current_sources double(17,0) default NULL, reports double(17,4) default NULL, current_reports double(17,0) default NULL, targets double(17,4) default NULL, current_targets double(17,0) default NULL, maxsources int(11) default NULL, maxtargets int(11) default NULL, maxreports int(11) default NULL, trend float default NULL, PRIMARY KEY (targetport) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ------------------------------------------------------------------------ [2007-09-03 14:52:13] uwendel at mysql dot com Can you add the table definition to the bug report? ------------------------------------------------------------------------ [2007-08-23 10:42:28] jani@php.net Assigned to the Mysqli maintainer. ------------------------------------------------------------------------ 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/42378 -- Edit this bug report at http://bugs.php.net/?id=42378&edit=1